PUT6304E SQL ALTER failed with SQLCODE -551 in CSECT UTAGLPBX executing Fast Load

Products

• Fast Load for DB2 for z/OS

Issue/Introduction

Executing Fast Load for Db2 for z/OS (PFL) and encountering the following message:

DSNT408I SQLCODE = -551, ERROR:  authid DOES NOT HAVE THE PRIVILEGE TO
         PERFORM OPERATION ALTER TABLE ON OBJECT creator.tablename

The tablespace is "partition by growth". MAXPARTITIONS was large enough to allow for more partitions. Have not used ALTER OBJECT to add a partition to the PBG
tablespace but that appears to be what was going on. The job is used by an application team and we do not grant them ALTER ability. Is there a resolution to this problem.

We got out of the problem in this case by increasing the DSSIZE.

Environment

 

 

Resolution

Look at Fast Load: Verify Required Authorizations

Note:

"If you are loading a partition-by-growth (PBG) tablespace and you have LOAD authority (and no higher-level Db2 authorization) for the database, you must have
ALTER authority on the loaded table when Fast Load instantiates a new partition to the PBG tablespace."

Therefore ensure that the authid referenced in the message has the ability to ALTER the PBG so that the tablespace can be altered as it grows.
Ensure that the SYSADM userid has the authority to update the Db2 catalog in this case that table. 

The workaround of increasing the DSSIZE would have prevented the need to instantiate a new partition and therefore no need to do an ALTER of the PBG
avoiding the -551. Consider carefully what value DSSIZE for this PBG should be set at depending on its usage profile.