Error "DB2 SQL Error: SQLCODE=-401, SQLSTATE=42818" during DB2 PII scan

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Getting the error "DB2 SQL Error: SQLCODE=-401, SQLSTATE=42818" during PII scan of DB2 database. Looking at the table definition, wanted to confirm if TDM supports below column datatypes like VARGRAPHIC.

=================================================
CREATE TABLE SCHEMA."TABLE"                             

   (COL1            VARGRAPHIC(32) NOT NULL WITH DEFAULT ' ', 

    COL2            DBCLOB(123456789) NOT NULL               

       INLINE LENGTH 1000,                                             
=================================================

Environment

TDM Portal 4.11

Cause

The reported issue was analyzed to be due to default ROWID datatype was not being handled during PII scan.

Resolution

Download and apply below patch:

 https://ftp.broadcom.com/user/downloads/pub/TDM/TDMWeb/TDMWeb-4.11.2038.0.zip

Article to apply the patch build:

https://knowledge.broadcom.com/external/article?articleId=10931