Re: Memory leak on AIX 5.3

On Apr 1, 4:21 pm, "d...@smooth1.co.uk" <d...@smooth1.co.uk> wrote: > On 30 Mar, 19:59, "mirekb" <mirek...@gmail.com> wrote: > > > Our clients recently has migrated their system to AIX 5.3. Since the > > migration they are having problem with our application. It is a > > memory leak reported by Informix command 'onstst -g ses'. The memory > > allocated to our processes grows until it crashes the system. This is > > an example of onstat right after system startup: > > > We were able to recreate this on our dev box. We are running AIX 5.3 > > with latest Service Pack from IBM and Informix IDS 9.40.UC7. We can > > run identical application on AIX 5.2 with IDS 9.4 or IDS 9.2 without > > any problems. It is only on AIX 5.3. We re-compiled the system with > > IDS 10 on AIX 5.3 and we got the memory leak problem. > > Does anybody has any suggestions? > > > Thank you. > > What does > > onstat -g ses <sessionsid> > onstat -g mem > onstat -g afr > onstat -g stm> > give? > > Which pool is the memory going to? > David. Thanks for your help so far. It is much appreciated. We've installed Service Pack 5300-05-06. The output from oslevel -r: 5300-04 The output from oslevel -s: 5300-04-CSP We still have the same problem. Andreas: What is PMR? David: These are the outputs of the commands that you asked for: The output of onstat -g ses: $ onstat -g ses IBM Informix Dynamic Server Version 9.40.UC7 -- On-Line -- Up 00:20:46 -- 38144 Kbytes session #RSAM total used dyna mic id user tty pid hostname threads memory memory expl ain 24 informix - 0 - 0 12288 7992 off 23 istadm 2 27090 H50 1 405504 385720 off 22 istadm 2 26060 H50 1 102400 96400 off 21 istadm 2 26318 H50 1 159744 149328 off 20 istadm 2 24774 H50 1 757760 628024 off 19 istadm 2 25032 H50 1 57344 50880 off 17 istadm 2 28122 H50 1 57344 53352 off 9 istadm 2 21414 H50 1 36864 32088 off 3 informix - 0 - 0 12288 9200 off 2 informix - 0 - 0 12288 7992 off Our main process is 24774 (session 20). Output of onstat -g ses 20: IBM Informix Dynamic Server Version 9.40.UC7 -- On-Line -- Up 00:22:30 -- 38144 Kbytes session #RSAM total used dyna mic id user tty pid hostname threads memory memory expl ain 20 istadm 2 24774 H50 1 802816 661816 off tid name rstcb flags curstk status 44 sqlexec 401e36f0 Y--P--- 2248 cond wait(netnorm) Memory pools count 1 name class addr totalsize freesize #allocfrag #freefrag 20 V 50162020 802816 141000 706 277 name free used name free used overhead 0 1648 scb 0 96 opentable 0 10168 filetable 0 1208 ru 0 464 log 0 4208 temprec 0 10056 keys 0 928 ralloc 0 602832 gentcb 0 1208 ostcb 0 2736 sqscb 0 15248 sql 0 40 rdahead 0 112 hashfiletab 0 280 osenv 0 1744 buft_buffer 0 232 sqtcb 0 3600 fragman 0 3968 sapi 0 80 udr 0 880 sqscb info scb sqscb optofc pdqpriority sqlstats optcompind directives 504aaea0 5016b018 0 0 0 2 1 Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers Explain 20 - ist CR Wait 0 0 9.03 Off Last parsed SQL statement : UPDATE shclog SET msgtype=?,pan=?,pcode=?,txntype=?,amount=?,aval_balance=?,amount_equiv=?,ca sh_back=?,iss_conv_rate=?,iss_currency_code=?,iss_conv_date=?,acq_conv_rate =?,acq_currency_code=?,acq_conv_date=?,tra_amount=?,tra_conv_rate=?,tra_cur rency_code=?,tra_conv_date=?,fee=?,new_fee=?,new_amount=?,new_setl_amount=? ,settlement_fee=?,settlement_rate=?,settlement_code=?,settlement_amount=?,t randate=?,trantime=?,trace=?,local_time=?,local_date=?,settlement_date=?,ca p_date=?,pos_entry_code=?,pos_condition_code=?,pos_pin_cap_code=?,pos_cap_c ode=?,life_cycle=?,acquirer=?,issuer=?,transferee=?,originator=?,processori d=?,respcode=?,reason_code=?,revcode=?,shcerror=?,saf=?,origmsg=?,origtrace =?,origdate=?,origtime=?,merchant=?,acq_country=?,track2=?,track3=?,refnum= ?,authnum=?,termid=?,acceptorname=?,termloc=?,addresponse=?,acctnum=?,branc h=?,serial_1=?,serial_2=?,acqagent=?,issagent=?,storeid=?,lane=?,terminal_t race=?,checker_id=?,supervisor=?,shift_number=?,batch_id=?,extract_flags=?, o_rowid=?,card_region=?,from_acct_region=?,from_acct_group=?,to_acct_region =?,to_acct_group=?,to_acct_bin=?,to_acct_sub_inst=?,force_post=?,term_locat ion=?,term_type=?,term_number=?,term_city=?,term_country=?,term_acq_bank=?, term_language=?,suspect_code=?,merchant_name=?,misid=?,extra=?,user_txncode =?,user_msgtobank=?,bill_count=?,x200_time=?,x210_time=?,response_time=?,de vice_devcap=?,shc_devcap=?,formatter_devcap=?,auth_devcap=?,filler1=?,fille r2=?,filler3=?,filler4=?,issuer_data=?,acquirer_data=?,new_amount_equiv=?,a cq_aval_balance=?,acq_ledger_balance=?,setl_aval_balance=?,setl_ledger_bala nc=?,aval_balance_type=?,ledger_balance_typ=?,new_setl_fee=?,txn_amount=?,t xn_new_amount=?,txn_currency_code=?,txn_conv_rate=?,txn_conv_date=?,ch_amou nt=?,ch_new_amount=?,ch_currency_code=?,ch_conv_rate=?,ch_conv_date=?,ledge r_balance=?,slot_num=?,device_fee=?,shc_data_buffer=? WHERE CURRENT OF CUR205dff88 Output of onstat -g mem: IBM Informix Dynamic Server Version 9.40.UC7 -- On-Line -- Up 00:24:47 -- 38144 Kbytes Pool Summary: name class addr totalsize freesize #allocfrag #freefrag afpool V 4000e020 4096 528 7 1 tpcpool V 40652020 4096 576 3 1 seqpool V 4066d020 4096 2400 2 1 pnlpool V 40655020 4096 488 3 1 sbtlist V 40082020 12288 5600 4 3 dstpool V 40651020 4096 1512 2 1 ampool V 40668020 4096 2128 7 1 main_loop() V 407ea020 20480 2616 26 4 sb_delundoq V 400a1020 28672 8424 4 3 XTF_mem V 406a5020 565248 7744 4 3@

