I am doing loading of tables from z/os to LUW.



i used db2move load -io replace option.for this few tables are going to check pending state and hense tablespace is also going to check pending state.

so i thought of using db2move import -io replace option but for this its giving the below error.

I am loading a parent table getting below error any idea how to rectify this situation??


SQL3153N The T record in the PC/IXF file has name "tab2.ixf", qualifier "",
and source " ".

SQL3201N The specified table cannot be replaced because another table is
dependent on it.

SQL3110N The utility has completed processing. "0" rows were read from the
input file.

sl000247:/db2mig/data/5_provi $ db2 ? SQL3201N


SQL3201N The specified table cannot be replaced because another table

Hello kanakarajuy,

You have to turn off all FKs for these tables.

Regards,
Perallis

Previously wrote:

Hello kanakarajuy,

You have to turn off all FKs for these tables.

Regards,
Perallis

Hello Peralls,

Thanks for your help.You mean i need to turn OFF the FKs during import and again turn ON once import is done is it ?

could you pelase help me how to turn of the all FKS ...i mean i need a syntax to trun OFF.

Appriciate your help.

Thanks
kanaka

Previously kanakarajuy wrote:

Previously wrote:

Hello kanakarajuy,

You have to turn off all FKs for these tables.

Is this right way of doing the import? can we get accurate and consistence data to be loaded into database with this approach??

Regards,
Perallis

Hello Peralls,

Thanks for your help.You mean i need to turn OFF the FKs during import and again turn ON once import is done is it ?

could you pelase help me how to turn of the all FKS ...i mean i need a syntax to trun OFF.

Appriciate your help.

Thanks
kanaka

db2 alter table <tbname> drop foreign key <foreign_name>

or

db2 alter table <tbname> alter foreign key <foreign_name> not enforced