DCD FEYIDB2I Job fails with SQLCODE -604

book

Article ID: 211009

calendar_today

Updated On:

Products

CA Data Content Discovery

Issue/Introduction

The Installation job FEYIDB2I fails with SQLCODE = -604, ERROR:  A DATA TYPE DEFINITION SPECIFIES AN INVALID ATTRIBUTE SUCH AS LENGTH PRECISION, OR SCALE ATTRIBUTE.   The objects were previously dropped, and this iteration of FEYIDB2I would create DCD's DB2 object as new .

 

Cause

Bad allocation of TS' Buffer Pool from 32K to 8K.

Environment

Release : 3.0

Component : CA DATA CONTENT DISCOVERY

Resolution

The -604 is being caused by the wrong bufferpool allocation. Shipped with DCD 3.0 is DDL requiring that tablespace to use 32K bufferpools.  However, there was an override for this DDL to use 8K bufferpools.  We ship @[email protected] for several tablespaces (TDCDCVER is where classifierversion table resides) but the input FEYDB2I reflected BUFFERPOOL BP8K1

By specifying the correct BP (as shipped) the -604 will be resolved.