DB2 - Problem description
Problem IT24944 | Status: Closed |
DATABASE MARKED BAD (SQLO_INV_PARM) ON INTERRUPT IN REGULAR EXPRESSION PROCESSING | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
This is the same issue as PI73641 which is a BigSQL APAR: http://www-01.ibm.com/support/docview.wss?uid=swg1PI73641 This is being opened so we can fix the same issue in DB2 v11.1. During an interrupt, the database can panic and shut down when DB2 is handling a regular expression (REGEX). In the db2diag.log you would see an error like this: 2016-12-12-12.49.20.334907-480 I16060100E950 LEVEL: Severe PID : 15643 TID : 139938536351488 PROC : db2sysc 2 INSTANCE: db2inst1 NODE : 002 DB : BIGSQL APPHDL : 0-256 APPID: *N0.bigsql.161212190452 AUTHID : XXXXXX HOSTNAME: gets5.fyre.ibm.com EDUID : 56 EDUNAME: db2agnts (BIGSQL) 2 FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:250 MESSAGE : ZRC=0x800F00FC=-2146500356=SQLO_INV_PARM "Invalid input parameter" DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: -902 sqlerrml: 3 sqlerrmc: 252 sqlerrp : SQLRI886 sqlerrd : (1) 0x800F00FC (2) 0x000000FC (3) 0x00000000 (4) 0x00000000 (5) 0xFFFFF9C3 (6) 0x00000002 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: An FODC_AppErr folder will be created, and a trap file will contain the following stack: 00007EFCDF394CC7 _Z13sqlzeDumpFFDCP8sqeAgentjP5sqlcai + 0x00a7 (/opt/db2inst/db2bofac/sqllib/lib64/libdb2e.so.1) 0x00007EFCDF394390 _Z11sqlzeMapZrcP8sqeAgentjmjP5sqlcaiPK12sqlzeContextb + 0x0940 (/opt/db2inst/db2bofac/sqllib/lib64/libdb2e.so.1) 0x00007EFCDE08A755 _Z11sqlrrMapZrcP8sqlrr_cbjmi + 0x0035 (/opt/db2inst/db2bofac/sqllib/lib64/libdb2e.so.1) 0x00007EFCDE5AF900 _Z28sqlri_regexp_like_short_bodyP8sqlrr_cbP10sqlz_valueS2_S2_S2_ S2_PKcS4_PPvPiPP19sqlriRegexpWorkAreaS7_Pbl + 0x04f0 (/opt/db2inst/db2bofac/sqllib/lib64/libdb2e.so.1) 0x00007EFCDE5ADF24 _Z17sqlri_regexp_likeP8sqlrr_cb + 0x01f4 (/opt/db2inst/db2bofac/sqllib/lib64/libdb2e.so.1) 0x00007EFCDE576F87 _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x04b7 (/opt/db2inst/db2bofac/sqllib/lib64/libdb2e.so.1) 0x00007EFCDDFB79F6 _Z16sqlrr_dss_routerP8sqlrr_cb + 0x0806 (/opt/db2inst/db2bofac/sqllib/lib64/libdb2e.so.1) 0x00007EFCDDFB43B6 _Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0x1066 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 Mod 4 Fixpack 4 or higher * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 03.05.2018 27.11.2018 27.11.2018 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |