A fix is available
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 number
PI74678
Reported component name
CICS IA V5
Reported component ID
5655Y2200
Reported release
520
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-01-10
Closed date
2017-03-13
Last modified date
2018-01-04
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.
[{"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":"5.2","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
04 January 2018