A fix is available
APAR status
Closed as program error.
Error description
You upgraded your DB2 subsystem to DB2 V10 in compatibility mode. You re-ran the CIUCNFG1 CICS IA configuration clist to update the CICS IA supplied sample JCL and SQL. You ran the CIUDBNT job which binds CICS IA background program CIUCINB2. When the CINB task runs and needs to update dependency data for DB2 resources the following message is received on the CINTLOG: CIU2207E mm/yy/dd hh:mm:ss applid DB2 error on SYSIBM.SYSPACKSTMT SQL code -525, DB2 requests stopped Pogram CIUCINB2 which accesses the SYSIBM.SYSPACKSTMT catalog table in its GET_DB2_RESOURCE proc uses the DB2_RELEASE field which was set from a EC INQUIRE DB2CONN for field DB2RELEASE. In this case, if DB2 V10 is in compatibility mode, the STATEMENT column does not yet exist in the SYSPACKSTMT table. CICS IA needs to determine the DB2 runtime mode and if not in new function mode, it needs to use the STMT column. The SYSIBM.VERSION DB2 catalog table identifies the DB2 version and mode. Additional Symptom(s) Search Keyword(s): KIXREVWJB
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All CICS IA v.3.2 users. * **************************************************************** * PROBLEM DESCRIPTION: Customer obtains the message CIU2207E * * -525 SQLCODE from CIUCINB2 when DB2 * * V10 is in a compatibility mode. * **************************************************************** * RECOMMENDATION: Apply the PTF and perform HOLD ACTION item. * **************************************************************** CICS IA checks the DB2 version only, but does not check the mode in which DB2 works. The customer obtains the error message CIU2207E -525 SQLCODE from CIUCINB2 when DB2 V10 is in a compatibility mode with DB2 V910.
Problem conclusion
This PTF uses DB2 Session Variable SYSIBM.VERSION to check the level identifier. If it is less than 5, the new DB2 V10 function is not used.
Temporary fix
Comments
**** PE12/12/14 FIX IN ERROR. SEE APAR PM79205 FOR DESCRIPTION
APAR Information
APAR number
PM65918
Reported component name
CICS INTER ANAL
Reported component ID
5655U8600
Reported release
320
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-05-31
Closed date
2012-09-28
Last modified date
2013-01-25
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK82318
Modules/Macros
CIUCINB2
Fix information
Fixed component name
CICS INTER ANAL
Fixed component ID
5655U8600
Applicable component levels
R320 PSY UK82318
UP12/10/10 P F210
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSPPUS","label":"CICS Interdependency Analyzer for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.2","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
25 January 2013