DSNT314I INVALID PARTITION SPECIFICATION FOR OBJECT object-name

Explanation

The PART keyword was specified for an invalid object type in a START DATABASE, STOP DATABASE, DISPLAY DATABASE, or ACCESS DATABASE command.

object-name
The name of the table space or index space that was specified with the PART keyword.

The PART keyword is invalid if it is specified for any of the following objects types:

  • Non-partitioned table spaces
  • Non-partitioned type 1 indexes
  • Type 2 indexes not defined on a partitioned table space
  • Start of changePartition-by-growth (PBG) table spaces in a work file databaseEnd of change

No action for this table space or index space is performed by the START DATABASE, STOP DATABASE, DISPLAY DATABASE, or ACCESS DATABASE command. Any other valid table space or index space specified is processed by the command.

System action

The command is not processed for the specified table space or index space. All other valid table spaces or index spaces specified in the command are processed.

User response

Resubmit the command for the table space or index space without using the PART keyword.

Problem determination

In the Db2 catalog, the SYSIBM.SYSTABLESPACE table indicates whether a table space is partitioned, and the SYSIBM.SYSINDEXSPACE table whether an index space is partitioned and whether the index space is a type 1 or a type 2 index.

Type 2 nonpartitioned indexes can be started, stopped, displayed, or accessed at the logical partition level; type 1 cannot.

Severity

8 (error)