IT24944: DATABASE MARKED BAD (SQLO_INV_PARM) ON INTERRUPT IN REGULAR EXPRESSION PROCESSING

Db2 Version 11.1 Mod4 Fix Pack4 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 4 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 5 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error 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: MYHOST1
  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
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ALL                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Db2 11.1 Mod 4 Fixpack 4 or higher                *
  ****************************************************************
  

Problem conclusion

• First fixed in Db2 11.1 Mod 4 Fixpack 4
  

Temporary fix

Comments

APAR Information

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

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

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RB10 PSN

     UP