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