PI66958: BIG SQL ENGINE RUNTIME TRAP WHILE EXECUTING DSM QUERY

APAR status

• Closed as program error.

Error description

• Big SQL processes are going down due to an optimizer problem
  where a query is compiled incorrectly that causes a crash
  during runtime, and the query needs to make a reference to a
  table function udf and a join.
  The trap has the following stack:
  2016-06-17-12.03.40.297219-420 I946854E1948          LEVEL:
  Event
  PID     : 19158                TID : 140050809480960 PROC :
  db2sysc 1
  INSTANCE: bigsql               NODE : 001            DB   :
  BIGSQL
  APPHDL  : 0-24696              APPID:
  9.30.148.245.39677.160617190318
  AUTHID  : BIGSQL               HOSTNAME: bigaperf620.svl.ibm.com
  EDUID   : 68                   EDUNAME: db2agntp (BIGSQL) 1
  FUNCTION: DB2 UDB, oper system services,
  sqloPGRPRegisterOneCrash, probe:2159
  MESSAGE : lastCrashCount
  DATA #1 : unsigned integer, 8 bytes
  0
  DATA #2 : String, 10 bytes
  inRecovery
  DATA #3 : Boolean, 1 bytes
  false
  CALLSTCK: (Static functions may not be resolved correctly, as
  they are resolved to the nearest symbol)
    [0] 0x00007F603C26FE4C sqloPGRPRegisterOneCrash + 0x20C
    [1] 0x00007F603C378008 sqloEDUCodeTrapHandler + 0xB18
    [2] 0x0000003F57A0F7E0 /lib64/libpthread.so.0 + 0xF7E0
    [3] 0x00007F603AB71DEC
  _Z8sqlkbptnP8sqeAgentiP14SQLKB_COL_INFOPhlPiPl + 0x13C
    [4] 0x00007F603AB71B28
  _Z8sqlkbndnP7sqlr_dbP8sqeAgentiP14SQLKB_COL_INFOPhsPsb + 0x148
    [5] 0x00007F603AC13F5A
  _Z8sqlktinsP7sqlr_dbP8sqeAgentP10sqlri_iudoP5sqlcat + 0x59A
    [6] 0x00007F603D02CA22 _Z8sqlritqbP8sqlrr_cb + 0x422
    [7] 0x00007F603CFAB855 _Z8sqlrievlP8sqlrr_cb + 0x5D5
    [8] 0x00007F603CFC8611 _Z17sqlriNljnNonPipedP8sqlrr_cb +
  0x16A1
    [9] 0x00007F603CF39BF8
  _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x4F8
    [10] 0x00007F603C9A1A76 _Z16sqlrr_dss_routerP8sqlrr_cb + 0x806
    [11] 0x00007F603C99E524
  _Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0xFE4
    [12] 0x00007F603A52A02D
  /home/bigsql/sqllib/lib64/libdb2e.so.1 + 0x536D02D
    [13] 0x00007F603A52891A _Z21sqleProcessSubRequestP8sqeAgent +
  0x3DA
    [14] 0x00007F603A55C28B _ZN8sqeAgent6RunEDUEv + 0x5AB
    [15] 0x00007F603DD24326 _ZN9sqzEDUObj9EDUDriverEv + 0x116
    [16] 0x00007F603C3747F8 sqloEDUEntry + 0x578
    [17] 0x0000003F57A07AA1 /lib64/libpthread.so.0 + 0x7AA1
    [18] 0x0000003F576E8AAD clone + 0x6D
  

Local fix

• As DSM admin logon to DSM console, then go to "Settings" ->
  "Monitoring Profiles" -> select the "Default BIG SQL profile"
  (or any custom profile created for any BIG SQL connections) ->
  "Deactive".
  

Problem summary

• See error description
  

Problem conclusion

• The problem is fixed in Version 4.2.0.0 December 2016 Refresh (
  Level s161128 & Bigsql-dist version 5.78.5.310) and later fix
  packs.
  For more info, see:
  See: http://ibm.co/2iuUmYV
  

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:

Modules/Macros

• NA
  

Fix information

• Fixed component name

  INFO BIGINSIGHT

• Fixed component ID

  5725C0900

Applicable component levels

• R420 PSY

     UP