DCD FEYIDB2I Job fails with SQLCODE -604

Products

• 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 .

 

Environment

Release : 3.0

Component : CA DATA CONTENT DISCOVERY

Cause

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

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 @DB2_BUF_POOL_32K@ 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.