[db2inst1@db2node ~]$ db2pd -d sample -tab Database Partition 0 -- Database SAMPLE -- Active -- Up 0 days 00:00:06Tablespace Configuration:Address Id Type Content PageSz ExtentSz Auto Pr...显示全部
[db2inst1@db2node ~]$ db2pd -d sample -tab
Database Partition 0 -- Database SAMPLE -- Active -- Up 0 days 00:00:06
Tablespace Configuration:
Address Id Type Content PageSz ExtentSz Auto Prefetch BufID BufIDDisk FSC NumCntrs MaxStripe LastConsecPg Name
0x00002AC3133F92E0 0 DMS Regular 8192 4 Yes 4 1 1 Off 1 0 3 SYSCATSPACE
0x00002AC3133FA9E0 1 SMS SysTmp 8192 32 Yes 32 1 1 On 1 0 31 TEMPSPACE1
0x00002AC313F01080 2 DMS Large 8192 32 Yes 32 1 1 Off 1 0 31 USERSPACE1
0x00002AC313F02540 3 DMS Large 8192 32 Yes 32 1 1 Off 1 0 31 IBMDB2SAMPLEREL
0x00002AC313F03A00 4 DMS Large 8192 32 Yes 32 1 1 Off 1 0 31 IBMDB2SAMPLEXML
0x00002AC313F04EC0 5 DMS Large 8192 4 Yes 4 1 1 Off 1 0 3 SYSTOOLSPACE
0x00002AC313F06380 6 SMS UsrTmp 8192 4 Yes 4 1 1 On 1 0 3 SYSTOOLSTMPSPACE
Tablespace Statistics:
Address Id TotalPgs UsablePgs UsedPgs PndFreePgs FreePgs HWM Max HWM State MinRecTime NQuiescers PathsDropped
0x00002AC3133F92E0 0 12288 12284 10576 0 1708 10576 10576 0x00000000 0 0 No
0x00002AC3133FA9E0 1 1 1 1 0 0 0 0 0x00000000 0 0 No
0x00002AC313F01080 2 4096 4064 1824 0 2240 1824 1824 0x00000000 0 0 No
0x00002AC313F02540 3 4096 4064 672 0 3392 672 672 0x00000000 0 0 No
0x00002AC313F03A00 4 4096 4064 1440 0 2624 1440 1440 0x00000000 0 0 No
0x00002AC313F04EC0 5 4096 4092 108 0 3984 108 108 0x00000000 0 0 No
0x00002AC313F06380 6 1 1 1 0 0 0 0 0x00000000 0 0 No收起