When I have a complex table environment, with a table defined
certain amount of
triggers calling nested SPs and this environment has references
to tables with
also triggers and SPs and the entries need to be reread after an
parallel running
Update statistics, the server may write and af file with the
following stack :
0x10150cb88 oninit :: stcmpr + 0x0 sp=0x4bb1ae90(0x0,
0x46e92c58, 0x46e92d18, 0x49479038, 0x46e92e00, 0x0)
0x1003046e0 oninit :: decompile_proc + 0xc00 sp=0x4bb1ae90(0x0,
0x46e92c58, 0x46e92d18, 0x49479038, 0x46e92e00, 0x0)
0x10031cca4 oninit :: retrieve_cache + 0x8c0
sp=0x4bb1b220(0x4594dd28, 0x4bb1b440, 0x4594e318, 0x0,
0x100303ae0, 0x4594e
028)
0x10034ab08 oninit :: udr_getbyid_uid + 0x4f0 sp=0x4bb1b360(0x0,
0x0, 0x0, 0x101cee4e0, 0x4ad1b028, 0x101c00)
0x1003128e8 oninit :: dp_udrchk + 0x128
sp=0x4bb1b460(0x4943b3b8, 0x4bb1b694, 0x101cee4e8, 0x10100, 0x0,
0x4943b228)
0x10031202c oninit :: dp_check + 0x174 sp=0x4bb1b510(0x4801f4a0,
0x3, 0x4943b3b8, 0x4bb1b694, 0x1, 0x0)
0x100313f18 oninit :: qd_check + 0x518 sp=0x4bb1b5d0(0x4801f4a0,
0x6b, 0x4bb1b79c, 0x0, 0x1, 0x0)
0x1002f8ddc oninit :: ip_evalsql + 0x2c0
sp=0x4bb1b6b0(0x4801f4a0, 0x4a21ead0, 0x0, 0x0, 0x48219dd0,
0x4758a950)
0x1002f355c oninit :: runproc + 0xab4 sp=0x4bb1b820(0x4bb1bb58,
0x4bb1bb9c, 0x4a20f330, 0x13, 0x1019c38c0, 0x10f8)
0x100306b54 oninit :: udrlm_spl_execute + 0x934
sp=0x4bb1b980(0x49479948, 0x0, 0x4801f4a0, 0x101cee4e8, 0x0,
0x0)
0x1007656c0 oninit :: udrlm_exec_routine + 0x510
sp=0x4bb1bba0(0x49479948, 0x0, 0x4bb1c0c0, 0x1, 0x2, 0x0)
0x100348168 oninit :: udr_execute + 0xf10
sp=0x4bb1bd00(0x49479838, 0x0, 0x80000000, 0x101cee4e0, 0x2,
0x4987ebd0)
0x10035171c oninit :: exroutine + 0x4a4
sp=0x4bb1bf50(0x49479778, 0x4bb1c0c0, 0x4bb1c0c0, 0x0,
0x494796c8, 0x0)
0x100218e64 oninit :: execproc + 0xac sp=0x4bb1c010(0x47b69838,
0x494796c8, 0xffffffff80012200, 0x49479708, 0x49479778,
0x8f800)
0x1003355bc oninit :: aud_execproc + 0xc
sp=0x4bb1c150(0x47b69838, 0x37, 0x37, 0x2130, 0x8fbd8, 0x101cee)
0x1002150f8 oninit :: excommand + 0x1e70
sp=0x4bb1c210(0x47b69838, 0x101cee4c0, 0xdc, 0x0, 0x101cee4e0,
0x49479228)
0x100566888 oninit :: dotrstmts + 0x3f8
sp=0x4bb1c540(0x101cee000, 0x494693d0, 0x0, 0x49d9aa08,
0x101cee4e8, 0x400000)
0x100566070 oninit :: dotrigs + 0x8d4 sp=0x4bb1c670(0x80000000,
0x101cee4e8, 0x101cee4e0, 0x0, 0x494693d0, 0x494693b8)
0x1005654dc oninit :: ferafttrig + 0x48c
sp=0x4bb1c830(0x49d9aa08, 0x4bb1cc54, 0x0, 0x1, 0x0, 0x459101c0)
0x100557dd0 oninit :: dodmlrow + 0x1144
sp=0x4bb1c930(0x49d9aa08, 0x0, 0x0, 0x481ea970, 0x84000004, 0x0)
0x100555c48 oninit :: dodelupd + 0xdd8 sp=0x4bb1cb60(0x49d9aa08,
0x0, 0x481ea970, 0x6078, 0x0, 0x4c)
0x100214828 oninit :: excommand + 0x15a0
sp=0x4bb1ccb0(0x49d9aa08, 0x0, 0x0, 0x0, 0x101cee4e0,
0x48f44438)
0x1006ff6d4 oninit :: sq_execute + 0x300 sp=0x4bb1cfe0(0x0,
0xfffffffffffffffd, 0x101cee4e8, 0x101cee4e0, 0x80000, 0x101
cee)
0x1007d2300 oninit :: sqmain + 0x9b8 sp=0x4bb1d0f0(0x1006ff3d4,
0x7, 0x1, 0x20000, 0x0, 0x200000)
0x101449e54 oninit :: listen_verify + 0x48c
sp=0x4bb1d1c0(0x458e2f68, 0x101800, 0x1019c38c0, 0x459101c0,
0x76ec, 0x0)
0x101449624 oninit :: spawn_thread + 0x16bc
sp=0x4bb1d660(0x76ec, 0x457b95d8, 0x101cf2, 0x880d88, 0x101c00,
0x880c00)
0x1012dc2d8 oninit :: th_init_initgls + 0x170
sp=0x4bb1dd10(0x1019c3, 0x101800, 0x101447f68, 0x101cfe000,
0x48942568, 0x
4656bbc8)
0x101308950 oninit :: startup + 0x1d0 sp=0x4bb1de50(0xa,
0x101cf4010, 0x101cfe098, 0x1, 0x101ced9a0, 0x101cfe098)
21:17:01 See Also: /opt/informix/IBM/12.10.FC12/tmp/af.a4e72ab |
