如何查看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]$
上一篇: MongoDB数据库常用命令