Hi All,

We would like to know how to handle Application Relationships while downloading data from 500 tables in DB2 version 6 on S/390.
We know that we can use FILEAID/RDX on mainframes to do similar things, but the issue is it couldn't handle when the number of tables related are very high.
Is there any other way to download the data from tables which are associated with Application relations.

Please let us know asap if anyone has idea regarding this.

We have also BMC tool available on S/390.

Thanks in advance

Can you explain what you mean by "application relations."

Princeton Softech has a tool "Move for DB2" on zOS. ("Move for databases" is their Oracle/SQL Server/DB2 LUW product.

I once wrote a "tool" (aka kludge) which basically
- user inserted starting keys into a start-key-table
- precanned SQL to derived the keys of all the rows to be unloaded (going down SQL or application RI chains, manipulating data formats as needed). Fortunately the only recursive loop I had to deal with only required a single iteration.
- precanned SQL then copied the required rows into export tables
- unload from the export tables.

There was no proper handling of table changes - had to be manually tracked and incorporated into SQL.

James Campbell