DB2/400 masking job throws SQL 7008 error

Products

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

Issue/Introduction

We are getting SQL 7008 error while performing masking for DB2400 application. When we checked with application team, they are saying they didn't require journaling in staging server. Could you please provide solution to perform masking without journaling for particular library.

Exception type (internal) executeBatch A
Message: [SQL7008] ><TABLES> in <DATABASE> not valid for operation.
SQLSTATE: 55019
Errorcode: -7008

Environment

FDM 4.10+

Cause

There were code changes introduced in FDM 4.10.x that now require masking with transactions. The reason for this change is that there were multiple instances with FDM 4.9 and older releases, where database corruptions occurred because FDM did not use the transactions kept in the journal for tracking the masking updates. As a result, we changed the product since 4.10 to use the transactions in the journals to ensure DB corruption does not happen anymore.

Resolution

FDM now requires journaling to be enabled. We do not support masking without transactions. The proper solution is to enable journaling for the table.

In short, FDM is working s designed.