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