IBM Informix Dynamic Server Version 14.10.FC3 -- On-Line -- Up 1 days 09:58:32 -- 3830108 Kbytes session #RSAM total used dynamic id user tty pid hostname threads memory memory explain 444 informix - 0 - 0 16384 12480 off Memory pools count 1 name class addr totalsize freesize #allocfrag #freefrag 444 V 6dc3c040 16384 3904 16 2 name free used name free used overhead 0 3328 scb 0 144 ostcb 0 64 sqscb 0 8720 fragman 0 80 sapi 0 144 ------------------------------------------------------------------------ session #RSAM total used dynamic id user tty pid hostname threads memory memory explain 443 marika HNYPW8-P 4868 hnypw8-pc4.hkonyp.local 1 4685824 4616712 off tid name rstcb flags curstk status 3365 sqlexec 68787a48 ---PR-- 14752 IO Wait- Memory pools count 2 name class addr totalsize freesize #allocfrag #freefrag 443 V 727b1040 4681728 68344 4383 129 443*O0 V 732ba040 4096 768 1 1 name free used name free used overhead 0 6656 scb 0 144 opentable 0 112248 filetable 0 16216 ru 0 600 misc 0 136 log 0 16536 temprec 0 22688 blob 0 328 keys 0 1320 ralloc 0 4057336 gentcb 0 1616 ostcb 0 2992 sort 0 104 sqscb 0 193872 sql 0 46080 hashfiletab 0 552 osenv 0 2576 buft_buffer 0 5384 sqtcb 0 34512 fragman 0 47304 shmblklist 0 5520 sapi 0 5288 udr 0 18888 rsam_seqscan 0 17816 sqscb info scb sqscb optofc pdqpriority optcompind directives 695ee1c0 6c098028 0 0 2 1 Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers Explain 443 INSERT honved DR Wait 10 0 0 3.50 Off Current Role : EuroAdm Stored procedure stack : context proc-counter opcode name ------------------------------------------------------------------ 0x0000000076d90058 0x73c38588+0x0010 SQL honved:alt_egyeniszla Current SQL statement (136) in procedure honved:alt_egyeniszla proc-counter 0x73c38588 opcode SQL insert into tmpnsztegyenleg(tte_neazon, tte_petazon, tte_tvsorsz, tte_nsztazon, tte_potazon, tte_devizanem, tte_osszeg, tte_eltoltx) select nkl_neazon, nkl_petazon, nkl_tvsorsz, nkl_nsztazon, nkl_potazon, nkl_devizanem, (sum nkl_ertek), 0 from nszmlkivlog where (and (exists (select "a" from tmpnszamla where (and (and (and (and (= tnsz_neazon, nkl_neazon), (= tnsz_petazon, nkl_petazon)), (= tnsz_tvsorsz, nkl_tvsorsz)), (= tnsz_nsztazon, nkl_nsztazon)), (between tnsz_neazon, (* i, 10000), (- (* (+ i, 1), 10000), 1))))), (<= nkl_dat, _dat)) group by nkl_neazon, nkl_petazon, nkl_tvsorsz, nkl_nsztazon, nkl_potazon, nkl_devizanem having (<> (sum nkl_ertek), 0); Last parsed SQL statement : execute procedure alt_egyeniszla('O', mdy(8,31,2021), '0') ; User-created Temp tables : partnum tabname rowsize 6000a0 tmpnsztegyenleg 38 600072 tmpnszamla 17 600070 tmpnszsnyit 15 60006f tmpkivszab 516 60006d tmpriportparam 2079 60006c tmpiniterrors 343 ------------------------------------------------------------------------ session #RSAM total used dynamic id user tty pid hostname threads memory memory explain 433 otilia HNYP-I58 7744 hnyp-i58gb-pc1.hkonyp.local 1 6037504 5944456 off tid name rstcb flags curstk status 3351 sqlexec 687894e8 --BPR-- 20016 IO Wait- Memory pools count 2 name class addr totalsize freesize #allocfrag #freefrag 433 V 6c9d2040 6033408 92280 5511 167 433*O0 V 6ca22040 4096 768 1 1 name free used name free used overhead 0 6656 scb 0 144 opentable 0 132896 filetable 0 18576 ru 0 600 misc 0 136 log 0 16536 temprec 0 21664 blob 0 328 keys 0 856 ralloc 0 5266512 gentcb 0 1616 ostcb 0 2992 sort 0 104 sqscb 0 207704 sql 0 71968 hashfiletab 0 552 osenv 0 2904 buft_buffer 0 4664 sqtcb 0 37936 fragman 0 86688 shmblklist 0 8552 sapi 0 6832 udr 0 23496 rsam_seqscan 0 23544 sqscb info scb sqscb optofc pdqpriority optcompind directives 695a41c0 77abc028 0 0 2 1 Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers Explain 433 SELECT INTO honved CR Not Wait 0 0 3.50 Off Current Role : EuroUsr Stored procedure stack : context proc-counter opcode name ------------------------------------------------------------------ 0x0000000070ee1058 0x72f77320+0x0010 SQL honved:nb_ktg_gen20 0x0000000076e4a500 0x737361e8+0x0010 EXPR honved:nb_ktg_gen Current SQL statement (122) in procedure honved:nb_ktg_gen20 proc-counter 0x72f77320 opcode SQL select tv_tagazon as te_tagazon, tv_sorsz as te_tvsorsz, (sum (* uf_kiszamdarab, ( iranyx, uf_irany))) as te_piaciertek, ta_arfolyam as te_arfolyam from tagviszony, unitforg, tmparfolyam where (and (= tv_petazon, _petazon), (in tv_allapotx, 1, 5)) group by 1, 2, 4, uf_potazon having (<> (sum (* uf_kiszamdarab, ( iranyx, uf_irany))), 0) into tmpdbegyenleg; Last parsed SQL statement : execute procedure nb_ktg_gen( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ; User-created Temp tables : partnum tabname rowsize 200ec0 tmparfolyam 18 600060 tmpiniterrors 343 ------------------------------------------------------------------------ session #RSAM total used dynamic id user tty pid hostname threads memory memory explain 39 informix - 0 - 1 544768 467232 off tid name rstcb flags curstk status 79 dbWorker 6878a6a8 ---P--- 2208 sleeping forever- Memory pools count 2 name class addr totalsize freesize #allocfrag #freefrag 39 V 6a2b5040 540672 76768 396 52 39*O0 V 6a507040 4096 768 1 1 name free used name free used overhead 0 6656 scb 0 144 opentable 0 31944 filetable 0 4328 ru 0 600 misc 0 136 log 0 16536 temprec 0 124064 keys 0 2368 ralloc 0 204536 gentcb 0 1592 ostcb 0 2992 sort 0 152 sqscb 0 33632 sql 0 4536 hashfiletab 0 552 sqtcb 0 12176 fragman 0 7736 sapi 0 1248 SAPI callback 0 480 cdr 0 576 udr 0 7328 rsam_seqscan 0 2920 sqscb info scb sqscb optofc pdqpriority optcompind directives 695981c0 6a330028 0 0 0 1 Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers Explain 39 sysadmin DR Wait 5 0 0 - Off ------------------------------------------------------------------------ session #RSAM total used dynamic id user tty pid hostname threads memory memory explain 38 informix - 0 - 1 544768 467064 off tid name rstcb flags curstk status 78 dbWorker 6878c148 ---P--- 2208 sleeping forever- Memory pools count 2 name class addr totalsize freesize #allocfrag #freefrag 38 V 6a248040 540672 76936 394 49 38*O0 V 6a505040 4096 768 1 1 name free used name free used overhead 0 6656 scb 0 144 opentable 0 31936 filetable 0 4504 ru 0 600 misc 0 136 log 0 16536 temprec 0 124064 keys 0 2384 ralloc 0 204544 gentcb 0 1592 ostcb 0 2992 sort 0 104 sqscb 0 33552 sql 0 4576 hashfiletab 0 552 sqtcb 0 12224 fragman 0 8080 sapi 0 1232 SAPI callback 0 488 cdr 0 568 udr 0 6752 rsam_seqscan 0 2848 sqscb info scb sqscb optofc pdqpriority optcompind directives 695961c0 6a2e7028 0 0 0 1 Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers Explain 38 sysadmin DR Wait 5 0 0 - Off ------------------------------------------------------------------------ session #RSAM total used dynamic id user tty pid hostname threads memory memory explain 37 informix - 0 - 1 647168 486624 off tid name rstcb flags curstk status 77 dbSchedu 6878b868 ---P--- 2944 sleeping secs: 161 - Memory pools count 2 name class addr totalsize freesize #allocfrag #freefrag 37 V 6c672040 643072 159776 400 36 37*O0 V 6a1e0040 4096 768 1 1 name free used name free used overhead 0 6656 scb 0 144 opentable 0 13512 filetable 0 1904 ru 0 608 misc 0 136 log 0 16536 temprec 0 36000 keys 0 1424 ralloc 0 323848 gentcb 0 1592 ostcb 0 2992 sort 0 144 sqscb 0 38032 sql 0 13304 hashfiletab 0 552 sqtcb 0 14632 fragman 0 6736 sapi 0 1312 SAPI callback 0 480 udr 0 3944 rsam_seqscan 0 2136 sqscb info scb sqscb optofc pdqpriority optcompind directives 695941c0 6c653028 0 0 2 1 Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers Explain 37 sysadmin DR Wait 5 0 0 - Off ------------------------------------------------------------------------ session #RSAM total used dynamic id user tty pid hostname threads memory memory explain 36 informix - 0 - 1 102400 87424 off tid name rstcb flags curstk status 76 dbutil 6878af88 ---P--- 2064 sleeping secs: 1 - Memory pools count 1 name class addr totalsize freesize #allocfrag #freefrag 36 V 6c55a040 102400 14976 67 13 name free used name free used overhead 0 3328 scb 0 144 opentable 0 3792 filetable 0 528 misc 0 136 log 0 16536 temprec 0 21664 keys 0 208 ralloc 0 5992 gentcb 0 1592 ostcb 0 2992 sqscb 0 20800 hashfiletab 0 552 sqtcb 0 7952 fragman 0 416 sapi 0 600 udr 0 192 sqscb info scb sqscb optofc pdqpriority optcompind directives 695921c0 6c573028 0 0 2 1 Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers Explain 36 sysadmin CR Not Wait 0 0 - Off ------------------------------------------------------------------------ session #RSAM total used dynamic id user tty pid hostname threads memory memory explain 3 informix - 0 - 0 16384 14096 off Memory pools count 1 name class addr totalsize freesize #allocfrag #freefrag 3 V 69adb040 16384 2288 22 3 name free used name free used overhead 0 3328 scb 0 144 gentcb 0 1616 ostcb 0 64 sqscb 0 8720 fragman 0 80 sapi 0 144 ------------------------------------------------------------------------ session #RSAM total used dynamic id user tty pid hostname threads memory memory explain 2 informix - 0 - 0 16384 12480 off Memory pools count 1 name class addr totalsize freesize #allocfrag #freefrag 2 V 69aba040 16384 3904 16 2 name free used name free used overhead 0 3328 scb 0 144 ostcb 0 64 sqscb 0 8720 fragman 0 80 sapi 0 144