Operation not allowed for reason code SQL0668N

SQL0668N
The operation on the table name is not allowed. The Reason code is the reason code.

Description
Restrict access to table names. The cause is based on the following cause code:

1
The table is in the "set integrity temporarily unavailable" status. The table integrity is not enforced and the table content may be invalid. If the slave table is in the "set integrity temporarily unavailable" status, therefore, operations performed on the parent table or basic table that are not in the "set integrity temporarily unavailable" status may also receive this error.

2
The table is in the "no data movement" status. In this status, data movement is prohibited. Data movement operations include REDISTRIBUTE, update database partition key, update multi-dimensional cluster key, update range cluster key, update TABLE partition key, and reorg table.

3
The table is in the "load temporarily suspended" status. An error occurred while loading the table. You are not allowed to access the table before restarting or terminating the LOAD operation.

4
The table is in the Read access status. This status can occur during online loading (LOAD) Processing (load insert with read access options) or after online loading (LOAD) operations, except before using the set integrity statement to verify all constraints in the newly appended part of the table. Updates to this table are not allowed.

5
The table is in the "loading" status. The LOAD utility is currently operating on this table and cannot be accessed until LOAD is complete.

6
You cannot refresh the specific query table that references the nickname in ESE.

7
The table is in the "REORG temporarily suspended" status. This situation may occur when you execute the alter table statement containing the REORG suggested operations.

8
The table is in the "change pending" status. This situation may occur when the alter table statement containing the REORG suggested operation is used in the work unit of the statement.

9
The table is in the "redistribution pending" status. The REDISTRIBUTE utility does not complete operations on this table until REDISTRIBUTE is complete.

10
This table is the source table of the ADMIN_MOVE_TABLE operation being executed. The operation you are trying will be restricted before the mobile operation is completed or canceled.

User response
1
Run the set integrity statement with the immediate checked option on the table name to remove the table from the "set integrity temporarily unavailable" status. For the specific query table maintained by the user, execute the statement with the immediate unchecked option instead of the immediate checked option.

2
Execute the refresh table statement on the TABLE name and stage TABLE. You can use the previous load insert operation to add data based on the TABLE name and use the alter table statement with the ATTACH clause to incrementally maintain these sub-statements based on the connection data of the TABLE name. table content.

3
Run the RESTART or TERMINATER option to RESTART or terminate the previously failed LOAD operation on the table.

4
Run the load query command to check whether the table is being loaded. If yes, wait until the LOAD utility is complete, or if necessary, restart or terminate the previously failed "LOAD" operation. If LOAD is not currently in progress, issue the set integrity statement with the immediate checked option to verify the constraints in the newly installed part of the table.

5
Wait until the current LOAD operation is complete. You can use the load query command to monitor the loading progress.

6
Use the maintain by user option to define a specific query table. Then, fill the specific query table with the INSERT statement with subquery.

7
Use the reorg table command to reorganize the TABLE.

For tables in the REORG hold status, note that the following clauses are not allowed during table Reorganization:

Inplace reorg table clause
When a PARTITION table defines a non-PARTITION index, the on data partition clause of the table.
8
Complete the work unit and then re-issue the command.

9
If the REDISTRIBUTE utility is working, wait until it completes processing the current table. You can use the list utilities command to monitor the progress of the REDISTRIBUTE utility. If the previous redistristrioperation fails and the table is in this State, issue the REDISTRIBUTE utility again, specify the CONTINUE or ABORT option, and then let it process the table.

10
Complete or cancel the table movement operation, and then re-issue the command. You can query the SYSTOOLS. ADMIN_MOVE_TABLE table to learn about the mobile operation status.

Sqlcode:-668

Sqlstate: 57007

Author cuiran