Please look at the APAR's already supplied (All memory leak issue IBM provided me are listed below, some are fixed) as AIX has at least a few issues with memory access issues. Also if you notice the Service Pack was not completely installed. Other wise your server would return "5300-05-06". Have the admin find what is below the required tech level and upgrade it. If any of the down level have "bos" in them then you are not properly patched. >Thanks for your help so far. It is much appreciated. >We've installed Service Pack 5300-05-06. >The output from oslevel -r: 5300-04 > >The output from oslevel -s: 5300-04-CSP For IY91677 you can do the following to see if this is a problem. It takes 100's of connections to make my server reproduce the issue but we easily do thousands and hour. ################################################################################# a. Obtain the process id (PID) for the MSC VP using: onstat -g glo |grep mscb. Use the PID to check memory size of the oninit: ps -elf |grep PID c. Repeat step 'b' several times to validate oninit growth. ################################################################################# Or use this little bit of ksh; ################################################################################# #!/bin/ksh export ONCONFIG=****YOUR VALUE**** export INFORMIXDIR=****YOUR VALUE**** export INFORMIXSERVER=dms export PATH=$PATH:$HOME/bin:.:$INFORMIXDIR/bin:export LIBPATH=$INFORMIXDIR/lib:$INFORMIXDIR/lib/esql:$INFORMIXDIR/lib/tools:/usr/lib MSC_PID=`onstat -g sch |grep msc |sed "s/ */~/g"|cut -f3 -d'~' |head -1` ps_elf_data=`ps -elf |grep $MSC_PID |grep -v grep` runtime=`date '+%Y%m%d%H%M%S'` echo "$runtime $ps_elf_data" >> /u/informix/log/msc_info_dms.out ################################################################################# This is the list I got from IBM a few months ago; IY91677 IBM APAR IY91677: ADD MEMORY CACHING FOR LIBS GETUSERATTR/PUTUSERATTR CALLS. Error description: Long running processes that fetch user attributes will leak memory. IY84813 IY87648 IY87624 IY74134 IY71363 On 2 Apr 2007 09:05:42 -0700, mirekb <mirekb50@gmail.com> wrote: > On Apr 1, 4:21 pm, "d...@smooth1.co.uk" <d...@smooth1.co.uk> wrote: > > On 30 Mar, 19:59, "mirekb" <mirek...@gmail.com> wrote: > > > > > Our clients recently has migrated their system to AIX 5.3. Since the > > > migration they are having problem with our application. It is a > > > memory leak reported by Informix command 'onstst -g ses'. The memory > > > allocated to our processes grows until it crashes the system. This is > > > an example of onstat right after system startup: > > > > > We were able to recreate this on our dev box. We are running AIX 5.3 > > > with latest Service Pack from IBM and Informix IDS 9.40.UC7. We can > > > run identical application on AIX 5.2 with IDS 9.4 or IDS 9.2 without > > > any problems. It is only on AIX 5.3. We re-compiled the system with > > > IDS 10 on AIX 5.3 and we got the memory leak problem. > > > Does anybody has any suggestions? > > > > > Thank you. > > > > What does > > > > onstat -g ses <sessionsid> > > onstat -g mem > > onstat -g afr > > onstat -g stm> > > > give? > > > > Which pool is the memory going to? > > David. > > Thanks for your help so far. It is much appreciated. > We've installed Service Pack 5300-05-06. > The output from oslevel -r: > 5300-04 > > The output from oslevel -s: > 5300-04-CSP > > We still have the same problem. > > Andreas: What is PMR? > > David: These are the outputs of the commands that you asked for: > > The output of onstat -g ses: > > $ onstat -g ses> > IBM Informix Dynamic Server Version 9.40.UC7 -- On-Line -- Up > 00:20:46 -- 38> 144 Kbytes > > session #RSAM total > used dyna > mic > id user tty pid hostname threads memory > memory expl > ain > 24 informix - 0 - 0 12288 > 7992 off > 23 istadm 2 27090 H50 1 405504 > 385720 off > 22 istadm 2 26060 H50 1 102400 > 96400 off > 21 istadm 2 26318 H50 1 159744 > 149328 off > 20 istadm 2 24774 H50 1 757760 > 628024 off > 19 istadm 2 25032 H50 1 57344 > 50880 off > 17 istadm 2 28122 H50 1 57344 > 53352 off > 9 istadm 2 21414 H50 1 36864 > 32088 off > 3 informix - 0 - 0 12288 > 9200 off > 2 informix - 0 - 0 12288 > 7992 off > > > Our main process is 24774 (session 20). Output of onstat -g ses 20: > > IBM Informix Dynamic Server Version 9.40.UC7 -- On-Line -- Up > 00:22:30 -- 38> 144 Kbytes > > session #RSAM total > used dyna > mic > id user tty pid hostname threads memory > memory expl > ain > 20 istadm 2 24774 H50 1 802816 > 661816 off > > tid name rstcb flags curstk status > 44 sqlexec 401e36f0 Y--P--- 2248 cond wait(netnorm) > > Memory pools count 1 > name class addr totalsize freesize #allocfrag #freefrag > 20 V 50162020 802816 141000 706 277 > > name free used name free > used > overhead 0 1648 scb 0 96 > opentable 0 10168 filetable 0 > 1208 > ru 0 464 log 0 > 4208 > temprec 0 10056 keys 0 928 > ralloc 0 602832 gentcb 0 > 1208 > ostcb 0 2736 sqscb 0 > 15248 > sql 0 40 rdahead 0 112 > hashfiletab 0 280 osenv 0 > 1744 > buft_buffer 0 232 sqtcb 0 > 3600 > fragman 0 3968 sapi 0 80 > udr 0 880 > > sqscb info > scb sqscb optofc pdqpriority sqlstats optcompind directives > 504aaea0 5016b018 0 0 0 2 1 > > Sess SQL Current Iso Lock SQL ISAM F.E. > Id Stmt type Database Lvl Mode ERR ERR Vers > Explain > > 20 - ist CR Wait 0 0 9.03 > Off > > > Last parsed SQL statement : > UPDATE shclog SET> > msgtype=?,pan=?,pcode=?,txntype=?,amount=?,aval_balance=?,amount_equiv=?,ca > > sh_back=?,iss_conv_rate=?,iss_currency_code=?,iss_conv_date=?,acq_conv_rate@@NL@

