Db2"importfrom child.del of del insert into childt "sql0530n foreign key" huangdk.childt.f_ct "insert or update the parent table is not equal to the value of any parent key> article describes the right quickimportor load multiple db2 main practical steps from the table, if youimportor load multiple db2 main practical steps from the table , are interested in, you can visit the following article is a problem in the database maintenance, database administrators sometimes need to move between different database large amounts of data, and these data in our business with master-slave (father and son ) the relationship between the table, then we export, import, or load, it is sometimes encountered sql0530n, sql0668n the error message, then how do we avoid these errors, to ensure that they operate correctly and quickly completed? answer Suppose we create the following two db2 master table: create table parentt (id int not null, name char (20) not null, constraint p_pt primary key (id)) create table childt (id int not null, cname char (40 ) not null, pid int, constraint p_ct primary key (id), constraint f_ct foreign key (pid) references parentt (id) on delete cascade) If the primary table parentt import data is not, then we used to import from the table childt encounter errors when importing data sql0530n, the reason why there is this error is because the import foreign key referential integrity constraints need to check if the main table is not relevant records, is not allowed to import the data if the method can be loaded using the load data, because the load is designed to check constraint ignored when loaded, but the query data, encounter sql0668n rc = 1db2 "load from child.del of del insert into childt" db2 "select * from childt" sql0668n does not allow Table "huangdk.childt" perform the operation, reason code "1" reason code "1" means: Table "huangdk.childt" in the "check pending" status is not mandatory checks from the table "huangdk.childt" referential integrity, and Table of contents may be invalid if the dependent table is in check pending state, not in check pending for the parent table or underlying table of the operation may also receive this error in the data into the main table parentt, you can use the following statement to the table to return to normal state: db2 set integrity for huangdk.childt immediate checked db2 master with a large number need to load the operating table, the database administrator statement will waste a lot of time, and if the data is not loaded in the main table before the implementation of the above statement, it will also encounter sql0530n of error of fact, if we are first loaded into the main table or data, you will not encounter the above error, do not need to perform set integrity statement simplified view of the operating system we syscat.references can be found in the master-slave relationship between the table, using the following sql statement: db2 "select substr (reftabscha, 1,20) as the main table mode, substr (reftabname, 1,30) as the main table, substr (tabscha, 1,20) as shown in Table mode, substr (tabname, 1,30) as from the table from syscat.references "main table mode from the main table from the table model table asn_down_tc_m6101 ibmqrep_sendqueues asn_down_tc_m6101 ibmqrep_subsasn_down_tc_m6101 ibmqrep_subs asn_down_tc_m6101 ibmqrep_src_colshdk parentt hdk childt (Practice Editor: hj )>