Tablespace Configuration:
Address Id Type Content PageSz ExtentSz Auto Prefetch BufID BufIDDisk FSC NumCntrs MaxStripe LastConsecPg RSE Name
0x00007F7540D86D40 0 DMS Regular 4096 4 Yes 4 1 1 Def 1 0 3 Yes SYSCATSPACE
0x00007F7540D93EE0 1 SMS SysTmp 4096 32 Yes 32 1 1 On 1 0 31 No TEMPSPACE1
0x00007F7540DA1080 2 DMS Large 4096 32 Yes 32 1 1 Def 1 0 31 Yes USERSPACE1
0x00007F7540DAE220 3 SMS Regular 32768 32 Yes 32 2 2 On 1 0 31 No RMIS_SPACE
0x00007F7540DBD3E0 4 SMS SysTmp 32768 32 Yes 32 2 2 On 1 0 31 No RMIS_TEMPSPACE
0x00007F7540DD70C0 5 SMS UsrTmp 32768 32 No 1024 2 2 On 1 0 31 No RMIS_TEMP
0x00007F7540DE4260 6 DMS Large 4096 32 Yes 32 1 1 Off 1 0 31 Yes MONITOR_SPACE
0x00007F7540DF1400 7 DMS Large 4096 4 Yes 4 1 1 Def 1 0 3 Yes SYSTOOLSPACE
Tablespace Statistics:
Address Id TotalPgs UsablePgs UsedPgs PndFreePgs FreePgs HWM Max HWM State MinRecTime NQuiescers PathsDropped TrackmodState
0x00007F7540D86D40 0 57344 57340 53556 0 3784 53556 53556 0x00000000 0 0 No n/a
0x00007F7540D93EE0 1 8 8 8 0 0 - - 0x00000000 0 0 No n/a
0x00007F7540DA1080 2 1015808 1015776 1007744 0 8032 1007744 1007744 0x00000000 1494902897 0 No n/a
0x00007F7540DAE220 3 519 519 519 0 0 - - 0x00000000 0 0 No n/a
0x00007F7540DBD3E0 4 1 1 1 0 0 - - 0x00000000 0 0 No n/a
0x00007F7540DD70C0 5 4 4 4 0 0 - - 0x00000000 0 0 No n/a
0x00007F7540DE4260 6 8192 8160 4960 0 3200 4960 4960 0x00000000 1483065081 0 No n/a
0x00007F7540DF1400 7 8192 8188 296 0 7892 296 296 0x00000000 1478748975 0 No n/a
Tablespace Autoresize Statistics:
Address Id AS AR InitSize IncSize IIP MaxSize LastResize LRF
0x00007F7540D86D40 0 Yes Yes 33554432 -1 No None None No
0x00007F7540D93EE0 1 Yes No 0 0 No 0 None No
0x00007F7540DA1080 2 Yes Yes 33554432 -1 No None 2017-05-24 16:28:35.365041 No
0x00007F7540DAE220 3 No No 0 0 No 0 None No
0x00007F7540DBD3E0 4 No No 0 0 No 0 None No
0x00007F7540DD70C0 5 No No 0 0 No 0 None No
0x00007F7540DE4260 6 Yes Yes 33554432 -1 No None None No
0x00007F7540DF1400 7 Yes Yes 33554432 -1 No None None No
Tablespace Storage Statistics:
Address Id DataTag Rebalance SGID SourceSGID
0x00007F7540D86D40 0 0 No 0 -
0x00007F7540D93EE0 1 0 No 0 -
0x00007F7540DA1080 2 -1 No 0 -
0x00007F7540DAE220 3 0 No - -
0x00007F7540DBD3E0 4 0 No - -
0x00007F7540DD70C0 5 0 No - -
0x00007F7540DE4260 6 -1 No 0 -
0x00007F7540DF1400 7 -1 No 0 -
Containers:
Address TspId ContainNum Type TotalPgs UseablePgs PathID StripeSet Container
0x00007F7540D80120 0 0 File 57344 57340 0 0 /home/db2admin/db2admin/NODE0000/RMISX/T0000000/C0000000.CAT
0x00007F7540DCF000 1 0 Path 8 8 0 0 /home/db2admin/db2admin/NODE0000/RMISX/T0000001/C0000000.TMP
0x00007F7540D5DCE0 2 0 File 1015808 1015776 0 0 /home/db2admin/db2admin/NODE0000/RMISX/T0000002/C0000000.LRG
0x00007F7540D5CA20 3 0 Path 519 519 - 0 /home/db2admin/db2admin/NODE0000/SQL00003/RMIS_SPACE
0x00007F7540D612A0 4 0 Path 1 1 - 0 /home/db2admin/db2admin/NODE0000/SQL00003/RMIS_TEMPSPACE
0x00007F7540D61900 5 0 Path 4 4 - 0 /home/db2admin/db2admin/NODE0000/SQL00003/RMIS_TEMP
0x00007F7540D5AB80 6 0 File 8192 8160 0 0 /home/db2admin/db2admin/NODE0000/RMISX/T0000006/C0000000.LRG
0x00007F7540D54820 7 0 File 8192 8188 0 0 /home/db2admin/db2admin/NODE0000/RMISX/T0000007/C0000000.LRG