On Apr 2, 2:06 pm, "Eric Rowell" <erow...@gmail.com> wrote: > Please look at the APAR's already supplied (All memory leak issue IBM > provided me are listed below, some are fixed) as AIX has at least a > few issues with memory access issues. > > Also if you notice the Service Pack was not completely installed. > Other wise your server would return "5300-05-06". > > Have the admin find what is below the required tech level and upgrade > it. If any of the down level have "bos" in them then you are not > properly patched. > > >Thanks for your help so far. It is much appreciated. > >We've installed Service Pack 5300-05-06. > >The output from oslevel -r: 5300-04 > > >The output from oslevel -s: 5300-04-CSP > > For IY91677 you can do the following to see if this is a problem. It > takes 100's of connections to make my server reproduce the issue but > we easily do thousands and hour. > > ###########################################################################­###### > a. Obtain the process id (PID) for the MSC VP using: > onstat -g glo |grep msc> b. Use the PID to check memory size of the oninit: > ps -elf |grep PID > c. Repeat step 'b' several times to validate oninit growth. > ###########################################################################­###### > > Or use this little bit of ksh; > ###########################################################################­###### > #!/bin/ksh > > export ONCONFIG=****YOUR VALUE**** > export INFORMIXDIR=****YOUR VALUE**** > export INFORMIXSERVER=dms > export PATH=$PATH:$HOME/bin:.:$INFORMIXDIR/bin:> export LIBPATH=$INFORMIXDIR/lib:$INFORMIXDIR/lib/esql:$INFORMIXDIR/lib/tools:/usr/­lib > > MSC_PID=`onstat -g sch |grep msc |sed "s/ */~/g"|cut -f3 -d'~' |head -1` > ps_elf_data=`ps -elf |grep $MSC_PID |grep -v grep` > runtime=`date '+%Y%m%d%H%M%S'` > echo "$runtime $ps_elf_data" >> /u/informix/log/msc_info_dms.out > ###########################################################################­###### > > This is the list I got from IBM a few months ago; > IY91677 > IBM APAR IY91677: ADD MEMORY CACHING FOR LIBS GETUSERATTR/PUTUSERATTR CALLS. > Error description: Long running processes that fetch > user attributes will leak memory. > IY84813 > IY87648 > IY87624 > IY74134 > IY71363 > > On 2 Apr 2007 09:05:42 -0700, mirekb <mirek...@gmail.com> wrote: > > > > > On Apr 1, 4:21 pm, "d...@smooth1.co.uk" <d...@smooth1.co.uk> wrote: > > > On 30 Mar, 19:59, "mirekb" <mirek...@gmail.com> wrote: > > > > > Our clients recently has migrated their system to AIX 5.3. Since the > > > > migration they are having problem with our application. It is a > > > > memory leak reported by Informix command 'onstst -g ses'. The memory > > > > allocated to our processes grows until it crashes the system. This is > > > > an example of onstat right after system startup: > > > > > We were able to recreate this on our dev box. We are running AIX 5.3 > > > > with latest Service Pack from IBM and Informix IDS 9.40.UC7. We can > > > > run identical application on AIX 5.2 with IDS 9.4 or IDS 9.2 without > > > > any problems. It is only on AIX 5.3. We re-compiled the system with > > > > IDS 10 on AIX 5.3 and we got the memory leak problem. > > > > Does anybody has any suggestions? > > > > > Thank you. > > > > What does > > > > onstat -g ses <sessionsid> > > > onstat -g mem > > > onstat -g afr > > > onstat -g stm> > > > give? > > > > Which pool is the memory going to? > > > David. > > > Thanks for your help so far. It is much appreciated. > > We've installed Service Pack 5300-05-06. > > The output from oslevel -r: > > 5300-04 > > > The output from oslevel -s: > > 5300-04-CSP > > > We still have the same problem. > > > Andreas: What is PMR? > > > David: These are the outputs of the commands that you asked for: > > > The output of onstat -g ses: > > > $ onstat -g ses> > > IBM Informix Dynamic Server Version 9.40.UC7 -- On-Line -- Up > > 00:20:46 -- 38> > 144 Kbytes > > > session #RSAM total > > used dyna > > mic > > id user tty pid hostname threads memory > > memory expl > > ain > > 24 informix - 0 - 0 12288 > > 7992 off > > 23 istadm 2 27090 H50 1 405504 > > 385720 off > > 22 istadm 2 26060 H50 1 102400 > > 96400 off > > 21 istadm 2 26318 H50 1 159744 > > 149328 off > > 20 istadm 2 24774 H50 1 757760 > > 628024 off > > 19 istadm 2 25032 H50 1 57344 > > 50880 off > > 17 istadm 2 28122 H50 1 57344 > > 53352 off > > 9 istadm 2 21414 H50 1 36864 > > 32088 off > > 3 informix - 0 - 0 12288 > > 9200 off > > 2 informix - 0 - 0 12288 > > 7992 off > > > Our main process is 24774 (session 20). Output of onstat -g ses 20: > > > IBM Informix Dynamic Server Version 9.40.UC7 -- On-Line -- Up > > 00:22:30 -- 38> > 144 Kbytes > > > session #RSAM total > > used dyna > > mic > > id user tty pid hostname threads memory > > memory expl > > ain > > 20 istadm 2 24774 H50 1 802816 > > 661816 off > > > tid name rstcb flags curstk status > > 44 sqlexec 401e36f0 Y--P--- 2248 cond wait(netnorm) > > > Memory pools count 1 > > name class addr totalsize freesize #allocfrag #freefrag > > 20 V 50162020 802816 141000 706 277 > > > name free used name free > > used > > overhead 0 1648 scb 0 96 > > opentable 0 10168 filetable 0 > > 1208 > > ru 0 464 log 0 > > 4208 > > temprec 0 10056 keys 0 928 > > ralloc 0 602832 gentcb 0 > > 1208 > > ostcb 0 2736 sqscb 0 > > 15248 > > sql 0 40 rdahead 0 112 > > hashfiletab 0 280 osenv 0 > > 1744 > > buft_buffer 0 232 sqtcb 0 > > 3600 > > fragman 0 3968 sapi 0 80 > > udr 0 880 > > > sqscb info > > scb sqscb optofc pdqpriority sqlstats optcompind directives > > 504aaea0 5016b018 0 0 0 2 1 > > > Sess SQL Current Iso Lock SQL ISAM F.E. > > Id Stmt type Database Lvl Mode

