Load pending state

You can use queries to detect and remove the Load pending state.

Symptoms

During a LOAD operation, you might get the following DB2 error:

TEXT: [IBM][CLI Driver][DB2/LINUXX8664] SQL0668N Operation not allowed for reason 
code "3" on table <schema_name>.<table_name>. SQLSTATE=57016

SQL0668N reason code 3 indicates that the table is in the Load Pending state. A previous LOAD attempt on this table resulted in failure. No access to the table is allowed until the LOAD operation is restarted or terminated.

Resolving the problem

You can use the following query to detect the Load pending state:

User response:

Select TABSCHEMA, TABNAME, LOAD_STATUS from SYSIBMADM.ADMINTABINFO where 
load_status = 'PENDING' and tabschema = "'<schema_name>'

Restart or terminate the previously failed LOAD operation on this table by issuing LOAD with the RESTART or TERMINATE option.

You can use the following query to terminate the Load pending state:

Load from /dev/null of del terminate into '<schema_name>'.<table_name>

Example:

$ db2 connect to PV
$ db2 "select TABSCHEMA, TABNAME, LOAD_STATUS from SYSIBMADM.ADMINTABINFO where 
load_status = 'PENDING' and tabschema = 'PV_METRIC'"
$ load from /dev/null of del terminate into PV_METRIC.C02_1MGA_000_S0 nonrecoverable
$ db2 disconnect PV

For more information, see