Sunday, July 21, 2013

Create a new database

db2 => create db unicadb
DB20000I  The CREATE DATABASE command completed successfully.

db2 => get  connection state
   Database Connection State
 Connection state       = Connectable and Unconnected
 Connection mode        =
 Local database alias   =
 Database name          =
 Hostname               =
 Service name           =
db2 => connect to unicadb
   Database Connection Information
 Database server        = DB2/NT64 10.1.0
 SQL authorization ID   = ADMINIST...
 Local database alias   = UNICADB
db2 => list tablespaces
           Tablespaces for Current Database
 Tablespace ID                        = 0
 Name                                 = SYSCATSPACE
 Type                                 = Database managed space
 Contents                             = All permanent data. Regular table space.
 State                                = 0x0000
   Detailed explanation:
     Normal
 Tablespace ID                        = 1
 Name                                 = TEMPSPACE1
 Type                                 = System managed space
 Contents                             = System Temporary data
 State                                = 0x0000
   Detailed explanation:
     Normal
 Tablespace ID                        = 2
 Name                                 = USERSPACE1
 Type                                 = Database managed space
 Contents                             = All permanent data. Large table space.
 State                                = 0x0000
   Detailed explanation:
     Normal
 Tablespace ID                        = 3
 Name                                 = SYSTOOLSPACE
 Type                                 = Database managed space
 Contents                             = All permanent data. Large table space.
 State                                = 0x0000
   Detailed explanation:
     Normal


db2 => create regular tablespace unica01 pagesize 4k managed by database using (
file 'D:\DB2\NODE0000\UNICADB\UNICA01.TBS' 20000 )
DB20000I  The SQL command completed successfully.

No comments:

Post a Comment