OS: SOl 2,9
DB2 9.1 FP4.

All , How do i figure out the dependent tables for a particular tables
or on what table this particular table is dependent on.

I was importing a lot of data and i had plenty of issues because the tables
are either has dependent table or it was a dependent for soem other table.

Is there a easy way to order the tables , like dependents first so that i can load them first.

thanks

I would suggest you turn off constraint checking on all loads; and afterwards use the SET INTEGRITY command. See e.g. p.166 of the "Data Movement Utilities" guide, SC23-5847-01.
The tables will be temporarily in "integrity pending" state during these opterations.

Actually, there is a way to find out about dependencies (by checking the catalog), but you could actually have a "chicken and egg" problem where there is a circular dependency. In that case, none op the possible load sequences would work!

You can also try the following:

select tabname,reftabname from syscat.REFERENCES where tabschema = 'TEST_SCH' and tabname like 'TB_TES%' with ur

Where TABNAME is the CHILD Table and REFTABNAME is the PARENT table.

That will only gather the first level of dependencies, of course. You need a recursive query (see the manuals and search for "Bill of materials") to really get all of them. You will have to take care of circular dependencies in the query as Peter noted.

I see what you are saying. May be if you are interested in looking into the dependency as the pesron on the top is asking for systematic LOAD/IMPORT, the SYSCAT query can be used to understand the dependency level. Moreover for multiple dependencies (in case exists), then the CREAT_TIME field can be used from the REFERENCES table with DESCending option. But yes, do completely agree, if he is least interested to know the dependency, then JUST RUN the LOAD one after another (swicthing off CHECK), and execute INTEGRITY after all Loads are done.