When you loading all database with db2move command, propably most of the tables being loaded are in pending state. To check which ones, execute SQL statement:

SELECT tabname,status,const_checked FROM syscat.tables WHERE status='C'

This command will list all tables in pending state


Reson code:

* "1" - table is in pending state - to fix this execute

SET INTEGRITY FOR table_name IMMEDIATE CHECKED

* "3" - previous load operation on this table failed. You have to terminate or restart previous load command

What do you do if you don't know the original command used to perform the load? How do you restart or terminate?

I think you just need to know the table name.

What file name / type will you use? What if load temporary files are missing?

I am not sure about a restart, but for a terminate:

db2 load from /dev/null of del terminate into table-name

What if the table is in load pending on some partitions? (DPF). How do you take it out of load pending state?

I think, its the same way then, isn´t it?

https://www-304.ibm.com/support/docv...id=swg21222646