欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

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

程序员文章站 2022-03-08 23:21:04
如何查看db2表空间对应的物理文件?参考如下: [db2inst1@db MYDB]$ db2 connect to mydb Database Connection...
如何查看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]$