SQLCODE -5003 Cannot perform operation under commitment control.

Explanation

The following operations cannot be performed under commitment control with COMMIT(*CHG), COMMIT(*CS), or COMMIT(*ALL) specified:
  • DROP SCHEMA statement.
  • GRANT or REVOKE statement to an object that has an authority holder.
  • CREATE statement in SQL naming mode of an object that has an authority holder.
  • DROP of a text search index.

These operations cannot be committed or rolled back.

User response

Specify COMMIT(*NONE), and try the statement again.

SQLSTATE: 42922