|
Problem IC78661
|
Status: Closed |
DB2 V9.1 CRASH DURING IDENTITY COLUMN PROCESSING in DPF. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Crash during identity column processing.
The problem applies to
a) DPF (partitioned database)
b) identity columns
c) tables that have been dropped or altered
d) static SQL issued after the alter/drop of the table within
the same transaction as the alter/drop.
The db2diag.log in DB2 V9.1 shows the message
43 2011-05-23-09.05.02.701007-300 I2022A1695 LEVEL:
Severe
44 PID : 415322 TID : 1 PROC :
db2agntp (SAMPLE) 0
45 INSTANCE: db2inst NODE : 000
46 APPHDL : 0-582 APPID:
GA1C61E8.H0C9.110523140502
47 AUTHID : USERID
48 FUNCTION: DB2 UDB, data management,
sqldSeqFetchUpdateGen, probe:1
49 MESSAGE : DTS mismatch: Sequence Request:
50 DATA #1 : Hexdump, 248 bytes
51 0x0FFFFFFFFFFFCC28 : 0000 0000 0000 0000 0000 0011 0000
000B ................
52 0x0FFFFFFFFFFFCC38 : 0000 0001 0000 0000 0000 0000 0000
0001 ................
53 0x0FFFFFFFFFFFCC48 : 0000 0000 0000 0000 0000 0000 0000
2011 .............. .
54 0x0FFFFFFFFFFFCC58 : 0520 0905 0187 8612 0000 0000 0000
0000 . ..............
55 0x0FFFFFFFFFFFCC68 : 0000 0000 0000 0000 0000 0000 0000
0000 ................
56 0x0FFFFFFFFFFFCC78 : 0000 0000 0000 0000 0000 0000 0000
0000 ................
57 0x0FFFFFFFFFFFCC88 : 0000 0000 0000 0000 0000 0000 0000
0000 ................
58 0x0FFFFFFFFFFFCC98 : 0000 0000 0000 0000 0000 0000 0000
0000 ................
59 0x0FFFFFFFFFFFCCA8 : 0002 1F00 0001 0000 0FFF FFFF FFFF
CCF0 ................
60 0x0FFFFFFFFFFFCCB8 : 0000 0000 0000 0000 0000 0000 0000
0000 ................
61 0x0FFFFFFFFFFFCCC8 : 0000 0000 0000 0000 0000 0000 0000
0000 ................
62 0x0FFFFFFFFFFFCCD8 : 0000 0000 0000 0000 0000 0000 0000
0000 ................
63 0x0FFFFFFFFFFFCCE8 : 0000 0000 0000 0000 0000 0000 0000
0000 ................
64 0x0FFFFFFFFFFFCCF8 : 0000 0000 0000 0000 0000 0000 0000
0000 ................
65 0x0FFFFFFFFFFFCD08 : 0000 0000 0000 0000 0000 0000 0000
0000 ................
66 0x0FFFFFFFFFFFCD18 : 0000 0000 0000 0000
........
and eventually the message that marks the database bad
3495 2011-05-23-09.05.02.913135-300 E141962A374 LEVEL:
Severe
3496 PID : 415322 TID : 1 PROC :
db2agntp (SAMPLE) 0
3497 INSTANCE: db2inst NODE : 000
3498 APPHDL : 0-582 APPID:
GA1C61E8.H0C9.110523140502
3499 AUTHID : USERID
3500 FUNCTION: DB2 UDB, base sys utilities, sqleMarkDBad,
probe:10
3501 MESSAGE : ADM7518C "SAMPLE" marked bad.
3502
3503 2011-05-23-09.05.02.913285-300 I142337A387 LEVEL:
Severe
3504 PID : 415322 TID : 1 PROC :
db2agntp (SAMPLE) 0
3505 INSTANCE: db2inst NODE : 000
3506 APPHDL : 0-582 APPID:
GA1C61E8.H0C9.110523140502
3507 AUTHID : USERID
3508 FUNCTION: DB2 UDB, base sys utilities, sqleMarkDBad,
probe:210
3509 MESSAGE : Database logging stopped due to mark db bad.
The corresponding trap file, t415322.000, for PID 415322 shows
the following
...
4984 <StackTrace>
4985 -------Frame------ ------Function + Offset------
4986 0x09000000022E0D08 sqloDumpEDU + 0x14
4987 0x0900000002561678
sqldDumpContext__FP20sqle_agent_privatecbiN42PcPvT2 + 0x130
4988 0x09000000023D85E4 sqlrr_dump_ffdc__FP8sqlrr_cbiT2 +
0x464
4989 0x09000000023D8030
sqlzeDumpFFDC__FP20sqle_agent_privatecbUiP5sqlcai + 0x24
4990 0x09000000023DBD68
sqlzeDumpFFDC__FP20sqle_agent_privatecbUiP5sqlcai@glue6B + 0x7C
4991 0x09000000025E03E0
sqlzeMapZrc__FP20sqle_agent_privatecbUiUlT2P5sqlcai + 0x1A8
4992 0x090000000361312C sqlri_SeqGetNext__FP8sqlrr_cb + 0x320
4993 0x09000000033387E8
sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x4
4994 0x09000000039AE4E4 sqlrr_dss_router__FP8sqlrr_cb + 0x234
4995 0x090000000233E0D4
sqlrr_subagent_router__FP20sqle_agent_privatecbP10sqle_db2ra +
0x4A0
4996 0x09000000021E2278
sqleSubRequestRouter__FP13sqle_agent_cbPUiT2 + 0x420
4997 0x0900000003879A98
sqleProcessSubRequest__FP13sqle_agent_cb + 0x230
4998 0x09000000022DDC7C sqleRunAgent__FPcUi + 0x8E8
4999 0x09000000033E6EE4
sqloCreateEDU__FPFPcUi_vPcUlP13SQLO_EDU_INFOPi + 0x260
5000 0x09000000033E6724 @49@sqloRunGDS__Fv + 0xDC
5001 0x09000000033E5C38 sqloInitEDUServices + 0x17C
5002 0x0900000002AED898
@49@sqloSystemControllerMain__FCUiPFv_iPFi_vPPvCPi + 0x730
5003 0x09000000031FC99C sqloRunInstance + 0xA8
5004 0x00000001000029FC DB2main + 0x934
5005 0x0000000100003D58 main + 0x10
5006 </StackTrace>
...
6692 -------Frame------ ------Function + Offset------
6693 0x09000000022E0D08 sqloDumpEDU + 0x14
6694 0x0900000002186B54 sqleMarkDBad__FP8sqledbcb + 0x1A8
6695 0x0900000003879B70
sqleProcessSubRequest__FP13sqle_agent_cb + 0x308
6696 0x09000000022DDC7C sqleRunAgent__FPcUi + 0x8E8
6697 0x09000000033E6EE4
sqloCreateEDU__FPFPcUi_vPcUlP13SQLO_EDU_INFOPi + 0x260
6698 0x09000000033E6724 @49@sqloRunGDS__Fv + 0xDC
6699 0x09000000033E5C38 sqloInitEDUServices + 0x17C
6700 0x0900000002AED898
@49@sqloSystemControllerMain__FCUiPFv_iPFi_vPPvCPi + 0x730
6701 0x09000000031FC99C sqloRunInstance + 0xA8
6702 0x00000001000029FC DB2main + 0x934
6703 0x0000000100003D58 main + 0x10
6704 </StackTrace>
... |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* The problem applies to *
* a) DPF (partitioned database) *
* b) identity columns *
* c) tables that have been dropped or altered *
* d) static SQL issued after the alter/drop of the table *
* within *
* the same transaction as the alter/drop. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
* Crash during identity column processing. *
* *
* The problem applies to *
* a) DPF (partitioned database) *
* b) identity columns *
* c) tables that have been dropped or altered *
* d) static SQL issued after the alter/drop of the table *
* within *
* the same transaction as the alter/drop. *
* *
* The db2diag.log in DB2 V9.1 shows the message *
* *
* 43 2011-05-23-09.05.02.701007-300 I2022A1695 *
* LEVEL: *
* Severe *
* 44 PID : 415322 TID : 1 *
* PROC : *
* db2agntp (SAMPLE) 0 *
* 45 INSTANCE: db2inst NODE : 000 *
* 46 APPHDL : 0-582 APPID: *
* GA1C61E8.H0C9.110523140502 *
* 47 AUTHID : USERID *
* 48 FUNCTION: DB2 UDB, data management, *
* sqldSeqFetchUpdateGen, probe:1 *
* 49 MESSAGE : DTS mismatch: Sequence Request: *
* 50 DATA #1 : Hexdump, 248 bytes *
* 51 0x0FFFFFFFFFFFCC28 : 0000 0000 0000 0000 0000 0011 *
* 0000 *
* 000B ................ *
* 52 0x0FFFFFFFFFFFCC38 : 0000 0001 0000 0000 0000 0000 *
* 0000 *
* 0001 ................ *
* 53 0x0FFFFFFFFFFFCC48 : 0000 0000 0000 0000 0000 0000 *
* 0000 *
* 2011 .............. . *
* 54 0x0FFFFFFFFFFFCC58 : 0520 0905 0187 8612 0000 0000 *
* 0000 *
* 0000 . .............. *
* 55 0x0FFFFFFFFFFFCC68 : 0000 0000 0000 0000 0000 0000 *
* 0000 *
* 0000 ................ *
* 56 0x0FFFFFFFFFFFCC78 : 0000 0000 0000 0000 0000 0000 *
* 0000 *
* 0000 ................ *
* 57 0x0FFFFFFFFFFFCC88 : 0000 0000 0000 0000 0000 0000 *
* 0000 *
* 0000 ................ *
* 58 0x0FFFFFFFFFFFCC98 : 0000 0000 0000 0000 0000 0000 *
* 0000 *
* 0000 ................ *
* 59 0x0FFFFFFFFFFFCCA8 : 0002 1F00 0001 0000 0FFF FFFF *
* FFFF *
* CCF0 ................ *
* 60 0x0FFFFFFFFFFFCCB8 : 0000 0000 0000 0000 0000 0000 *
* 0000 *
* 0000 ................ *
* 61 0x0FFFFFFFFFFFCCC8 : 0000 0000 0000 0000 0000 0000 *
* 0000 *
* 0000 ................ *
* 62 0x0FFFFFFFFFFFCCD8 : 0000 0000 0000 0000 0000 0000 *
* 0000 *
* 0000 ................ *
* 63 0x0FFFFFFFFFFFCCE8 : 0000 0000 0000 0000 0000 0000 *
* 0000 *
* 0000 ................ *
* 64 0x0FFFFFFFFFFFCCF8 : 0000 0000 0000 0000 0000 0000 *
* 0000 *
* 0000 ................ *
* 65 0x0FFFFFFFFFFFCD08 : 0000 0000 0000 0000 0000 0000 *
* 0000 *
* 0000 ................ *
* 66 0x0FFFFFFFFFFFCD18 : 0000 0000 0000 0000 *
* ........ *
* *
* and eventually the message that marks the database bad *
* *
* 3495 2011-05-23-09.05.02.913135-300 E141962A374 *
* LEVEL: *
* Severe *
* 3496 PID : 415322 TID : 1 *
* PROC : *
* db2agntp (SAMPLE) 0 *
* 3497 INSTANCE: db2inst NODE : 000 *
* 3498 APPHDL : 0-582 APPID: *
* GA1C61E8.H0C9.110523140502 *
* 3499 AUTHID : USERID *
* 3500 FUNCTION: DB2 UDB, base sys utilities, sqleMarkDBad, *
* probe:10 *
* 3501 MESSAGE : ADM7518C "SAMPLE" marked bad. *
* 3502 *
* 3503 2011-05-23-09.05.02.913285-300 I142337A387 *
* LEVEL: *
* Severe *
* 3504 PID : 415322 TID : 1 *
* PROC : *
* db2agntp (SAMPLE) 0 *
* 3505 INSTANCE: db2inst NODE : 000 *
* 3506 APPHDL : 0-582 APPID: *
* GA1C61E8.H0C9.110523140502 *
* 3507 AUTHID : USERID *
* 3508 FUNCTION: DB2 UDB, base sys utilities, sqleMarkDBad, *
* probe:210 *
* 3509 MESSAGE : Database logging stopped due to mark db *
* bad. *
* *
* The corresponding trap file, t415322.000, for PID 415322 *
* shows *
* the following *
* ... *
* 4984 <StackTrace> *
* 4985 -------Frame------ ------Function + Offset------ *
* 4986 0x09000000022E0D08 sqloDumpEDU + 0x14 *
* 4987 0x0900000002561678 *
* sqldDumpContext__FP20sqle_agent_privatecbiN42PcPvT2 + 0x130 *
* 4988 0x09000000023D85E4 sqlrr_dump_ffdc__FP8sqlrr_cbiT2 + *
* 0x464 *
* 4989 0x09000000023D8030 *
* sqlzeDumpFFDC__FP20sqle_agent_privatecbUiP5sqlcai + 0x24 *
* 4990 0x09000000023DBD68 *
* sqlzeDumpFFDC__FP20sqle_agent_privatecbUiP5sqlcai@glue6B + *
* 0x7C *
* 4991 0x09000000025E03E0 *
* sqlzeMapZrc__FP20sqle_agent_privatecbUiUlT2P5sqlcai + 0x1A8 *
* 4992 0x090000000361312C sqlri_SeqGetNext__FP8sqlrr_cb + *
* 0x320 *
* 4993 0x09000000033387E8 *
* sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x4 *
* 4994 0x09000000039AE4E4 sqlrr_dss_router__FP8sqlrr_cb + *
* 0x234 *
* 4995 0x090000000233E0D4 *
* sqlrr_subagent_router__FP20sqle_agent_privatecbP10sqle_db2ra *
* + *
* 0x4A0 *
* 4996 0x09000000021E2278 *
* sqleSubRequestRouter__FP13sqle_agent_cbPUiT2 + 0x420 *
* 4997 0x0900000003879A98 *
* sqleProcessSubRequest__FP13sqle_agent_cb + 0x230 *
* 4998 0x09000000022DDC7C sqleRunAgent__FPcUi + 0x8E8 *
* 4999 0x09000000033E6EE4 *
* sqloCreateEDU__FPFPcUi_vPcUlP13SQLO_EDU_INFOPi + 0x260 *
* 5000 0x09000000033E6724 @49@sqloRunGDS__Fv + 0xDC *
* 5001 0x09000000033E5C38 sqloInitEDUServices + 0x17C *
* 5002 0x0900000002AED898 *
* @49@sqloSystemControllerMain__FCUiPFv_iPFi_vPPvCPi + 0x730 *
* 5003 0x09000000031FC99C sqloRunInstance + 0xA8 *
* 5004 0x00000001000029FC DB2main + 0x934 *
* 5005 0x0000000100003D58 main + 0x10 *
* 5006 </StackTrace> *
* ... *
* 6692 -------Frame------ ------Function + Offset------ *
* 6693 0x09000000022E0D08 sqloDumpEDU + 0x14 *
* 6694 0x0900000002186B54 sqleMarkDBad__FP8sqledbcb + 0x1A8 *
* 6695 0x0900000003879B70 *
* sqleProcessSubRequest__FP13sqle_agent_cb + 0x308 *
* 6696 0x09000000022DDC7C sqleRunAgent__FPcUi + 0x8E8 *
* 6697 0x09000000033E6EE4 *
* sqloCreateEDU__FPFPcUi_vPcUlP13SQLO_EDU_INFOPi + 0x260 *
* 6698 0x09000000033E6724 @49@sqloRunGDS__Fv + 0xDC *
* 6699 0x09000000033E5C38 sqloInitEDUServices + 0x17C *
* 6700 0x0900000002AED898 *
* @49@sqloSystemControllerMain__FCUiPFv_iPFi_vPPvCPi + 0x730 *
* 6701 0x09000000031FC99C sqloRunInstance + 0xA8 *
* 6702 0x00000001000029FC DB2main + 0x934 *
* 6703 0x0000000100003D58 main + 0x10 *
* 6704 </StackTrace> *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 9.7 FP6. *
**************************************************************** |
| Local Fix: |
Workarounds are :
a) commit the drop/alter
b) use declare global temporary table (DGTT).
c) if the failure is within a SQL stored procedure then
recompile the stored procedure by dropping and recreating it. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 14.09.2011
25.06.2012
25.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
