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
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