SELECT TABSCHEMA, TABNAME, LOAD_STATUS FROM SYSIBMADM.ADMINTABINFO WHERE LOAD_STATUS = 'PENDING'
How to get TABSCHEMA.TABNAME table out of Load Pending State:
db2 "LOAD FROM /dev/null OF DEL TERMINATE INTO TABSCHEMA.TABNAME NONRECOVERABLE"
db2 "SET INTEGRITY FOR TABSCHEMA.TABNAME IMMEDIATE CHECKED"
Ni komentarjev:
Objavite komentar