A fix is available
APAR status
Closed as program error.
Error description
Your CICS IA Explorer Plug-In hangs or takes many minutes to load resources on the initial connect. Analysis of the DB2 SELECT queries led to the need for additional DB2 indexes on the PROGRAM column in tables: CIU_CICS_DATA CIU_MQ_DATA CIU_IMS_DATA CIU_DB2_DATA With the new indexes the initial query of resources improved significantly. Additional Symptom(s) Search Keyword(s): KIXREVWJB
Local fix
CREATE INDEX XPROG1 ON CIU_CICS_DATA ( "PROGRAM" ASC ) USING STOGROUP CUSTIAI PRIQTY 944000 SECQTY 84400 ERASE NO FREEPAGE 0 PCTFREE 20 GBPCACHE CHANGED BUFFERPOOL BP1 CLOSE NO COPY NO; CREATE INDEX XPROG2 ON CIU_MQ_DATA ( "PROGRAM" ASC ) USING STOGROUP CUSTIAI PRIQTY 944000 SECQTY 84400 ERASE NO FREEPAGE 0 PCTFREE 20 GBPCACHE CHANGED BUFFERPOOL BP1 CLOSE NO COPY NO; CREATE INDEX XPROG3 ON CIU_DB2_DATA ( "PROGRAM" ASC ) USING STOGROUP CUSTIAI PRIQTY 944000 SECQTY 84400 ERASE NO FREEPAGE 0 PCTFREE 20 GBPCACHE CHANGED BUFFERPOOL BP1 CLOSE NO COPY NO; CREATE INDEX XPROG4 ON CIU_IMS_DATA ( "PROGRAM" ASC ) USING STOGROUP CUSTIAI PRIQTY 944000 SECQTY 84400 ERASE NO FREEPAGE 0 PCTFREE 20 GBPCACHE CHANGED BUFFERPOOL BP1 CLOSE NO COPY NO;
Problem summary
**************************************************************** * USERS AFFECTED: All CICS IA V3.2 users. * **************************************************************** * PROBLEM DESCRIPTION: Unacceptable response time in the CICS * * IA Explorer plug-in when issuing a * * request for "Uses Resources" against a * * program * **************************************************************** * RECOMMENDATION: Apply the PTF and perform the HOLD ACTION. * **************************************************************** When the CICS IA Explorer plug-in user requests a "Uses Resources" against a program then under the covers several SQL commands are sent via JDBc to the host. Specifically we will request the following SQL commands for the initial program and any subsequent programs that are linked or called by that program: SELECT ... FROM CIU_CICS_DATA WHERE PROGRAM='??????'; SELECT ... FROM CIU_DB2_DATA WHERE PROGRAM='??????'; SELECT ... FROM CIU_MQ_DATA WHERE PROGRAM='??????'; SELECT ... FROM CIU_IMS_DATA WHERE PROGRAM='??????'; In some instances this can amount to hundreds of SQL commands. In order to improve the performance a DB2 index based on the "PROGRAM" column was added for each of the four tables.
Problem conclusion
The following indexes were added to the CICS IA DB2 creation jobs to improve the response times of "Uses resources" by program: XPLUGINP1 , XPLUGINP2 , XPLUGINP3 and XPLUGINP4. Also the following indexes were added to the CICS IA DB2 creation jobs to improve the response times of "Uses resources" transaction: XPLUGINT1 , XPLUGINT2 , XPLUGINT3 and XPLUGINT4. Also the following indexes were added to the CICS IA DB2 creation jobs to improve the response times of resource "Used by" program and transaction. XPLUGINO1 , XPLUGINO2 , XPLUGINO3 and XPLUGINO4. A new SQL sample member CIUUPDIX was provided for existing customers to add these indexes to an existing database. To add the indexes follow the steps described in the HOLD ACTION for this PTF.
Temporary fix
********* * HIPER * *********
Comments
APAR Information
APAR number
PM94150
Reported component name
CICS INTER ANAL
Reported component ID
5655U8600
Reported release
320
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt
Submitted date
2013-07-30
Closed date
2013-09-18
Last modified date
2013-10-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
PM97189 UK97647
Modules/Macros
CIUCICS1 CIUDB2 CIUIMS CIUMQ1 CIUUPDIX
Fix information
Fixed component name
CICS INTER ANAL
Fixed component ID
5655U8600
Applicable component levels
R320 PSY UK97647
UP13/09/25 P F309
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:
04 October 2013