KFAA50239-E
A chunk to be deleted in the table ("aa....aa"."bb....bb") could not be deleted, because an SQL statement or a command has been referencing the table from before the completion of reorganization phase 1 of the previous execution of the adbreorgsystemdata command. (M+S)
Before the completion of phase 1 of the previously executed adbreorgsystemdata command to reorganize the system table, another SQL statement or command is referencing the table "aa....aa"."bb....bb". Therefore, the adbreorgsystemdata command cannot delete the data before reorganization.
- aa....aa:
-
Schema name
- bb....bb:
-
Table identifier
- S:
-
Terminates processing.
- Action:
-
Take one of the following actions. Then, re-execute the adbreorgsystemdata command.
-
Wait for termination of the SQL statement or command that is referencing table "aa....aa"."bb....bb" .
-
Manually terminate the SQL statement or command that is referencing table "aa....aa"."bb....bb" without waiting for its termination.
For details about how to terminate SQL statements and commands manually, see Reorganization of a system table and lock control in the HADB Setup and Operation Guide.
-