IBM Support

IV12397: DB2 server may stop abnormally with error DBMarkedBad after executing select statement using distinct keyword.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • DB2 server may stop abnormally with error DBMarkedBad after
    executing select statement using distinct
    keyword. The problem only occurs when the database is created
    using collating sequence "UCA400_LTH".
    
    In db2diag.log we get error messages like below:
    2012-01-09-11.27.52.368733-300 E5358746E614        LEVEL: Severe
    PID     : 21720                TID  : 183333022048 PROC :
    db2sysc
    INSTANCE: xxxxxxxx             NODE : 000          DB   : SBKDB
    APPHDL  : 0-15                 APPID:
    *LOCAL.xxxxxxx.120109162752
    AUTHID  : xxxxxxxx
    EDUID   : 25                   EDUNAME: db2agent (ABCDB)
    FUNCTION: DB2 UDB, sort/list services,
    sqlsBinSortICUsortkeypart, probe:460
    MESSAGE : ZRC=0x870F0031=-2029060047=SQLO_BADS "Bad Address or
    length"
    DATA #1 : <preformatted>
    Error during retrieval of sort key. Input data:
    ..........................................
    UCAInfo: 140 -- 1
    
    2012-01-09-11.27.52.368909-300 I5359361E467        LEVEL: Severe
    PID     : 21720                TID  : 183333022048 PROC :
    db2sysc
    INSTANCE: xxxxxxxx      NODE : 000              DB   : ABCDB
    APPHDL  : 0-15                 APPID:
    *LOCAL.xxxxxxxx.120109162752
    AUTHID  : xxxxxxxx
    EDUID   : 25                   EDUNAME: db2agent (ABCDB)
    FUNCTION: DB2 UDB, sort/list services, sqlsopen, probe:45
    RETCODE : ZRC=0x870F0031=-2029060047=SQLO_BADS "Bad Address or
    length"
    
    
    2012-01-09-11.27.52.796863-300 I5479689E238       LEVEL: Severe
    PID:21720 TID:183333022048 NODE:000 Title: MASTER TIME INFO
    Dump
    File:/home/xxxxxxx/xxxxxxxx/sqllib/db2dump/FODC_DBMarkedBad_2012
    -01-09-11.27.52.787610/21720.25.000.dump.bin
    
    The stack trace back:
      (/view/db2_v95fp5_linuxamd64_s091123/vbs/INST/lib/libdb2e.so.1
    )
    0x0000002A973725E6 _ZN16sqeLocalDatabase9MarkDBBadEi + 0x017e
      (/view/db2_v95fp5_linuxamd64_s091123/vbs/INST/lib/libdb2e.so.1
    )
    0x0000002A98A9A822 _Z21sqlrr_rds_common_postP14db2UCinterfaceiil
    + 0x1684
      (/view/db2_v95fp5_linuxamd64_s091123/vbs/INST/lib/libdb2e.so.1
    )
    0x0000002A96CA3558
    _Z10sqlrr_openP14db2UCinterfaceP15db2UCCursorInfo + 0x098e
      (/view/db2_v95fp5_linuxamd64_s091123/vbs/INST/lib/libdb2e.so.1
    )
    0x0000002A969E8118
    _Z16sqljs_ddm_opnqryP14db2UCinterfaceP13sqljDDMObject + 0x015c
      (/view/db2_v95fp5_linuxamd64_s091123/vbs/INST/lib/libdb2e.so.1
    )
    0x0000002A969DF266
    _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U
    Cinterface + 0x03b2
      (/view/db2_v95fp5_linuxamd64_s091123/vbs/INST/lib/libdb2e.so.1
    )
    0x0000002A969DF5E1
    _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterface + 0x030d
    
    Following stack will be generated
    
    =======================
    0x0900000000589650 pthread_kill + 0xB0
    0x090000009AFBFBE4 sqloDumpEDU + 0xA4
    0x090000007694AD50 sqle_panic__Fv + 0x90
    0x090000007694AE6C sqle_trap__Fv + 0xC
    0x090000009AEED8B8 sqlzAssertFailedValist + 0x258
    0x090000009AEED984 sqlzAssertFailed + 0x64
    0x09000000BE3F81B8
    bsortGetBytesFirstTime__FP8sqeAgentP10SQLS_SLDESP10SQLS_SORTSPUi
    PUcT4P12SQLS_SORTDEFP10SQLS_KEYFDP18SQLS_BSORT_KEYINFOPdiN211_T4
    sT4T11_P17SQLS_BSORT_UCA_CBN24Pi + 0x1458
    0x09000000BE3F96E8
    bsortGetFirstPartialKey__FP8sqeAgentPUcPUiP10SQLS_SLDESP10SQLS_S
    ORTSiUiT3PiPUl + 0x688
    0x09000000BDC47500
    sqlsBinSort__FP8sqeAgentP10SQLS_SLDESP10SQLS_SORTS + 0xA20
    0x09000000BDC20594
    sqlsUseBinSort__FP8sqeAgentP10SQLS_SLDESP10SQLS_SORTSi + 0x54
    0x09000000BE2AD288
    sqlsopen__FP8sqeAgentiT2P10SQLD_DPREDT2PP8SQLD_CCBPcPUcP12sqlri_
    vectorPP10SQLD_VALUE + 0x6A8
    0x09000000BC21C09C
    sqlrsopen__FP8sqlrr_cbP9sqlri_taoiT3P10sqlri_iudo + 0x19C
    0x09000000BCB9A764 sqlrisrt__FP8sqlrr_cb + 0x464
    0x09000000BC451C60 sqlriExecThread__FP8sqlrr_cbP12sqlri_opparm +
    0x500
    0x09000000BC4526D0 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +
    0x4F0
    0x09000000BCC145B0
    sqlrr_process_fetch_request__FP14db2UCinterface + 0xDF0
    0x09000000BCC1833C
    sqlrr_open__FP14db2UCinterfaceP15db2UCCursorInfo + 0xD9C
    0x090000003DE3E7AC
    sqljs_ddm_opnqry__FP14db2UCinterfaceP13sqljDDMObject + 0x1EC
    0x090000003DDD5C38
    sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
    interface + 0x238
    0x090000003DDD4B54
    sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface + 0x1F4
    0x090000003DDC270C sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb +
    0x3EC
    0x090000003DDC3D7C
    sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x15C
    0x090000003DDC9C4C
    sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x2EC
    0x090000003DDCBB64 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T +
    0x264
    0x090000007693E8AC RunEDU__8sqeAgentFv + 0x3AC
    0x090000009B1E04D8 EDUDriver__9sqzEDUObjFv + 0x138
    0x090000009B1E06DC sqlzRunEDU__FPcUi + 0x3C
    0x090000009AFC85DC sqloEDUEntry + 0x67Cyes
    

