Re: Trigger program - open / close file question

[CRPence <CRPbottle@xxxxxxxxx>]

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

Regards, Chuck