Executing Fast Load with UPDATE-CATSTATS ALL and receiving: DSNT408I SQL-151 UPDATE OPERATION INVALID SYSTABLEPART CARD.

Products

• Fast Load for DB2 for z/OS

Issue/Introduction

 Fast Load for DB2 for z/OS (PFL) executing with UPDATE-CATSTATS ALL specified is failing due to message:

DSNT408I SQLCODE = -151, ERROR: THE UPDATE OPERATION IS INVALID 2:09:36
BECAUSE THE CATALOG DESCRIPTION OF COLUMN SYSIBM.SYSTABLEPART-
.CARD INDICATES THAT IT CANNOT BE UPDATED

Cause

The SQL-151 error may be related to a timing problem with other concurrent PFL executions.

Resolution

Recommendations to bypass the SQL-151 error updating SYSTABLEPART and SYSINDEXPART:

- Utilize the DISABLE_DB2_CAT_UPDATE (ALL,RC4) option within the PDA member of
hlq.CDBAPARM to bypass the DB2 Catalog update process. The recommendation would
be to execute IBM RUNSTATS to update the DB2 catalog statistics following the
PFL executions.

-  Secondary option would be to specify DISABLE_DB2_CAT_UPDATE (PDA,RC4) and
UPDATE_SYSXPART (N) in the PDA member of hlq.CDBAPARM which will bypass the
update of SYSTABLEPART and SYSINDEXPART. The remaining DB2 catalog tables
will be updated during the PFL execution with UPDATE-CATSTATS ALL specified.