search cancel

Issue while executing masking job for DB2 Mainframes DB - Need help/guidance

book

Article ID: 241260

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

While executing the masking job for one of the DB2 Mainframes tables, we are getting job abended error with RC=12.
The strange part is the masking job is working fine for a few other DB2 tables/DBs in the same environment but throwing errors for this table.

below is the error we are seeing:
DSNT408I SQLCODE = -104, Error: Illegal Sybol "End-ofStatment>"
Some symbols that might be legal are: not exists xmlexists
array_exists + - Case current

We have also verified from our DBA team if the table has any missing privileges, but that’s not the case here.
The table shares the same privileges as that of other tables for which we are able to perform the successful masking using the same job.

Need your help/guidance in resolving this issue.

 

Cause

For masking a Primary key is required on the target table

Environment

TDM Mainframe 4.9.X 4.10.X

Masking 

Resolution

The DBA for the client must add a primary Key to the Table being masked:

Reading the screen print seems that the table that is being masked has now primary keys set up.
MF TDM does now allow masking in a table without primary keys.
Normally, -104 is related to some kind of syntax error in the SQL Statement.
But it can be caused because of the missing primary key.

Attachments