integer L=1
integer CNT=1
DB=sample
TAB=$1

db2 connect to $DB > /dev/null

echo  $TAB > list.txt
rm -f $TAB.ref.txt

while [ $CNT != 0 ]
do

  echo $L"."

  for i in `cat list.txt`
  do

  db2 -x "select substr(rtrim(REFTABSCHEMA)||'.'||REFTABNAME,1,40), substr(rtrim(tabschema)||'.'||TABNAME,1,40), \
                 count(*) over() cnt \
            from syscat.references \
           where substr(rtrim(REFTABSCHEMA)||'.'||REFTABNAME,1,40)='$i'" > ref.tmp

  CNT=`cat ref.tmp|awk '{print $3}' | head -1`
  cat ref.tmp | awk '{print $1,$2}'
  cat ref.tmp|awk '{print $2}' >> list.tmp

  done

  cat list.tmp > list.txt
  rm -f list.tmp

  L=$L+1
  echo

done

< 테스트 >  
sh ref.sh INST1.A

1.
INST1.A INST1.B
INST1.A INST1.D

2.
INST1.B INST1.C

CREATE TABLE B(B_ID INTEGER NOT NULL,
               DEPT VARCHAR(10),
        C VARCHAR(20))IN USERSPACE1;      
ALTER TABLE B ADD CONSTRAINT PK_B PRIMARY KEY(B_ID);       
ALTER TABLE B ADD CONSTRAINT FK_B FOREIGN KEY(B_ID) REFERENCES A ON DELETE CASCADE;

CREATE TABLE D(D_ID INTEGER NOT NULL,
               DEPT VARCHAR(10),
        C VARCHAR(20))IN USERSPACE1;      
ALTER TABLE D ADD CONSTRAINT PK_D PRIMARY KEY(D_ID);       
ALTER TABLE D ADD CONSTRAINT FK_D FOREIGN KEY(D_ID) REFERENCES A ON DELETE CASCADE;

CREATE TABLE C(C_ID INTEGER NOT NULL ) IN USERSPACE1;
ALTER TABLE C ADD CONSTRAINT FK_C FOREIGN KEY(C_ID) REFERENCES B ON DELETE CASCADE;


이렇게 되면 

A -> B -> C
   -> D 

이런 관계로 참조가 되는데 위의 스크립트는 

1.
DB2INST1.A DB2INST1.B
DB2INST1.A DB2INST1.D

2.


이렇게만 나오더라구요..