On 2 Apr, 17:05, "mirekb" <mirek...@gmail.com> wrote: > On Apr 1, 4:21 pm, "d...@smooth1.co.uk" <d...@smooth1.co.uk> wrote: > > > On 30 Mar, 19:59, "mirekb" <mirek...@gmail.com> wrote: > > > > Our clients recently has migrated their system to AIX 5.3. Since the > > > migration they are having problem with our application. It is a > > > memory leak reported by Informix command 'onstst -g ses'. The memory > > > allocated to our processes grows until it crashes the system. This is > > > an example of onstat right after system startup: > > > > We were able to recreate this on our dev box. We are running AIX 5.3 > > > with latest Service Pack from IBM and Informix IDS 9.40.UC7. We can > > > run identical application on AIX 5.2 with IDS 9.4 or IDS 9.2 without > > > any problems. It is only on AIX 5.3. We re-compiled the system with > > > IDS 10 on AIX 5.3 and we got the memory leak problem. > > > Does anybody has any suggestions? > > > > Thank you. > > > What does > > > onstat -g ses <sessionsid> > > onstat -g mem > > onstat -g afr > > onstat -g stm> > > give? > > > Which pool is the memory going to? > > David. > > Thanks for your help so far. It is much appreciated. > We've installed Service Pack 5300-05-06. > The output from oslevel -r: > 5300-04 > > The output from oslevel -s: > 5300-04-CSP > > We still have the same problem. > > Andreas: What is PMR? > > David: These are the outputs of the commands that you asked for: > > The output of onstat -g ses: > > $ onstat -g ses> > IBM Informix Dynamic Server Version 9.40.UC7 -- On-Line -- Up > 00:20:46 -- 38> 144 Kbytes > > session #RSAM total > used dyna > mic > id user tty pid hostname threads memory > memory expl > ain > 24 informix - 0 - 0 12288 > 7992 off > 23 istadm 2 27090 H50 1 405504 > 385720 off > 22 istadm 2 26060 H50 1 102400 > 96400 off > 21 istadm 2 26318 H50 1 159744 > 149328 off > 20 istadm 2 24774 H50 1 757760 > 628024 off > 19 istadm 2 25032 H50 1 57344 > 50880 off > 17 istadm 2 28122 H50 1 57344 > 53352 off > 9 istadm 2 21414 H50 1 36864 > 32088 off > 3 informix - 0 - 0 12288 > 9200 off > 2 informix - 0 - 0 12288 > 7992 off > > Our main process is 24774 (session 20). Output of onstat -g ses 20: > > IBM Informix Dynamic Server Version 9.40.UC7 -- On-Line -- Up > 00:22:30 -- 38> 144 Kbytes > > session #RSAM total > used dyna > mic > id user tty pid hostname threads memory > memory expl > ain > 20 istadm 2 24774 H50 1 802816 > 661816 off > > tid name rstcb flags curstk status > 44 sqlexec 401e36f0 Y--P--- 2248 cond wait(netnorm) > > Memory pools count 1 > name class addr totalsize freesize #allocfrag #freefrag > 20 V 50162020 802816 141000 706 277 > > name free used name free > used > overhead 0 1648 scb 0 96 > opentable 0 10168 filetable 0 > 1208 > ru 0 464 log 0 > 4208 > temprec 0 10056 keys 0 928 > ralloc 0 602832 gentcb 0 > 1208 > ostcb 0 2736 sqscb 0 > 15248 > sql 0 40 rdahead 0 112 > hashfiletab 0 280 osenv 0 > 1744 > buft_buffer 0 232 sqtcb 0 > 3600 > fragman 0 3968 sapi 0 80 > udr 0 880 > > sqscb info > scb sqscb optofc pdqpriority sqlstats optcompind directives > 504aaea0 5016b018 0 0 0 2 1 > > Sess SQL Current Iso Lock SQL ISAM F.E. > Id Stmt type Database Lvl Mode ERR ERR Vers > Explain > > 20 - ist CR Wait 0 0 9.03 > Off > > Last parsed SQL statement : > UPDATE shclog SET> > msgtype=?,pan=?,pcode=?,txntype=?,amount=?,aval_balance=?,amount_equiv=?,ca > > sh_back=?,iss_conv_rate=?,iss_currency_code=?,iss_conv_date=?,acq_conv_rate > > =?,acq_currency_code=?,acq_conv_date=?,tra_amount=?,tra_conv_rate=?,tra_cur > > rency_code=?,tra_conv_date=?,fee=?,new_fee=?,new_amount=?,new_setl_amount=? > ,settlement_fee=?,settlement_rate=?,settlement_code=?,settlement_amount=?,t > randate=?,trantime=?,trace=?,local_time=?,local_date=?,settlement_date=?,ca > p_date=?,pos_entry_code=?,pos_condition_code=?,pos_pin_cap_code=?,pos_cap_c > ode=?,life_cycle=?,acquirer=?,issuer=?,transferee=?,originator=?,processori > d=?,respcode=?,reason_code=?,revcode=?,shcerror=?,saf=?,origmsg=?,origtrace > =?,origdate=?,origtime=?,merchant=?,acq_country=?,track2=?,track3=?,refnum= > ?,authnum=?,termid=?,acceptorname=?,termloc=?,addresponse=?,acctnum=?,branc > h=?,serial_1=?,serial_2=?,acqagent=?,issagent=?,storeid=?,lane=?,terminal_t > race=?,checker_id=?,supervisor=?,shift_number=?,batch_id=?,extract_flags=?, > o_rowid=?,card_region=?,from_acct_region=?,from_acct_group=?,to_acct_region > =?,to_acct_group=?,to_acct_bin=?,to_acct_sub_inst=?,force_post=?,term_locat > ion=?,term_type=?,term_number=?,term_city=?,term_country=?,term_acq_bank=?, > term_language=?,suspect_code=?,merchant_name=?,misid=?,extra=?,user_txncode > =?,user_msgtobank=?,bill_count=?,x200_time=?,x210_time=?,response_time=?,de > vice_devcap=?,shc_devcap=?,formatter_devcap=?,auth_devcap=?,filler1=?,fille > r2=?,filler3=?,filler4=?,issuer_data=?,acquirer_data=?,new_amount_equiv=?,a > cq_aval_balance=?,acq_ledger_balance=?,setl_aval_balance=?,setl_ledger_bala > nc=?,aval_balance_type=?,ledger_balance_typ=?,new_setl_fee=?,txn_amount=?,t > xn_new_amount=?,txn_currency_code=?,txn_conv_rate=?,txn_conv_date=?,ch_amou > nt=?,ch_new_amount=?,ch_currency_code=?,ch_conv_rate=?,ch_conv_date=?,ledge > r_balance=?,slot_num=?,device_fee=?,shc_data_buffer=? WHERE CURRENT OF > CUR205dff88 > > Output of onstat -g mem: > > IBM Informix Dynamic Server Version 9.40.UC7 -- On-Line -- Up > 00:24:47 -- 38> 144 Kbytes > > Pool Summary: > name class addr totalsize freesize #allocfrag #freefrag > afpool V 4000e020 4096 528 7 1 > tpcpool V 40652020 4096 576 3 1 > seqpool V 4066d020 4096 2400 2 1 > pnlpool V 40655020 4096 488 3 1@