Migration from MVS to Oracle 10

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Uik
    New Member
    • Dec 2007
    • 3
    #1

    Migration from MVS to Oracle 10

    Hi all,

    I have a bunch of tables (peopleSoft tables) and i want to migrate them to an Oracle 10i server.

    I'm looking for a fast process like an Export from DB2 (MVS z/OS V7) and a load data to my Oracle Server. I'm facing problem because DB2 MVS V7 can't export data in an ASCII mode and as a consequence i'm not able to load data in oracle...
    I can only use the IXF format that is not supported by Oracle server ...

    Any help would be appreciated.

    Regards,
    Alexis BRICE
    Tags: None
    • docdiesel
      Recognized Expert Contributor
      • Aug 2007
      • 297
      #2
      Hi,

      I'm more from the Linux side of the world, but as far as I know the z/world the following should work:
      1. Export the data from DB2 in delimited (DEL) or fixed length (ASC) format.
      2. Open an ftp connection from your Oracle server to the mainframe.
      3. Download the EBCDIC datasets in ftp ASCII mode.
      4. The host ftp server should convert them automatically from EBCDIC to ASCII.
      5. Load the files into Oracle.
      Regards, Bernd

        Comment

        • Uik
          New Member
          • Dec 2007
          • 3
          #3
          HI,

          Thx for your reply docdiesel, your process should be good with an DB2 UDB database but the export utility from db2 for z/OS (v7) don't allows you to export in an ASCII or a DEL mode but only in IXF format which is only supported by DB2 databases... here is my issue !

          Thx for any help.

          Regards,
          Alexis BRICE

            Comment

            • docdiesel
              Recognized Expert Contributor
              • Aug 2007
              • 297
              #4
              Hi,

              hmmmm, well, ... as far as I remember there's a SQL command tool called SPUFI or so. Furthermore, there's a binary for SQL in batch/JCL the name of which I don't recall. Could you start something like

              Code:
              SELECT some_int, ',"', somevarchar, '",', ...
              and store the results in EBCDIC datasets before transfering them via FTP?

              Otherwise, there's the following way which should work. IBM offers a free LUW version of DB2, called Express-C, for download. Install it on Linux or window$ and LOAD there the IXF's you exported at first on the mainframe. On the LUW system you then should be able to export ASC/DEL format.

              Regards,

              Bernd

                Comment

                • Uik
                  New Member
                  • Dec 2007
                  • 3
                  #5
                  Hi all,

                  Thx docdiesel for your reply i wiil try the LUW version of DB2 u pointed at, i'll try it after new year and give u a feedback here !!

                  In the meanwhile happy xmass and new year :p

                  Regards
                  Alexis BRICE

                    Comment

                    Previous template Next
                    Working...