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 number
PI78876
Reported component name
INFO BIGINSIGHT
Reported component ID
5725C0900
Reported release
420
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-03-27
Closed date
2017-04-07
Last modified date
2017-04-07
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCRJT","label":"IBM Db2 Big SQL"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"420","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
24 August 2020