PI74678: DB2 SQL -905 WHEN ATTEMPTING TO LOGIN USING THE CICS IA PLUGIN AND IBM EXPLORER.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Customer is experiencing a problem while attempting to logon to
  CICS IA using IBM Explorer for z/OS. The following error
  message is raised:
  IZE0106E Connect failed with error
  "com.ibm.db2.jcc.am.SqlException:
  DB2 SQL Error: SQLCODE=-905, SQLSTATE=57014,
  SQLERRMC=ASUTIME;000000000007;000000500000;SYSIBM.DSNRLST01,
           DRIVER=4.17.29" (CICS IA - BR)
  The procedure of creating DB2 index is not shipped with CICS IA
  product. During IA plug-in connection two SQL queries are
  executed to select lists of transactions and programs from
  CIU_RESOURCE table. The search criteria looks like WHERE
  TYPE=... So the index shown below in the workaround is
  required.
  Additional Symptom(s) Search Keyword(s): KIXREVDAM
                        SQLCODE905
  

Local fix

• Create an index for CICS IA DB2 Table using the statement below:
  
  CREATE
     INDEX X01RES04
    ON CICSIA.CIU_RESOURCE
     (
      "TYPE" ASC
     )
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All CICS Interdependency Analyzer V520 users.                *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * New index for 'TYPE' column is added on CIU_RESOURCE table   *
  * to avoid possible error when CICS IA plug-in starts          *
  * (exceeding the number of CPU seconds permitted for each SQL  *
  * statement).                                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply the PTF and perform the HOLD ACTION items.             *
  ****************************************************************
  During IA plug-in connection two SQL queries are executed to
  select lists of transactions and programs from CIU_RESOURCE
  table. The search criteria looks like WHERE TYPE=... So the new
  index for 'TYPE' column on CIU_RESOURCE table is required.
  

Problem conclusion

• New index X01RES04 for 'TYPE' column has been added on
  CIU_RESOURCE table.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  PI78311 UI45676

Modules/Macros

• CIUCNFG2 CIUMG52E CIURESTX
  

Fix information

• Fixed component name

  CICS IA V5

• Fixed component ID

  5655Y2200

Applicable component levels

• R520 PSY UI45676

     UP17/03/23 P F703

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.