Re: Trigger program - open / close file question

CRPence wrote:

Tom Liotta wrote:

<<SNIP>>

Be aware of another issue if this file is ever accessed from
within a QZDASOINIT job and the remote client uses XA APIs for
distributed transactions. The XA_end() API can (and often will)
cause QZDASOINIT to close _every_ file that is open in the job,
regardless of its involvement in any transaction and regardless
of sharing and activation groups.

<<SNIP>>

I seem to recall that fixes were made to prevent non-XA file opens from being closed, even if only partially corrected, in releases prior to v6r1; IIRC, changes to QDMRCLSE & QTNCLOSE. That is one of the last problems I recall debugging before I left fix\development... it makes already years ago, and I recall a developer had provided a test PTF that tried to limit the impact prior to the attempt for a true fix aimed for v6r1.

After searching a bit, I found what I was alluding to above. The PTF SI22743 for SE24771 has more detail; implemented with an environment variable:
ADDENVVAR ENVVAR( QIBM_TN_NTS_NATIVE_HOLD ) VALUE(1) LEVEL(as_rqd)
See that and details with caveats:
http://www-01.ibm.com/support/docview.wss?rs=0&q1=SI22743&uid=nas31a964faff674588086257188004cedc6

Chuck:

This was an _extremely_ interesting reply. I apologize for taking so long saying 'Thank you' for it.

At the moment, the only result that I can pass along is that it has significantly confused the entire issue; but it was confusing from the start anyway. Might as well mix it up some more!

Thanks again. When progress is made on the core issue that sucked me into this, I'll try to remember to pass on some detail.

Tom Liotta