DSNU1152I csect-name utility-name SHRLEVEL option OF object-type object-qualifier.object-name IS NOT ALLOWED

Explanation

The SHRLEVEL option was specified incorrectly for a utility.

csect-name
The name of the control section that issued the message.
utility-name
The name of the utility: REORG TABLESPACE, REORG INDEX, or REBUILD INDEX.
option
The SHRLEVEL option: CHANGE, REFERENCE, or NONE. The combination of option and utility-name indicates what has occurred.
CHANGE
If utility is REORG TABLESPACE: SHRLEVEL CHANGE was specified when REORG TABLESPACE was run on a NOT LOGGED table space, or on a LOB table space for which the base table space is a NOT LOGGED table space.

If utility is REBUILD INDEX or REORG INDEX: SHRLEVEL CHANGE was specified when REBUILD INDEX or REORG INDEX was run on an index that is defined on a NOT LOGGED table space.

REFERENCE
SHRLEVEL REFERENCE was specified when REORG TABLESPACE with PART was run on a NOT LOGGED table space on which nonpartitioned indexes are defined.
NONE
SHRLEVEL NONE cannot be specified in the following situations:
  • For a table space with hash organization.
  • When REORG TABLESPACE is run against either DSNDB06.SYSTSVOL or DSNDB06.SYSTSSTG and the table space has a user-defined index that uses a storage group that is managed by Db2.
object-type
The type of object: INDEX, INDEXSPACE, or TABLESPACE.
object-qualifier.object-name
The name of the object, as a qualified name.

System action

If the utility was operating on a list of objects and OPTIONS EVENT(ITEMERROR,SKIP) was specified, then processing continues to the next object in the list. Otherwise, processing terminates.

Operator response

Take the appropriate action for the object-type value:

NOT LOGGED TABLESPACE
Remove the SHRLEVEL(CHANGE) or SHRLEVEL(REFERENCE) option from the utility statement.
HASH TABLESPACE
Specify either SHRLEVEL(CHANGE) or SHRLEVEL(REFERENCE) option in the utility statement

Severity

8 (error)