Oninit cdi / Archive
Talk to an expert →

Mysterious Rollback

Posted in 2003

Topics: General Discussion

DarrenJacobs@carmax.com — — source: IIUG Forums & Mailing Lists

Hello To All, Recently I have been experiencing rollbacks that are unexplainable. There is no indications that these sessions are exceeding the total locks (3 mil) allocated as well as exceeding the LTXHWM = 50. I have 57 logs configured. This session only exists in 2 logs. Started in log 19018 and is now in log 19019. The onstat -u output for this session: c0000000c603d828 --RPX-- 46974 sysadm FSAPP2P 0 0 739510 1081457 273983 Does anyone know of a bug that could explain this mysterious rollback? Thanks My system: 6 way N-Class HP HPUX 11 9.21 FC5XH

↪ replying to DarrenJacobs@carmax.com
DarrenJacobs@carmax.com — — source: IIUG Forums & Mailing Lists

Thanks for the thought. In most instances that I am familiar with a 213 error is indicated with the rollback if a user hit ^c. There are no sql or isam errors associated with the rolback. John Magie <jmagie@us.ibm.c To: "DarrenJacob...." <DarrenJacobs@carmax.com> om> cc: Subject: Re: Mysterious Rollback [1064] 05/01/03 10:57 AM Darren, I imagine the user is rolling the tx back by interrupting their session. If the high water marks or locks were the cause you would see a message in the online log indicating such. Check with the users are see who is hitting ctl-c :-) Mike John Michael Magie Advanced Support Engineer IBM Data Management Solutions, Software Group Tel : 1-800-274-8184 Fax : 913-599-7185 internet : jmagie@us.ibm.com http://www-4.ibm.com/software/data/informix "DarrenJacob...." <DarrenJacobs@car To: ids@iiug.org max.com> cc: Sent by: Subject: Mysterious Rollback [1064] forum.subscriber@ iiug.org 05/01/2003 09:05 AM Hello To All, Recently I have been experiencing rollbacks that are unexplainable. There is no indications that these sessions are exceeding the total locks (3 mil) allocated as well as exceeding the LTXHWM = 50. I have 57 logs configured. This session only exists in 2 logs. Started in log 19018 and is now in log 19019. The onstat -u output for this session: c0000000c603d828 --RPX-- 46974 sysadm FSAPP2P 0 0 739510 1081457 273983 Does anyone know of a bug that could explain this mysterious rollback? Thanks My system: 6 way N-Class HP HPUX 11 9.21 FC5XH

Related threads

Glossary