DSNU256I csect-name INVALID PARTITION SPECIFICATION

Explanation

An invalid PART option was specified.

csect-name
The name of the control section that issued the message.

The PART option is invalid in the following situations:

  • When it is specified for a nonpartitioned table space.
  • If the indicated PART integer is not pertinent to the partitions existing for the indicated table space.
  • If a ROWID column is part of the partitioning key.
  • If LOAD INTO TABLE PART x is performed on a table space where an identity column is part of the partitioning key
  • If LOAD INTO TABLE PART x is performed on a partition-by-growth table space
  • If REORG PART x is performed on a partition-by-growth hash table space
  • If LOAD INTO TABLE PART x REPLACE is performed on a table space that is being converted to hash table space
  • When the table space is placed in the restrictive REORG-pending (REORP) state because a RECOVER job was run on the table space to recover the data to a point in time prior to the materialization of pending definition changes

System action

The error is sufficient to terminate further processing of the utility job step. The utility job step is terminated, and resources are released to their previous state.

User response

Determine the correct partition specification for the table space that was the subject of the specified control utility statement, and resubmit the utility job step. Examine the SYSIBM.SYSTABLESPACE in the Db2 catalog for the correct range of partition numbers for the table space.

If a partition-level operation is not allowed, modify the utility job for table-space-level operations.