I have encountered issues a few times when a process of mine performs a bulk load to a temp table we use for pre-processing purposes. The Bulk load fails for one reason or another (this we are looking into and addressing separately), and then the table that we were bulk loading to gets locked up. Quiesce/Unquiesce and even restarting DB2 are not releasing the lock on this table.
Here is a screenshot of the error in question that we receive every time:
This error code means 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.
Is there any command or way to circumvent this or regain access to this specific table? We have many other processes running when this bulk load runs so restarting DB2 is a very undesirable option and, in our case right now, has not freed up the table.
Apologies if this is not enough information to go off of, please let me know what else I should provide if needed.