ITPub博客

首页 > 数据库 > 数据库开发技术 > db2数据库查看表空间使用的是文件系统和裸设备情况

db2数据库查看表空间使用的是文件系统和裸设备情况

原创 数据库开发技术 作者:湖湘文化 时间:2014-06-12 21:12:04 0 删除 编辑
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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 新城市新工作
请登录后发表评论 登录
全部评论

注册时间:2009-05-31

  • 博文量
    108
  • 访问量
    1523039