Results 1 to 7 of 7
  1. #1
    Join Date
    Mar 2004
    Location
    Ottawa
    Posts
    21

    Arrow Unanswered: Load database from UDB to S/390

    Hi, how can I take a table in my Windows NT 4 UDB 7.2.4 database and transfer it to my exact same table on my database running on S/390 v7.1?

    In other words, how can take a table from a PC environment and transfer it to the mainframe side which the mainframe side would understand the PC format? Any examples of files or JCLs would be appreciated.

    Thanks.
    Mbourd25

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    I can think of two options :

    1) Export the Windows DB2 Table in ixf format and use IMPORT Command to get the data into DB2 for OS/390

    2) Use Crossloader on the mainframe to 'pull' data from Windows .

    The former one requires DB2 Connect ...

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    May 2004
    Posts
    5
    Hi, how can I take a table in my Windows NT 4 UDB 7.2.4 database and transfer it to my exact same table on my database running on S/390 v7.1?
    If you are talking about data and this is the only software you have. Then the easy way is to :

    Export you data to a csv flat file.
    FTP the csv file to a Mainframe PDS using TCP/IP.
    Use that PDS as input to your OS/390 load utility.

    Good Luck.

    p.s. If you have more IBM software let us know and their could be several more solutions.

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Just curious MrBill,
    did Version 7 on zOS support load from a delimited file ?

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    Mar 2004
    Location
    Ottawa
    Posts
    21
    MrBill, would you have an example of the export command you would use on the PC and an example of the LOAD command you would use in your JCL?

    Thanks.
    Mbourd25

  6. #6
    Join Date
    May 2004
    Posts
    5
    Sorry for the confusion.
    I went back to see how we have it running and I will list all the steps.
    This is going form udb on nt to db2 on z/os.

    1) we use QMF for windows to do the extract to a flat file. scheduled as qmf batch.
    2) we save one copy as a csv and one copy as a txt.
    3) the csv copy goes to our backup udb on nt.
    4) the txt file is ftp to the mainframe
    5) standard os/390 load utility is used.

    I am currently converting this process to the warehouse manager. makes it a lot easier.

  7. #7
    Join Date
    Mar 2004
    Location
    Ottawa
    Posts
    21
    So I'm better off to continue the way that I operate.

    I use Microsoft Quickwin version 3.00 which has spufiwin version 2.00 from IBM integrated to extract my data from the DB2 UDB v7.2.4 to a flat file and from their I FTP the file to the mainframe. From their I can just run a simple load. I want to get rid of Spufiwin since it's dated back 1994 and I wanted to use something more efficient.

    Thanks for your help.
    Last edited by mbourd25; 05-13-04 at 12:04.
    Mbourd25

Posting Permissions

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