IT分销/经销数据库
怎么查看一个表空间是不是自增长的？
有时发现一个表空间不够大了，需要增大表空间！但如果知道表空间是自增长的就可以让你自己增长而不需要增大表空间容器的空间！所以想知道如何查看一个表空间是否自增长！收起
查看其它 13 个回答nanjing_2013的回答
Tablespace Configuration:
Address Id Type Content PageSz ExtentSz Auto Prefetch BufID BufIDDisk FSC NumCntrs MaxStripe LastConsecPg Name
0x7F928E90 0 DMS Regular 8192 4 Yes 4 1 1 Off 1 0 3 SYSCATSPACE
0x7F929680 1 SMS SysTmp 8192 32 Yes 32 1 1 On 1 0 31 TEMPSPACE1
0x7F92DE60 2 DMS Large 8192 32 Yes 32 1 1 Off 1 0 31 USERSPACE1
0x7F92E650 3 DMS Large 8192 32 Yes 32 1 1 Off 1 0 31 IBMDB2SAMPLEREL
0x7F92EE40 4 DMS Large 8192 4 Yes 4 1 1 Off 1 0 3 SYSTOOLSPACE
0x7F92F630 5 DMS Large 8192 32 Yes 32 1 1 Off 1 0 31 IBMDB2SAMPLEXML
0x75FE0060 6 SMS UsrTmp 8192 4 Yes 4 1 1 On 1 0 3 SYSTOOLSTMPSPACE
0x75FE26B0 7 DMS Large 8192 32 Yes 32 1 1 Off 1 0 31 TB_10
Tablespace Autoresize Statistics:
Address Id AS AR InitSize IncSize IIP MaxSize LastResize LRF
0x7F928E90 0 Yes Yes 33554432 -1 No None None No
0x7F929680 1 Yes No 0 0 No 0 None No
0x7F92DE60 2 Yes Yes 33554432 -1 No None None No
0x7F92E650 3 Yes Yes 33554432 -1 No None None No
0x7F92EE40 4 Yes Yes 33554432 -1 No None None No
0x7F92F630 5 Yes Yes 33554432 -1 No None None No
0x75FE0060 6 Yes No 0 0 No 0 None No
0x75FE26B0 7 Yes Yes 33554432 -1 No None None No
AR列为：no的是1，6，两个sms的表空间，代表不自动扩展吗？？
Address Id Type Content PageSz ExtentSz Auto Prefetch BufID BufIDDisk FSC NumCntrs MaxStripe LastConsecPg Name
0x7F928E90 0 DMS Regular 8192 4 Yes 4 1 1 Off 1 0 3 SYSCATSPACE
0x7F929680 1 SMS SysTmp 8192 32 Yes 32 1 1 On 1 0 31 TEMPSPACE1
0x7F92DE60 2 DMS Large 8192 32 Yes 32 1 1 Off 1 0 31 USERSPACE1
0x7F92E650 3 DMS Large 8192 32 Yes 32 1 1 Off 1 0 31 IBMDB2SAMPLEREL
0x7F92EE40 4 DMS Large 8192 4 Yes 4 1 1 Off 1 0 3 SYSTOOLSPACE
0x7F92F630 5 DMS Large 8192 32 Yes 32 1 1 Off 1 0 31 IBMDB2SAMPLEXML
0x75FE0060 6 SMS UsrTmp 8192 4 Yes 4 1 1 On 1 0 3 SYSTOOLSTMPSPACE
0x75FE26B0 7 DMS Large 8192 32 Yes 32 1 1 Off 1 0 31 TB_10
Tablespace Autoresize Statistics:
Address Id AS AR InitSize IncSize IIP MaxSize LastResize LRF
0x7F928E90 0 Yes Yes 33554432 -1 No None None No
0x7F929680 1 Yes No 0 0 No 0 None No
0x7F92DE60 2 Yes Yes 33554432 -1 No None None No
0x7F92E650 3 Yes Yes 33554432 -1 No None None No
0x7F92EE40 4 Yes Yes 33554432 -1 No None None No
0x7F92F630 5 Yes Yes 33554432 -1 No None None No
0x75FE0060 6 Yes No 0 0 No 0 None No
0x75FE26B0 7 Yes Yes 33554432 -1 No None None No
AR列为：no的是1，6，两个sms的表空间，代表不自动扩展吗？？
浏览1597