Folks,
I am running DB2 UDB 7.2 on AIX 5.2.0.0 system. I am having problem with
DB2NOEXITLIST registry variable.
By default the DB2NOEXITLIST variable is off. The documentation says that
if the variable is OFF or not set, DB2 installs exit handler in the
applications which will do commit when the application ends. So, if the
application does not do explicit commit DB2 will do the commit for you.
My application does explicit commit when needed and an atexit() routine
does a rollback (as extra precaution) before application ends.
What I have found is that it does not matter whether I set the variable or
not, DB2 performs rollback when my application ends (whether normally or I
send signal 9).
If I send signal 9 to the application, it should not go through any exit
routines. Why does DB2 rolls back the changes?
Thanks.
--
Hemant Shah /"\ ASCII ribbon campaign
E-mail:
No************@xnet.com \ / ---------------------
X against HTML mail
TO REPLY, REMOVE NoJunkMail / \ and postings
FROM MY E-MAIL ADDRESS.
-----------------[DO NOT SEND UNSOLICITED BULK E-MAIL]------------------
I haven't lost my mind, Above opinions are mine only.
it's backed up on tape somewhere. Others can have their own.