Tables in LOAD pending
Submitted by Vikram Khatri on Fri, 2007-12-28 18:25.
If you are using LOAD utility to load 100s of tables, you can use following SQL to find out the tables which are in LOAD pending status.
SELECT TABSCHEMA, TABNAME, LOAD_STATUS FROM SYSIBMADM.ADMINTABINFO WHERE LOAD_STATUS IS NOT NULL