Disabling data definition control

When data definition control is active, only IDs with the installation SYSADM or installation SYSOPR authority can stop a database, a table space, or an index space that contains a registration table or index.

About this task

When the object is stopped, only an ID with one of those authorities can start it again.

An ID with the installation SYSADM authority can execute data definition statements regardless of whether data definition control is active and whether the ART or ORT is available.

Procedure

To bypass data definition control, an ID with the installation SYSADM authority can use the following methods:

  • If the ID is the owner of the plan or package that contains the statement, the ID can bypass data definition control by using a static SQL statement.
  • If the ID is the current SQL ID, the ID can bypass data definition control through a dynamic CREATE statement.
  • If the ID is the current SQL ID, the primary ID, or any secondary ID of the executing process, the ID can bypass data definition control through a dynamic ALTER or DROP statement.