Local fix

  • Disable Binary Sort by setting db2 registry:
    db2set DB2_BINSORT=false
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users using 97fp8 or below db2level can be affected          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * DB2 server may stop abnormally with error DBMarkedBad after  *
    * executing select statement using distinct                    *
    * keyword. The problem only occurs when the database is        *
    * created                                                      *
    * using collating sequence "UCA400_LTH".                       *
    *                                                              *
    * In db2diag.log we get error messages like below:             *
    * 2012-01-09-11.27.52.368733-300 E5358746E614        LEVEL:    *
    * Severe                                                       *
    * PID    : 21720                TID  : 183333022048 PROC :     *
    * db2sysc                                                      *
    * INSTANCE: xxxxxxxx            NODE : 000          DB  :      *
    * SBKDB                                                        *
    * APPHDL  : 0-15                APPID:                         *
    * *LOCAL.xxxxxxx.120109162752                                  *
    * AUTHID  : xxxxxxxx                                           *
    * EDUID  : 25                  EDUNAME: db2agent (ABCDB)       *
    * FUNCTION: DB2 UDB, sort/list services,                       *
    * sqlsBinSortICUsortkeypart, probe:460                         *
    * MESSAGE : ZRC=0x870F0031=-2029060047=SQLO_BADS "Bad Address  *
    * or                                                           *
    * length"                                                      *
    * DATA #1 : <preformatted>                                     *
    * Error during retrieval of sort key. Input data:              *
    * ..........................................                   *
    * UCAInfo: 140 -- 1                                            *
    *                                                              *
    * 2012-01-09-11.27.52.368909-300 I5359361E467        LEVEL:    *
    * Severe                                                       *
    * PID    : 21720                TID  : 183333022048 PROC :     *
    * db2sysc                                                      *
    * INSTANCE: xxxxxxxx      NODE : 000              DB  : ABCDB  *
    * APPHDL  : 0-15                APPID:                         *
    * *LOCAL.xxxxxxxx.120109162752                                 *
    * AUTHID  : xxxxxxxx                                           *
    * EDUID  : 25                  EDUNAME: db2agent (ABCDB)       *
    * FUNCTION: DB2 UDB, sort/list services, sqlsopen, probe:45    *
    * RETCODE : ZRC=0x870F0031=-2029060047=SQLO_BADS "Bad Address  *
    * or                                                           *
    * length"                                                      *
    *                                                              *
    *                                                              *
    * 2012-01-09-11.27.52.796863-300 I5479689E238      LEVEL:      *
    * Severe                                                       *
    * PID:21720 TID:183333022048 NODE:000 Title: MASTER TIME INFO  *
    * Dump                                                         *
    * File:/home/xxxxxxx/xxxxxxxx/sqllib/db2dump/FODC_DBMarkedBad_ *
    * 2012                                                         *
    * -01-09-11.27.52.787610/21720.25.000.dump.bin                 *
    *                                                              *
    * The stack trace back:                                        *
    *                                                              *
    * (/view/db2_v95fp5_linuxamd64_s091123/vbs/INST/lib/libdb2e.so *
    * .1                                                           *
    * )                                                            *
    * 0x0000002A973725E6 _ZN16sqeLocalDatabase9MarkDBBadEi +       *
    * 0x017e                                                       *
    *                                                              *
    * (/view/db2_v95fp5_linuxamd64_s091123/vbs/INST/lib/libdb2e.so *
    * .1                                                           *
    * )                                                            *
    * 0x0000002A98A9A822                                           *
    * _Z21sqlrr_rds_common_postP14db2UCinterfaceiil                *
    * + 0x1684                                                     *
    *                                                              *
    * (/view/db2_v95fp5_linuxamd64_s091123/vbs/INST/lib/libdb2e.so *
    * .1                                                           *
    * )                                                            *
    * 0x0000002A96CA3558                                           *
    * _Z10sqlrr_openP14db2UCinterfaceP15db2UCCursorInfo + 0x098e   *
    *                                                              *
    * (/view/db2_v95fp5_linuxamd64_s091123/vbs/INST/lib/libdb2e.so *
    * .1                                                           *
    * )                                                            *
    * 0x0000002A969E8118                                           *
    * _Z16sqljs_ddm_opnqryP14db2UCinterfaceP13sqljDDMObject +      *
    * 0x015c                                                       *
    *                                                              *
    * (/view/db2_v95fp5_linuxamd64_s091123/vbs/INST/lib/libdb2e.so *
    * .1                                                           *
    * )                                                            *
    * 0x0000002A969DF266                                           *
    * _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14 *
    * db2U                                                         *
    * Cinterface + 0x03b2                                          *
    *                                                              *
    * (/view/db2_v95fp5_linuxamd64_s091123/vbs/INST/lib/libdb2e.so *
    * .1                                                           *
    * )                                                            *
    * 0x0000002A969DF5E1                                           *
    * _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterface + 0x030d     *
    *                                                              *
    * Following stack will be generated                            *
    *                                                              *
    * =======================                                      *
    * 0x0900000000589650 pthread_kill + 0xB0                       *
    * 0x090000009AFBFBE4 sqloDumpEDU + 0xA4                        *
    * 0x090000007694AD50 sqle_panic__Fv + 0x90                     *
    * 0x090000007694AE6C sqle_trap__Fv + 0xC                       *
    * 0x090000009AEED8B8 sqlzAssertFailedValist + 0x258            *
    * 0x090000009AEED984 sqlzAssertFailed + 0x64                   *
    * 0x09000000BE3F81B8                                           *
    * bsortGetBytesFirstTime__FP8sqeAgentP10SQLS_SLDESP10SQLS_SORT *
    * SPUi                                                         *
    * PUcT4P12SQLS_SORTDEFP10SQLS_KEYFDP18SQLS_BSORT_KEYINFOPdiN21 *
    * 1_T4                                                         *
    * sT4T11_P17SQLS_BSORT_UCA_CBN24Pi + 0x1458                    *
    * 0x09000000BE3F96E8                                           *
    * bsortGetFirstPartialKey__FP8sqeAgentPUcPUiP10SQLS_SLDESP10SQ *
    * LS_S                                                         *
    * ORTSiUiT3PiPUl + 0x688                                       *
    * 0x09000000BDC47500                                           *
    * sqlsBinSort__FP8sqeAgentP10SQLS_SLDESP10SQLS_SORTS + 0xA20   *
    * 0x09000000BDC20594                                           *
    * sqlsUseBinSort__FP8sqeAgentP10SQLS_SLDESP10SQLS_SORTSi +     *
    * 0x54                                                         *
    * 0x09000000BE2AD288                                           *
    * sqlsopen__FP8sqeAgentiT2P10SQLD_DPREDT2PP8SQLD_CCBPcPUcP12sq *
    * lri_                                                         *
    * vectorPP10SQLD_VALUE + 0x6A8                                 *
    * 0x09000000BC21C09C                                           *
    * sqlrsopen__FP8sqlrr_cbP9sqlri_taoiT3P10sqlri_iudo + 0x19C    *
    * 0x09000000BCB9A764 sqlrisrt__FP8sqlrr_cb + 0x464             *
    * 0x09000000BC451C60                                           *
    * sqlriExecThread__FP8sqlrr_cbP12sqlri_opparm +                *
    * 0x500                                                        *
    * 0x09000000BC4526D0                                           *
    * sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +                *
    * 0x4F0                                                        *
    * 0x09000000BCC145B0                                           *
    * sqlrr_process_fetch_request__FP14db2UCinterface + 0xDF0      *
    * 0x09000000BCC1833C                                           *
    * sqlrr_open__FP14db2UCinterfaceP15db2UCCursorInfo + 0xD9C     *
    * 0x090000003DE3E7AC                                           *
    * sqljs_ddm_opnqry__FP14db2UCinterfaceP13sqljDDMObject + 0x1EC *
    * 0x090000003DDD5C38                                           *
    * sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14d *
    * b2UC                                                         *
    * interface + 0x238                                            *
    * 0x090000003DDD4B54                                           *
    * sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface + 0x1F4       *
    * 0x090000003DDC270C sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb *
    * +                                                            *
    * 0x3EC                                                        *
    * 0x090000003DDC3D7C                                           *
    * sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x15C     *
    * 0x090000003DDC9C4C                                           *
    * sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x2EC      *
    * 0x090000003DDCBB64 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T *
    * +                                                            *
    * 0x264                                                        *
    * 0x090000007693E8AC RunEDU__8sqeAgentFv + 0x3AC               *
    * 0x090000009B1E04D8 EDUDriver__9sqzEDUObjFv + 0x138           *
    * 0x090000009B1E06DC sqlzRunEDU__FPcUi + 0x3C                  *
    * 0x090000009AFC85DC sqloEDUEntry + 0x67Cyes                   *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2V95fp9                                         *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IV12397

  • Reported component name

    DB2 EDE AIX

  • Reported component ID

    5724N7600

  • Reported release

    950

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-12-19

  • Closed date

    2012-03-08

  • Last modified date

    2012-03-08

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC80732 IC84241

Fix information

Applicable component levels

  • R910 PSN

       UP

  • R910 PSY

       UP

  • R950 PSN

       UP

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
08 March 2012