DSNU1170I csect-name UNABLE TO EXTEND PARTITION-BY-GROWTH TABLESPACE database-name.tablespace-name BECAUSE OF reason
Explanation
The partition-by-growth table space could not be extended.
- csect-name
- The name of the control section that issued the message.
- database-name.tablespace-name
- The name of the database and table space.
- reason
- The reason that the partition could not be extended. reason can
have one of the following values:
- LOB COLUMNS
- Rows with LOB columns changed partitions during REORG. This change is not allowed. However, this partition change occurred, because a change has been made to the attributes of the table space so that a row with LOB columns cannot be reloaded to the partition to which it belongs.
- MAXPARTITIONS LIMIT
- The partition could not be extended because the number of partitions has reached the maximum partitions limit.
System action
Utility processing is discontinued.
User response
Take
one of the actions that corresponds to the reason value:
- LOB COLUMNS
- In your REORG TABLESPACE utility control statement, set the AUX option to YES so that the associated LOB table spaces are also reorganized. Then, run the utility job again.
- MAXPARTITIONS LIMIT
- Increase the maximum number of partitions by using ALTER TABLESPACE.