Technote (troubleshooting)
Problem(Abstract)
Your DB2 DBA is performing the DB2 binds for CICS Interdependency Analyzer for z/OS (CICS IA). The bind for member CIUAPEXT completes with a return code 08 (RC08) and SQLCODE error -204 (SQLCODE-204) for the CIU_SQL_TABLE.
Symptom
DSNX200I -DB2T BIND SQL ERROR
USING xxxxxx AUTHORITY
PLAN=(NOT APPLICABLE)
DBRM=CIUAPEXT
STATEMENT=250
SQLCODE=-204
SQLSTATE=42704
TOKENS=xxCICSIA.CIU_SQL_DATA
CSECT NAME=DSNXOTL
RDS CODE=-500
Cause
There was no CIU_SQL_DATA table present in the DB2 database since not upgrading from CICS IA 2.x version.
Environment
CICS IA V3.2; CICS IA V5.1;
Resolving the problem
Do not run the CIUDBN2 job to bind member CIUAPEXT for CICS IA V2 DB2 tables if CICS IA V2 was never previously installed or deployed.
Related information
Product Alias/Synonym
CICSIA CICS/IA
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.