PI78876: BIG SQL MAY TRAP WHEN RUNNING A QUERY IN A MEMORY CONSTRAINED SYSTEM. THE TRAP WILL OCCUR IN FUNCTION SQLRA_GET_VAR()

APAR status

• Closed as program error.

Error description

• The db2diag.log will include an out-of-memory error probe
  immediately proceeding the trap.
  
      2017-03-22-20.57.40.213568-420 I85983204E648         LEVEL:
  Severe
      PID     : 27940                TID : 140048406144768 PROC :
  db2sysc 0
      INSTANCE: bigsql               NODE : 000            DB   :
  BIGSQL
      APPHDL  : 0-14269              APPID:
  9.30.105.56.57592.170323075227
      AUTHID  : BIGSQL               HOSTNAME:
  bigaperf285.svl.ibm.com
      EDUID   : 45                   EDUNAME: db2agent (BIGSQL) 0
      FUNCTION: DB2 UDB, base sys utilities,
  sqeApplication::AppStartUsing, probe:92
      RETCODE : ZRC=0x8B0F0001=-1961951231=SQLO_NOMEM_APPH
                "No memory available in 'Application Heap'"
                DIA8301C No memory available in the application
  heap.
  
      2017-03-22-20.57.40.214428-420 I85983853E621         LEVEL:
  Severe
      PID     : 27940                TID : 140014298064640 PROC :
  db2sysc 0
      INSTANCE: bigsql               NODE : 000            DB   :
  BIGSQL
      APPHDL  : 0-14167              APPID:
  9.30.105.56.57388.170323075045
      AUTHID  : BIGSQL               HOSTNAME:
  bigaperf285.svl.ibm.com
      EDUID   : 150                  EDUNAME: db2agent (BIGSQL) 0
      FUNCTION: DB2 UDB, RAS/PD component,
  pdResilienceIsSafeToSustain, probe:800
      DATA #1 : String, 37 bytes
      Trap Sustainability Criteria Checking
      DATA #2 : Hex integer, 8 bytes
      0x0000000400001001
      DATA #3 : Boolean, 1 bytes
      true
  
      2017-03-22-20.57.40.214726-420 I85984475E543         LEVEL:
  Severe
      PID     : 27940                TID : 140014298064640 PROC :
  db2sysc
      INSTANCE: bigsql               NODE : 000            DB   :
  BIGSQL
      APPHDL  : 0-14167              APPID:
  9.30.105.56.57388.170323075045
      AUTHID  : BIGSQL               HOSTNAME:
  bigaperf285.svl.ibm.com
      EDUID   : 150                  EDUNAME: db2agent (BIGSQL) 00
      FUNCTION: DB2 UDB, Query Gateway, sqlqg_signal_handler,
  probe:10
      MESSAGE : DIA0505I Execution of a component signal handling
  function has begun.
  
  Stack trace shows:
  
  0x00007F5FA1CBF1CB ossDumpStackTraceV98 + 0x002b
                  (/home/bigsql/sqllib/lib64/libdb2osse.so.1)
  0x00007F5FA1CBB377 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
  0x00d7
                  (/home/bigsql/sqllib/lib64/libdb2osse.so.1)
  0x00007F5FA8EEF737 sqlo_trce + 0x03c7
                  (/home/bigsql/sqllib/lib64/libdb2e.so.1)
  0x00007F5FA9055A21 sqloEDUCodeTrapHandler + 0x03b1
                  (/home/bigsql/sqllib/lib64/libdb2e.so.1)
  0x00007F5FB08F5370 address: 0x00007F5FB08F5370 ; dladdress:
  0x00007F5FB08E6000 ; offset in lib: 0x000000000000F370 ;
                  (/lib64/libpthread.so.0)
  0x00007F5FA99E5D1B _Z13sqlra_get_varP8sqlrr_cbiibPbS1_ + 0x289b
                  (/home/bigsql/sqllib/lib64/libdb2e.so.1)
  0x00007F5FA9675412
  _Z13sqlrr_prepareP14db2UCinterfaceP16db2UCprepareInfo + 0x0452
                  (/home/bigsql/sqllib/lib64/libdb2e.so.1)
  0x00007F5FA98B9F34
  _Z27sqlrrProcessDeferredPrepareP8sqlrr_cbP14db2UCinterface +
  0x0274
                  (/home/bigsql/sqllib/lib64/libdb2e.so.1)
  0x00007F5FA962E61B
  _Z21sqlrr_sql_request_preP14db2UCinterfacejiP16db2UCprepareInfoP
  15db2UCCursorInfo + 0x210b
                  (/home/bigsql/sqllib/lib64/libdb2e.so.1)
  0x00007F5FA96719B2
  _Z10sqlrr_openP14db2UCinterfaceP15db2UCCursorInfo + 0x0212
                  (/home/bigsql/sqllib/lib64/libdb2e.so.1)
  0x00007F5FA7864501
  _Z16sqljs_ddm_opnqryP14db2UCinterfaceP13sqljDDMObject + 0x0431
                  (/home/bigsql/sqllib/lib64/libdb2e.so.1)
  0x00007F5FA784EA5B
  _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U
  Cinterface + 0x00fb
                  (/home/bigsql/sqllib/lib64/libdb2e.so.1)
  0x00007F5FA784FB16
  _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
  0x0546
                  (/home/bigsql/sqllib/lib64/libdb2e.so.1)
  0x00007F5FA784297A address: 0x00007F5FA784297A ; dladdress:
  0x00007F5FA220F000 ; offset in lib: 0x000000000563397A ;
                  (/home/bigsql/sqllib/lib64/libdb2e.so.1)
  0x00007F5FA7848F43 address: 0x00007F5FA7848F43 ; dladdress:
  0x00007F5FA220F000 ; offset in lib: 0x0000000005639F43 ;
                  (/home/bigsql/sqllib/lib64/libdb2e.so.1)
  0x00007F5FA7849BFF _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T +
  0x011f
                  (/home/bigsql/sqllib/lib64/libdb2e.so.1)
  0x00007F5FA728A464 _ZN8sqeAgent6RunEDUEv + 0x0de4
                  (/home/bigsql/sqllib/lib64/libdb2e.so.1)
  0x00007F5FAAA7EDE6 _ZN9sqzEDUObj9EDUDriverEv + 0x0116
                  (/home/bigsql/sqllib/lib64/libdb2e.so.1)
  0x00007F5FA9052958 sqloEDUEntry + 0x0578
  

Local fix

• N/A
  

Problem summary

• See error description
  

Problem conclusion

• The problem is fixed in Version 4.3 and later fix packs.
  

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

• R430 PSY

     UP