3) and before the rss instance down, it's running the log apply program and below select statement:
===========------------- - - - - - -
/informix/bin/onstat -g ses 512128:
IBM Informix Dynamic Server Version 11.50.FC9W3 -- Read-Only (RSS) -- Up 301 days 21:41:24 -- 13493808 Kbytes
session effective #RSAM total used dynamic
id user user tty pid hostname threads memory memory explain
512128 query - - -1 ::ffff:1 1 196608 167696 off
Program :
-
tid name rstcb flags curstk status
512191 sqlexec 7000002d1df51a8 ---PRR- 12944 running-
Memory pools count 2
name class addr totalsize freesize #allocfrag #freefrag
512128 V 700000334800040 192512 28104 171 14
512128*O0 V 700000323ab1040 4096 808 1 1
name free used name free used
overhead 0 6576 scb 0 144
opentable 0 3576 filetable 0 832
log 0 16536 temprec 0 20640
keys 0 256 ralloc 0 79288
gentcb 0 1584 ostcb 0 3400
sqscb 0 21656 sql 0 72
hashfiletab 0 552 osenv 0 2600
sqtcb 0 8448 fragman 0 1536
sqscb info
scb sqscb optofc pdqpriority optcompind directives
7000002d1b31fc8 70000032e30b028 0 0 2 1
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers Explain
512128 SELECT gapsdb DR Not Wait 0 0 9.20 Off
Current statement name : _ifxc0000000000000
Current SQL statement (3) :
SELECT businum, sendbkid, msgid, batchseqno, txcid, wkdt, payseqno,
payername, paycstmrid, payeraccno, payersttlmacctnm, payersttlmacct,
paybkid, rcvbkid, rcvername, rcveraccno, paysttlmbkid, rcvsttlmbkid,
paybknm, payeraddr, ctrctnb, chckid, ccy, amt, rmkinf, trstatus, txsts,
sndsts, txprccd, txrjctcd, txrjctinf, ansmsgtp, ansmsgid, txrespsts,
anstxrjctcd, anstxrjctinf, respps, txnetgdt, txnetgrnd, sttlmdt, provno,
orgno, accprovno, accorgno, handprovno, handorgno, turnprovno, turnorgno,
autooper, checkoper, corebksts, pltdate, pltnum, chksts, txtpcd,
txctgypurpcd, cityflag, trrespcode, trrespmsg, printnum, unisoccd,
pyeinnmegnm, pyeinnmegaccno, socorgflownb, chrgsflg, sysdt, systm,
mkinfo1, mkinfo2, mkinfo3, mkinfo4, mkinfo5, mkinfo6, createts, updatets
FROM BEPS_BATREPLACEBUY_S_HIS AS BEPS_BATREPLACEBUY_S_HIS WHERE ( 1=1 )
AND ( businum >= '2025030?1?4?2?93?1?7?1?6?2?2耷' ) AND ( businum <
'20250311524288' )
Last parsed SQL statement :
SELECT businum, sendbkid, msgid, batchseqno, txcid, wkdt, payseqno,
payername, paycstmrid, payeraccno, payersttlmacctnm, payersttlmacct,
paybkid, rcvbkid, rcvername, rcveraccno, paysttlmbkid, rcvsttlmbkid,
paybknm, payeraddr, ctrctnb, chckid, ccy, amt, rmkinf, trstatus, txsts,
sndsts, txprccd, txrjctcd, txrjctinf, ansmsgtp, ansmsgid, txrespsts,
anstxrjctcd, anstxrjctinf, respps, txnetgdt, txnetgrnd, sttlmdt, provno,
orgno, accprovno, accorgno, handprovno, handorgno, turnprovno, turnorgno,
autooper, checkoper, corebksts, pltdate, pltnum, chksts, txtpcd,
txctgypurpcd, cityflag, trrespcode, trrespmsg, printnum, unisoccd,
pyeinnmegnm, pyeinnmegaccno, socorgflownb, chrgsflg, sysdt, systm,
mkinfo1, mkinfo2, mkinfo3, mkinfo4, mkinfo5, mkinfo6, createts, updatets
FROM BEPS_BATREPLACEBUY_S_HIS AS BEPS_BATREPLACEBUY_S_HIS WHERE ( 1=1 )
AND ( businum >= '2025030?1?4?2?93?1?7?1?6?2?2耷' ) AND ( businum <
'20250311524288' )
and I attached all the document also . it include the online.log in the primary and rss instance, and whole assert file also .
It most like a defect in this version. Do anyone know which version fix the problem? any suggestion are welcome.