ponedeljek, 13. februar 2017

DB2 Terminate LOAD

What tables are in Load Pending State:
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: