RE: Remote LONGTX with no userthread in 9.30 UC6 W4

Do I just ask really stupid questions? I never get any responses...you can be brutally honest...doubt I know where you live. :) -----Original Message----- From: Gentsch, Sam Sent: Tuesday, May 18, 2004 9:16 AM To: informix-list@iiug.org Subject: Remote LONGTX with no userthread in 9.30 UC6 W4 ...forgive the long copy and double post on ids (was having problems posting here), but it has been a while, I'll post at the top to save you time... What is the difference in the following commands? onmode -H <address> forget heuristically completed transaction onmode -Z <address> heuristically complete specified transaction The admin guide says the -Z places an ENDTRANS (after a ROLLBACK) into the logical log, but what does the -H do? Would the -Z have also worked in the scenario of the following post? (I recently had the same situation, and the -H did the trick. I just found the section in the Admin Guide -The Heuristic Rollback Scenario this and am wondering if I did the right thing and what to do next time!). Thanks! Sam Gentsch sending to informix-list

Gentsch, Sam wrote: > Do I just ask really stupid questions? No - just tough ones. > I never get any responses...you can be brutally honest...doubt I know where you live. :) You won't be able to say that again! > -----Original Message----- > From: Gentsch, Sam > Sent: Tuesday, May 18, 2004 9:16 AM > To: informix-list@iiug.org > Subject: Remote LONGTX with no userthread in 9.30 UC6 W4 > > > ...forgive the long copy and double post on ids (was having problems posting here), > but it has been a while, I'll post at the top to save you time... > > What is the difference in the following commands? > onmode -H <address> forget heuristically completed transaction > onmode -Z <address> heuristically complete specified transaction> > The admin guide says the -Z places an ENDTRANS (after a ROLLBACK) > into the logical log, but what does the -H do? How did you find that -H existed? > Would the -Z have also worked in the scenario of the following > post? > > (I recently had the same situation, and the -H did the trick. I > just found the section in the Admin Guide -The Heuristic Rollback > Scenario this and am wondering if I did the right thing and what to > do next time!). I can't find 'onmode -H' in the manuals. That could easily be deliberate. I couldn't find it in the OnLine 5.2x manual either. However, there was some information in there (chapter 11) about completely forgetting about a TX - over and above what was implied by -Z. So, I think -H is undocumented because you don't want to use it. It's basically a more ruthless version of -Z. Someone else might contradict me - they might be right to do so. > Thanks! > Sam Gentsch > > sending to informix-list -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/