频道栏目
首页 > 资讯 > DB2 > 正文

如何查看db2表空间对应的物理文件?

17-10-30        来源:[db:作者]  
收藏   我要投稿

如何查看db2表空间对应的物理文件?参考如下:

[db2inst1@db MYDB]$ db2 connect to mydb
   Database Connection Information
 Database server        = DB2/LINUXX8664 9.7.0
 SQL authorization ID   = DB2INST1
 Local database alias   = MYDB

[db2inst1@db MYDB]$ db2 list tablespaces show detail
           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
 Total pages                          = 32768
 Useable pages                        = 32764
 Used pages                           = 28932
 Free pages                           = 3832
 High water mark (pages)              = 28932
 Page size (bytes)                    = 4096
 Extent size (pages)                  = 4
 Prefetch size (pages)                = 4
 Number of containers                 = 1


 Tablespace ID                        = 1
 Name                                 = TEMPSPACE1
 Type                                 = System managed space
 Contents                             = System Temporary data
 State                                = 0x0000
   Detailed explanation:
     Normal
 Total pages                          = 1
 Useable pages                        = 1
 Used pages                           = 1
 Free pages                           = Not applicable
 High water mark (pages)              = Not applicable
 Page size (bytes)                    = 4096
 Extent size (pages)                  = 32
 Prefetch size (pages)                = 32
 Number of containers                 = 1


 Tablespace ID                        = 2
 Name                                 = USERSPACE1
 Type                                 = Database managed space
 Contents                             = All permanent data. Large table space.
 State                                = 0x0000
   Detailed explanation:
     Normal
 Total pages                          = 24576
 Useable pages                        = 24544
 Used pages                           = 10560
 Free pages                           = 13984
 High water mark (pages)              = 17280
 Page size (bytes)                    = 4096
 Extent size (pages)                  = 32
 Prefetch size (pages)                = 32
 Number of containers                 = 1
 Minimum recovery time                = 2014-02-23-07.48.09.000000


 Tablespace ID                        = 3
 Name                                 = SYSTOOLSPACE
 Type                                 = Database managed space
 Contents                             = All permanent data. Large table space.
 State                                = 0x0000
   Detailed explanation:
     Normal
 Total pages                          = 8192
 Useable pages                        = 8188
 Used pages                           = 184
 Free pages                           = 8004
 High water mark (pages)              = 184
 Page size (bytes)                    = 4096
 Extent size (pages)                  = 4
 Prefetch size (pages)                = 4
 Number of containers                 = 1


 Tablespace ID                        = 4
 Name                                 = SDCSM_TABLE_SPACE
 Type                                 = Database managed space
 Contents                             = All permanent data. Large table space.
 State                                = 0x0000
   Detailed explanation:
     Normal
 Total pages                          = 22528
 Useable pages                        = 22512
 Used pages                           = 21840
 Free pages                           = 672
 High water mark (pages)              = 21840
 Page size (bytes)                    = 32768
 Extent size (pages)                  = 16
 Prefetch size (pages)                = 16
 Number of containers                 = 1
 Minimum recovery time                = 2014-02-23-07.48.48.000000


 Tablespace ID                        = 5
 Name                                 = SYSTOOLSTMPSPACE
 Type                                 = System managed space
 Contents                             = User Temporary data
 State                                = 0x0000
   Detailed explanation:
     Normal
 Total pages                          = 1
 Useable pages                        = 1
 Used pages                           = 1
 Free pages                           = Not applicable
 High water mark (pages)              = Not applicable
 Page size (bytes)                    = 32768
 Extent size (pages)                  = 16
 Prefetch size (pages)                = 16
 Number of containers                 = 1


 Tablespace ID                        = 6
 Name                                 = MYSYSTEMP
 Type                                 = System managed space
 Contents                             = System Temporary data
 State                                = 0x0000
   Detailed explanation:
     Normal
 Total pages                          = 1
 Useable pages                        = 1
 Used pages                           = 1
 Free pages                           = Not applicable
 High water mark (pages)              = Not applicable
 Page size (bytes)                    = 32768
 Extent size (pages)                  = 32
 Prefetch size (pages)                = 32
 Number of containers                 = 1
 Minimum recovery time                = 2012-03-02-08.15.37.000000




[db2inst1@db MYDB]$ db2pd -tablespaces -db mydb

Database Partition 0 -- Database MYDB -- Active -- Up 0 days 00:14:13
Tablespace Configuration:
...


Containers:
Address            TspId ContainNum Type    TotalPgs   UseablePgs PathID     StripeSet  Container 
0x00002AFEBFBC6080 0     0          File    32768      32764      0          0          /db2data/db2inst1/db2inst1/NODE0000/MYDB/T0000000/C0000000.CAT
0x00002AFEBFBC7780 1     0          Path    1          1          0          0          /db2data/db2inst1/db2inst1/NODE0000/MYDB/T0000001/C0000000.TMP
0x00002AFEBFBC9A40 2     0          File    24576      24544      0          0          /db2data/db2inst1/db2inst1/NODE0000/MYDB/T0000002/C0000000.LRG
0x00002AFEBFBC9CE0 3     0          File    8192       8188       0          0          /db2data/db2inst1/db2inst1/NODE0000/MYDB/T0000003/C0000000.LRG
0x00002AFEC495FEE0 4     0          File    22528      22512      0          0          /db2data/db2inst1/db2inst1/NODE0000/MYDB/T0000004/C0000000.LRG
0x00002AFEC49615E0 5     0          Path    1          1          0          0          /db2data/db2inst1/db2inst1/NODE0000/MYDB/T0000005/C0000000.UTM
0x00002AFEC4964D00 6     0          Path    1          1          -          0          /db2data/db2inst1/NODE0000/SQL00001/mysystemp
[db2inst1@db MYDB]$ 

 

相关TAG标签
上一篇:数据库中常用的SQL语句
下一篇:Oracle事物特性、什么是动态SQL?
相关文章
图文推荐

关于我们 | 联系我们 | 广告服务 | 投资合作 | 版权申明 | 在线帮助 | 网站地图 | 作品发布 | Vip技术培训 | 举报中心

版权所有: 红黑联盟--致力于做实用的IT技术学习网站