In the trap file, a similar stack trace will be generated:
<StackTrace>
-----FUNC-ADDR---- ------FUNCTION + OFFSET------
0x00002AAAB045718F ossDumpStackTraceEx + 0x01ef
0x00002AAAB0451F4E _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
0x00cc
0x00002AAAAD39E21F sqlo_trce + 0x03fb
0x00002AAAAD3E73DF sqloEDUCodeTrapHandler + 0x02db
0x0000003F05A0ECA0 address: 0x0000003F05A0ECA0 ; dladdress:
0x0000003F05A00000 ; offset in lib: 0x000000000000ECA0 ;
0x00002AAAADA0D896
_Z35sqlrlBuildTableOrViewAuthsRPCBufferP8sqlrr_cbPhsS1_sshiPsitb
b11sqlr_aainfoP13SQLO_MEM_POOLPjPS1_b + 0x00ee
0x00002AAAADA0EB5D
_Z8sqlrlguaP8sqlrr_cbPhsS1_sshi11sqlr_aainfoP13SQLO_MEM_POOLP10s
qlr_rolesbPsitbbPP9sqlrg_tadPib + 0x0935
0x00002AAAACBA9E92
_Z16sqlnn_auth_checkccP13SQLNQ_UPD_FCSPPjS1_PsPiS4_Pmi + 0x1154
0x00002AAAACFE04B2
_Z21sqlnq_view_finish_qgmP9sqlnq_qunbPmRP9sqlrg_tadRiS5_PjPS6_ +
0x0838
0x00002AAAACFE5262 _Z25sqlnq_ddl_create_view_endP9sqlnq_qtbPm +
0x0170
0x00002AAAACBB36B4
_Z16sqlnn_regen_viewPhsS_sS_sS_sbP17sqlrl_table_parmsPbS2_S2_b +
0x13aa
0x00002AAAADA5DE24
_Z16sqlrl_regen_viewP8sqlrr_cbPhsS1_sS1_sS1_ssbP17sqlrl_table_pa
rmsPbS4_b + 0x058e
0x00002AAAABCE8796
_Z26sqlnq_check_referenced_qtbPP9sqlnq_qtbP9sqlnq_qunP3loc21sqln
q_hierarchy_usage + 0x0c24
0x00002AAAABCE7806
_Z27sqlnq_handle_from_table_refP20sqlnq_multipart_namePhiPP9sqln
q_qunP9sqlnq_qtbP3locP9sqlnq_opr21sqlnq_hierarchy_usagePP8stknod
e_ + 0x00ee
0x00002AAAAE14F7BF _Z9sqlnq_semPP8stknode_i10actiontypePhP3loc +
0x120c1
0x00002AAAAE132228 _Z12sqlnp_smactnP8sqlnp_cbi + 0x094c
0x00002AAAABBABBF2 _Z12sqlnp_parserP8sqlnp_cb + 0x092e
0x00002AAAABBAD3FE
_Z10sqlnp_mainP12sqlnq_stringbP3locPP9sqlnq_qur + 0x02ba
0x00002AAAABB227D1
_Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq
lrr_cmpl_enviiPP9sqlnq_qur + 0x0c27
0x00002AAAABB21BA5
_Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq
lrr_cmpl_env + 0x0021
0x00002AAAABE9A311
_Z17sqlra_compile_varP8sqlrr_cbP14sqlra_cmpl_envPhitiiiiiP14SQLP
_LOCK_INFOP16sqlra_cached_varPiPm + 0x0771
0x00002AAAABEA6BEB
_Z14sqlra_find_varP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idj
jPhjthP14sqlra_cmpl_env15sqlra_fill_modePiiS8_iiiS8_P14SQLP_LOCK
_INFOPP16sqlra_cached_varS8_Pmb + 0x05df
0x00002AAAABED01A8 _Z13sqlra_get_varP8sqlrr_cbiibPbS1_ + 0x0860
0x00002AAAAD5B1EDD
_Z13sqlrr_prepareP14db2UCinterfaceP16db2UCprepareInfo + 0x036d
0x00002AAD5558EB56 sqlacall + 0x5af2
0x00002AAD0B1CF7A1 address: 0x00002AAD0B1CF7A1 ; dladdress:
0x00002AAD0B157000 ; offset in lib: 0x00000000000787A1 ;
0x00002AAD0B1CC223 admin_revalidate_db_objects + 0x0b97
0x00002AAAABD87E80 sqloInvokeFnArgs + 0x0040
0x00002AAAABF4C862
_Z19sqlriInvokerTrustedP10sqlri_ufobP21sqlriRoutineErrorIntfb +
0x065e
0x00002AAAABF46056 _Z9sqlricallP8sqlrr_cb + 0x0eee
0x00002AAAAE18716E _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm
+ 0x013e
0x00002AAAABE58C0D _Z29sqlrr_process_execute_requestP8sqlrr_cbib
+ 0x07bf
0x00002AAAABE50F19 _Z13sqlrr_executeP14db2UCinterfaceP9UCstpInfo
+ 0x060f
0x00002AAAAC4D18F9 _ZN10pvmPackage14executeSectionEP5sqlcajb +
0x073b
0x00002AAAAC4D3657 _ZN3PVM12executeQueryEjb + 0x0049
0x00002AAAAC4D91E0 _ZN3PVM3runEv + 0x0828
0x00002AAAAC4DD706 pvm_entry + 0x01d6
0x00002AAAABD87E80 sqloInvokeFnArgs + 0x0040
0x00002AAAABF4E801
_Z19sqlriInvokerTrustedP10sqlri_ufobP21sqlriRoutineErrorIntfb +
0x25fd
0x00002AAAABF46056 _Z9sqlricallP8sqlrr_cb + 0x0eee
0x00002AAAAE18716E _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm
+ 0x013e
0x00002AAAABE58C0D _Z29sqlrr_process_execute_requestP8sqlrr_cbib
+ 0x07bf
0x00002AAAABE50F19 _Z13sqlrr_executeP14db2UCinterfaceP9UCstpInfo
+ 0x060f
0x00002AAAABA5A975
_Z19sqljs_ddm_excsqlsttP14db2UCinterfaceP13sqljDDMObject +
0x04e7
0x00002AAAAE11E0E3
_Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U
Cinterface + 0x007d
0x00002AAAABA4369F
_Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
0x035b
0x00002AAAABA37A6B address: 0x00002AAAABA37A6B ; dladdress:
0x00002AAAAAABD000 ; offset in lib: 0x0000000000F7AA6B ;
0x00002AAAABA3CF35 address: 0x00002AAAABA3CF35 ; dladdress:
0x00002AAAAAABD000 ; offset in lib: 0x0000000000F7FF35 ;
0x00002AAAABA3A83C address: 0x00002AAAABA3A83C ; dladdress:
0x00002AAAAAABD000 ; offset in lib: 0x0000000000F7D83C ;
0x00002AAAABA3A5AA _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T +
0x0102
0x00002AAAAB96A7C6 _ZN8sqeAgent6RunEDUEv + 0x0a74
0x00002AAAAC067CE4 _ZN9sqzEDUObj9EDUDriverEv + 0x00a6
0x00002AAAAC067C3B _Z10sqlzRunEDUPcj + 0x0009
0x00002AAAABDC6424 sqloEDUEntry + 0x02f4
0x0000003F05A0683D address: 0x0000003F05A0683D ; dladdress:
0x0000003F05A00000 ; offset in lib: 0x000000000000683D ;
0x0000003F052D500D clone + 0x006d
</StackTrace>
In db2diag.log, messages similar to these regarding a view
generation and a consequent trap sustainability:
2015-04-24-14.04.50.157914-240 I33565956E656 LEVEL: Error
PID : 28713 TID : 46922878413120PROC :
db2sysc 1
INSTANCE: db2inst1 NODE : 001 DB :
DB_TST1
APPHDL : 1-24371 APPID:
10.37.81.44.58678.150424150944
AUTHID : db2user
EDUID : 42584 EDUNAME: db2agent (DB_TST1) 1
FUNCTION: DB2 UDB, catalog services, sqlrl_regen_view, probe:80
MESSAGE : SQLRL_REGEN_VIEW: Failure in regenerating view
DATA #1 : Hexdump, 29 bytes
0x00002AAD157E46F8 : 0000 0000 0000 0000 0000 0000 0000 0000
USER_SCHEMA.VIE
0x00002AAD157E4708 : 0000 0000 0000 0000 0000 0000 59
W_TESTE
2015-04-24-14.04.50.196149-240 I33566613E726 LEVEL: Error
PID : 28713 TID : 46922878413120PROC :
db2sysc 1
INSTANCE: db2inst1 NODE : 001 DB :
DB_TST1
APPHDL : 1-24371 APPID:
10.37.81.44.58678.150424150944
AUTHID : db2user
EDUID : 42584 EDUNAME: db2agent (DB_TST1) 1
FUNCTION: DB2 UDB, catalog services, sqlrl_regen_view, probe:80
MESSAGE : SQLRL_REGEN_VIEW: Failure in regenerating view
DATA #1 : Hexdump, 34 bytes
0x00002AAD157E46F8 : 0000 0000 0000 0000 0000 0000 0000 0000
USER_SCHEMA.VIEW
0x00002AAD157E4708 : 0000 0000 0000 0000 0000 0000 0000 0000
_TESTXXXXXXXXXXX
0x00002AAD157E4718 : 0000
XX
.
.
.
2015-04-24-14.04.51.079292-240 I33577252E650 LEVEL: Error
PID : 28713 TID : 46922878413120PROC :
db2sysc 1
INSTANCE: db2inst1 NODE : 001 DB :
DB_TST1
APPHDL : 1-24371 APPID:
10.37.81.44.58678.150424150944
AUTHID : db2user
EDUID : 42584 EDUNAME: db2agent (DB_TST1) 1
FUNCTION: DB2 UDB, catalog services, sqlrl_regen_view, probe:80
MESSAGE : SQLRL_REGEN_VIEW: Failure in regenerating view
DATA #1 : Hexdump, 23 bytes
0x00002AAD157E46F8 : 0000 0000 0000 0000 0000 0000 0000 0000
USER_SCHEMA.VIEW
0x00002AAD157E4708 : 0000 0000 0000 00
_TESTXX
2015-04-24-14.04.51.396021-240 I33577903E573 LEVEL: Severe
PID : 28713 TID : 46922878413120PROC :
db2sysc 1
INSTANCE: db2inst1 NODE : 001 DB :
DB_TST1
APPHDL : 1-24371 APPID:
10.37.81.44.58678.150424150944
AUTHID : db2user
EDUID : 42584 EDUNAME: db2agent (DB_TST1) 1
FUNCTION: DB2 UDB, RAS/PD component,
pdResilienceIsSafeToSustain, probe:800
DATA #1 : String, 37 bytes
Trap Sustainability Criteria Checking
DATA #2 : Hex integer, 8 bytes
0x0000000400071401
DATA #3 : Boolean, 1 bytes
false
.
.
.
2015-04-24-14.04.51.399769-240 I33579628E574 LEVEL: Error
PID : 28713 TID : 46922878413120PROC :
db2sysc 1
INSTANCE: db2inst1 NODE : 001 DB :
DB_TST1
APPHDL : 1-24371 APPID:
10.37.81.44.58678.150424150944
AUTHID : db2user
EDUID : 42584 EDUNAME: db2agent (DB_TST1) 1
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh,
probe:3
MESSAGE : Error in agent servicing application with CLIENT PID:
DATA #1 : Hexdump, 4 bytes
0x00002AAD1500F460 : 3736 3638
7668
2015-04-24-14.04.51.399834-240 I33580203E678 LEVEL: Error
PID : 28713 TID : 46922878413120PROC :
db2sysc 1
INSTANCE: db2inst1 NODE : 001 DB :
DB_TST1
APPHDL : 1-24371 APPID:
10.37.81.44.58678.150424150944
AUTHID : db2user
EDUID : 42584 EDUNAME: db2agent (DB_TST1) 1
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh,
probe:4
MESSAGE : Error in agent servicing application with INBOUND
APPLICATION ID:
DATA #1 : Hexdump, 30 bytes
0x000000020D406830 : 3130 2E33 372E 3831 2E34 342E 3538 3637
10.37.81.44.5867
0x000000020D406840 : 382E 3135 3034 3234 3135 3039 3434
8.150424150944
This APAR will prevent the consequent crash in the database. |
