A fix is available
APAR status
Closed as program error.
Error description
Provide concurrency support for DB2 V10 within CICS IA for the runtime collectors and batch utilities. . Additional Symptom(s) Search Keyword(s): KIXREVWJB DB2V10 10 compatability concurrence run time
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: CICS IA 3.1 users who plan to collect * * DB2 V10 commands. * **************************************************************** * PROBLEM DESCRIPTION: The names of new DB2 V10 commands (SQL * * statements) are not recognised by CICS * * IA, and resources of all DB2 commands * * are not determined by CICS IA. * * The CIUDB2V view is incorrect in * * DB2 V10. * **************************************************************** * RECOMMENDATION: Apply the PTF and perform HOLD ACTION. * **************************************************************** The new DB2 V10 commands and resource types are absent in the CIUUFIDT module. The SYSIBM.SYSPACKSTMT table has changed in DB2 V10. The STMT column which held all or a portion of the text for the SQL statement no longer exists. It has been replaced instead by the STATEMENT column which is a CLOB that holds the complete text of an SQL statement. The CIUDB2V view uses the STMT column which is correct for DB2 V9 and earlier releases, but for DB2 V10 it is incorrect and the STATEMENT column should be used instead.
Problem conclusion
The new DB2 V10 commands and resource types have been added to the CIUUFIDT module. CIUCINB2 module has been corrected to obtain resources from the SYSIBM.SYSPACKSTMT table. The CIUDB2V view is created during configuration of CICS IA depending on DB2 version.
Temporary fix
Comments
APAR Information
APAR number
PM39169
Reported component name
CICS INTER ANAL
Reported component ID
5655U8600
Reported release
310
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-05-13
Closed date
2011-08-19
Last modified date
2011-10-28
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK71011 PM48239 PM51039
Modules/Macros
CIUAFFL1 CIUAFFL2 CIUAFFL3 CIUCINB2 CIUCNFG2 CIUDBNT CIUDBV10 CIUGETCD CIUREPDB CIUREPRO CIUUFIDT CIUU042 CIUU045 H274310J
Fix information
Fixed component name
CICS INTER ANAL
Fixed component ID
5655U8600
Applicable component levels
R310 PSY UK71011
UP11/09/21 P F109
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.1","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
28 October 2011