IBM Support

PM94150: CICS IA EXPLORER PLUG-IN HANGS DURING INITIAL CONNECT LOADING RESORUCES

A fix is available

Subscribe

You can track all active APARs for this component.

 

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