db2資料庫檢視錶空間使用的是檔案系統和裸裝置情況

湖湘文化發表於2014-06-12
db2資料庫檢視錶空間使用的是檔案系統和裸裝置情況

$ db2 list db directory

 System Database Directory

 Number of entries in the directory = 1

Database 1 entry:

 Database alias                       = TEST
 Database name                        = TEST
 Local database directory             = /home/test
 Database release level               = a.00
 Comment                              =
 Directory entry type                 = Indirect
 Catalog database partition number    = 0
 Alternate server hostname            =
 Alternate server port number         =

 

$ db2 connect to test

   Database Connection Information

 Database server        = DB2/6000 8.2.3
 SQL authorization ID   = DB2INST5
 Local database alias   = OSS

$ db2 list tablespaces

           Tablespaces for Current Database

 Tablespace ID                        = 0
 Name                                 = SYSCATSPACE
 Type                                 = System managed space
 Contents                             = Any data
 State                                = 0x0000
   Detailed explanation:
     Normal

 Tablespace ID                        = 1
 Name                                 = TEMPSPACE1
 Type                                 = Database managed space
 Contents                             = System Temporary data
 State                                = 0x0000
   Detailed explanation:
     Normal

 Tablespace ID                        = 2
 Name                                 = USERSPACE1
 Type                                 = Database managed space
 Contents                             = Any data
 State                                = 0x0000
   Detailed explanation:
     Normal

 Tablespace ID                        = 3
 Name                                 = SYSTOOLSPACE
 Type                                 = System managed space
 Contents                             = Any data
 State                                = 0x0000
   Detailed explanation:
     Normal

 Tablespace ID                        = 4
 Name                                 = SYSTOOLSTMPSPACE
 Type                                 = System managed space
 Contents                             = User Temporary data
 State                                = 0x0000
   Detailed explanation:
     Normal


$ db2 list tablespace containers for 0

            Tablespace Containers for Tablespace 0

 Container ID                         = 0
 Name                                 = /home/test/db2inst1/NODE0000/SQL00001/SQLT0000.0
 Type                                 = Path


$ db2 list tablespace containers for 1

            Tablespace Containers for Tablespace 1

 Container ID                         = 0
 Name                                 = /dev/rlv001
 Type                                 = Disk

......


來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/21256317/viewspace-1181717/,如需轉載,請註明出處,否則將追究法律責任。

相關文章