Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

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 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.