DB2 BIND for CIUAPEXT fails with SQLCODE -204 for CIU_SQL_DATA

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

DB2 configuration

Product Alias/Synonym

CICSIA CICS/IA

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

CICS Interdependency Analyzer for z/OS
Installation

Software version:

3.1, 3.2, 5.1

Operating system(s):

z/OS

Reference #:

1625158

Modified date:

2013-02-13

Translate my page

Machine Translation

Content navigation