Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    9

    Unanswered: Application Relations in DB2 V6.0 on S/390

    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

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Can you explain what you mean by "application relations."
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jan 2005
    Posts
    191
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •