表空间自动扩展前的报警信息：
10.01.2014 13:20:05 QB1ARLA DB2 Universal Database for NT/UNIX DMS managed tablespaces Not enough free space available QB1#BTABI ACTION_REQUIRED QB1ARLA\DB2 Universal Database for NT/UNIX\...\DMS managed tablespaces\QB1#BTABI 3 110 00:00:00 QB1#BTABI 10.01.2014 12:20:05 SAP-T100 DB6 702 100 95 % 1 000 IBMDRIFT
10.01.2014 13:20:05 QB1ARLA DB2 Universal Database for NT/UNIX DMS managed tablespaces Not enough free space available QB1#STABI ACTION_REQUIRED QB1ARLA\DB2 Universal Database for NT/UNIX\...\DMS managed tablespaces\QB1#STABI 3 110 00:00:00 QB1#STABI 10.01.2014 12:20:05 SAP-T100 DB6 702 100 95 % 1 000 IBMDRIFT
报警日期是10.01.2014；
表空间自动扩展后的信息：
arlqsap05:db2qb1 1> db2pd -d qb1 -tablespaces
Database Partition 0 -- Database QB1 -- Active -- Up 332 days 14:50:56 -- Date 01/13/2014 03:30:48
Tablespace Configuration:
Address Id Type Content PageSz ExtentSz Auto Prefetch BufID BufIDDisk FSC NumCntrs MaxStripe LastConsecPg Name
0x0A000200119FCF00 6 DMS Large 4096 16 No 16 1 1 On 10 0 15 QB1#STABI
0x0A00020011A02340 8 DMS Large 4096 8 No 8 1 1 On 10 0 7 QB1#BTABI
Tablespace Statistics:
Address Id TotalPgs UsablePgs UsedPgs PndFreePgs FreePgs HWM Max HWM State MinRecTime NQuiescers PathsDropped
0x0A000200119FCF00 6 2475680 2475520 2472640 0 2880 2472640 2472640 0x00000000 1194700762 0 No
0x0A00020011A02340 8 1315680 1315600 1308128 0 7472 1308128 1308128 0x00000000 1194700719 0 No
Tablespace Autoresize Statistics:
Address Id AS AR InitSize IncSize IIP MaxSize LastResize LRF
0x0A000200119FCF00 6 No Yes 0 -1 No None 01/12/2014 14:08:03.572699 No
0x0A00020011A02340 8 No Yes 0 -1 No None 01/13/2014 00:08:00.393936 No
Containers:
Address TspId ContainNum Type TotalPgs UseablePgs PathID StripeSet Container
0x0A000200119FE460 6 0 File 247568 247552 - 0 /db2/QB1/sapdata1/NODE0000/QB1#STABI.container001
0x0A000200119FE670 6 1 File 247568 247552 - 0 /db2/QB1/sapdata2/NODE0000/QB1#STABI.container002
0x0A000200119FE880 6 2 File 247568 247552 - 0 /db2/QB1/sapdata3/NODE0000/QB1#STABI.container003
0x0A000200119FEA90 6 3 File 247568 247552 - 0 /db2/QB1/sapdata4/NODE0000/QB1#STABI.container004
0x0A000200119FECA0 6 4 File 247568 247552 - 0 /db2/QB1/sapdata5/NODE0000/QB1#STABI.container005
0x0A000200119FEEB0 6 5 File 247568 247552 - 0 /db2/QB1/sapdata6/NODE0000/QB1#STABI.container006
0x0A000200119FF0C0 6 6 File 247568 247552 - 0 /db2/QB1/sapdata7/NODE0000/QB1#STABI.container007
0x0A000200119FF2D0 6 7 File 247568 247552 - 0 /db2/QB1/sapdata8/NODE0000/QB1#STABI.container008
0x0A000200119FF4E0 6 8 File 247568 247552 - 0 /db2/QB1/sapdata9/NODE0000/QB1#STABI.container009
0x0A000200119FF6F0 6 9 File 247568 247552 - 0 /db2/QB1/sapdata10/NODE0000/QB1#STABI.container010
0x0A00020011A038A0 8 0 File 131568 131560 - 0 /db2/QB1/sapdata1/NODE0000/QB1#BTABI.container001
0x0A00020011A03AB0 8 1 File 131568 131560 - 0 /db2/QB1/sapdata2/NODE0000/QB1#BTABI.container002
0x0A00020011A03CC0 8 2 File 131568 131560 - 0 /db2/QB1/sapdata3/NODE0000/QB1#BTABI.container003
0x0A00020011A03ED0 8 3 File 131568 131560 - 0 /db2/QB1/sapdata4/NODE0000/QB1#BTABI.container004
0x0A00020011A040E0 8 4 File 131568 131560 - 0 /db2/QB1/sapdata5/NODE0000/QB1#BTABI.container005
0x0A00020011A042F0 8 5 File 131568 131560 - 0 /db2/QB1/sapdata6/NODE0000/QB1#BTABI.container006
0x0A00020011A04500 8 6 File 131568 131560 - 0 /db2/QB1/sapdata7/NODE0000/QB1#BTABI.container007
0x0A00020011A04710 8 7 File 131568 131560 - 0 /db2/QB1/sapdata8/NODE0000/QB1#BTABI.container008
0x0A00020011A04920 8 8 File 131568 131560 - 0 /db2/QB1/sapdata9/NODE0000/QB1#BTABI.container009
0x0A00020011A04B30 8 9 File 131568 131560 - 0 /db2/QB1/sapdata10/NODE0000/QB1#BTABI.container010
可以看到LastResize列中，记录了上次的扩展信息（01/12/2014、01/13/2014）；由此证明，在db2pd的表空间信息的输出中，如果表空间的AR列（Auto Resize）设置为Yes，则表空间会自动扩展其大小。
因此，在操作系统空间充足的情况下，对于此类的表空间告警，可以忽略。
阅读(1134) | 评论(0) | 转发(0) |
