I have (DB2 z/os) RSU2204 Received and i am reviewing the Hold Actions, I see this one below, and I run the sql and find i have 30 of them. I'm reviewing the package and the plan properties, and I see the Plan has isolation of CS, so correct me if i'm wrong, BUT if you do not specify an isolation setting on the BIND PKG, then it should pick it up from the PLAN. So I really should not need to correct these, and i can simply run DSNTIJCL in the SDSNSAMP library, but if the DB2 code is not picking the isolation setting from the PLAN, then i need to set it in the BIND PKG statements. Futhermore, IBM needs to correct the DB2 code per the manual, the isolation default should come from the PLAN when not specified in the PKG statements. The package names returned in the sql result were all in DSNTIJCL, just different version levels of the modules.
UI80317 ++ HOLD(UI80317) SYS FMID(HDBCC10) REASON(ACTION) DATE(22116)
COMMENT
(****************************************************************
* Function Affected: *
* DB2 zOS Base *
****************************************************************
* Timing: *
* Pre-APPLY *
****************************************************************
This PTF corrects a query problem when a DBAT thread is
using ISOLATION(RR) instead of ISOLATION(CS). In order to
determine whether a package may have this issue, please check
the packages that are part of the following query:
SELECT LOCATION, COLLID, NAME, CONTOKEN, ISOLATION
FROM SYSIBM.SYSPACKAGE
WHERE ISOLATION = ' ';
Please correct the bind option of the package to enable ISOLATION(CS).).
------------------------------
LynMaberryGeorgia Farm Bureau Insurance Company
------------------------------