Table Load Sequence

trilokdewangan · New User Joined: 19 Jun 2008 Posts: 39 Location: USA

Hello,

I have a complex DB2 database where the RI relation is complex (parent, child relationship). I am trying to create a load process for whole database, but I don't have sequence (order) to load the tables. Can anyone suggest on this?

Thank you.

dick scherrer · Posted: Thu Jun 03, 2010 1:03 am

Hello,

Depending on specifics, you could load all of the tables that have no RI constraints. Then load the tables that require these other tables to be loaded.

Again, depending on specifics, you might consider taking off the RI until after the tables are loaded. This depends on 100% of the data being valid as relates to the RI rules or there will be problems.

Possibly, i have misunderstood the question. . .

dbzTHEdinosauer · Posted: Thu Jun 03, 2010 1:33 am

there are topics in this forum that discuss determining the RI relationships between tables.
a search should provide that sql.

or you can start with E.1 Retrieving catalog information about ...

here are 4 sysibm.tables that will help:
SYSIBM.TABLE_CONSTRAINTS
SYSIBM.CHECK_CONSTRAINTS
SYSIBM.REFERENTIAL_CONSTRAINTS
SYSIBM.REF_CONSTRAINTS

dbzTHEdinosauer · Posted: Thu Jun 03, 2010 1:40 am

Besides,
some DBA in your shop has this documented. try checking with him/her.

GuyC · Posted: Thu Jun 03, 2010 8:01 pm

load enforce no and do checks afterwards ?

ibmmainframes.com/viewtopic.php?t=46958

satyender · Posted: Fri Jun 04, 2010 4:21 am

trilokdewangan,

Try the below query:

SELECT NAME, '' AS PARENT_NAME FROM SYSIBM.SYSTABLES A WHERE CREATOR = 'USER_ID' AND NAME NOT IN
(SELECT TBNAME FROM SYSIBM.SYSRELS WHERE CREATOR = 'USER_ID' )
UNION
SELECT A.TBNAME AS NAME , A.REFTBNAME AS PARENT_NAME FROM SYSIBM.SYSRELS A WHERE CREATOR = 'USER_ID'