Hi,
we are running some DB2 load utilty job to empty the DB2 (multiple) tables by loading with a dummy file.we are giving in the control card as follows
===>
LOAD DATA LOG NO INDDN SYSREC REPLACE INTO TABLE
creator.tablena me1 NOCOPYPEND
LOAD DATA LOG NO INDDN SYSREC REPLACE INTO TABLE
creator.tablena me2 NOCOPYPEND
But after loading some of the tables are going to check pending status.
My question is: Is it okay to add NOCHECKPEND into the load cards?Whats the risk involved?Which is the better idea: To run the check data utilty after the tables goes to check-pending status or adding nocheckpend or using ENFORCE NO is more advisable?
I als0 checked for DDL of the tables.It is as:
ALTER TABLE creator.tablena me1
FOREIGN KEY key1
(column1)
REFERENCES creator.tablena me
ON DELETE CASCADE ;
I would appreciate your any kind of help.Thanks in advance !!!
we are running some DB2 load utilty job to empty the DB2 (multiple) tables by loading with a dummy file.we are giving in the control card as follows
===>
LOAD DATA LOG NO INDDN SYSREC REPLACE INTO TABLE
creator.tablena me1 NOCOPYPEND
LOAD DATA LOG NO INDDN SYSREC REPLACE INTO TABLE
creator.tablena me2 NOCOPYPEND
But after loading some of the tables are going to check pending status.
My question is: Is it okay to add NOCHECKPEND into the load cards?Whats the risk involved?Which is the better idea: To run the check data utilty after the tables goes to check-pending status or adding nocheckpend or using ENFORCE NO is more advisable?
I als0 checked for DDL of the tables.It is as:
ALTER TABLE creator.tablena me1
FOREIGN KEY key1
(column1)
REFERENCES creator.tablena me
ON DELETE CASCADE ;
I would appreciate your any kind of help.Thanks in advance !!!