Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2005
    Posts
    1

    Unanswered: DB2 on AIX to DB2 V7.2 on z/OS

    Hi,

    I need information on how to move data from DB2 on AIX to DB2 V7.2 on z/OS. What is the first step to be taken in preparing the data for this purpose

  2. #2
    Join Date
    Dec 2004
    Posts
    11

    Lightbulb

    The two most important elements are Frequency and Volume.

    How often are you wanting to do this?
    How much data are we talking about?
    Are the two systems connected by a SAN, if not, how are they to be connected?


    The most basic way of performing this task is to use the cross-loader tool.
    It opens a cursor on the source table and writes all of the selected data
    out to a load file which is then loaded to the target table by the DB2 load utility.

    Have a look on the IBM redbooks for more detailed information.

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    IIRC, Cross-loader has problems when handling large amounts of data .. And Cross-loader in V7 does not provide support for LOBs
    Last edited by sathyaram_s; 01-10-05 at 13:10.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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