IMS database migration

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • IMS developer
    #1

    IMS database migration

    We have a requirement to migrate an IMS database to Oracle. We would
    like to write some in house tools for extracting IMS data and
    transforming it to Oracle sqlldr format.

    Is it an easy task?
    What is the best way of achieving this?
    Read IMS FDR files? or use some export utility for reading IMS
    segments info ? Where can I get the format of these files?

    Are there any third party tools available for this? How much it would
    cost for a 10 gig databse?

    Any help in this regard is appreciated.
    Tags: None
    • PM \(pm3iinc-nospam\)
      #2
      Re: IMS database migration

      trimar fast unload
      file-aid ims

      You should ask your ims dba to see what you've got on-site.
      I'm a but rusty on my ims skills but i thnk you can get the layout from the
      DBD's. (dbdgen, psbgen)
      Most shops have 'one time shots' with ims ssa's to scan.

      To better estimate the task, see how many segments you have.
      If you replace ims, don't forget to check to see if you're using GSAM's.

      PM

      "IMS developer" <legacymigratio n@hotmail.com> a écrit dans le message de
      news:12c96e7c.0 312040915.55e69 1ba@posting.goo gle.com...[color=blue]
      > We have a requirement to migrate an IMS database to Oracle. We would
      > like to write some in house tools for extracting IMS data and
      > transforming it to Oracle sqlldr format.
      >
      > Is it an easy task?
      > What is the best way of achieving this?
      > Read IMS FDR files? or use some export utility for reading IMS
      > segments info ? Where can I get the format of these files?
      >
      > Are there any third party tools available for this? How much it would
      > cost for a 10 gig databse?
      >
      > Any help in this regard is appreciated.[/color]


        Comment

        • Bill
          #3
          Re: IMS database migration

          Hi All,
          why would anyone want to migrate an IMS database 'as-is' to oracle. Why
          wouldn't you want to structure the data to meeet your current needs,
          rather than the needs of 20 some years ago ?

          Bill

          - IMS has no data types - so dates etc will probably be in character
          format (with many invalid dates - at least we have in our IMS databases)
          , numbers will be invalid etc etc.

          IMS developer wrote:
          [color=blue]
          > We have a requirement to migrate an IMS database to Oracle. We would
          > like to write some in house tools for extracting IMS data and
          > transforming it to Oracle sqlldr format.
          >
          > Is it an easy task?
          > What is the best way of achieving this?
          > Read IMS FDR files? or use some export utility for reading IMS
          > segments info ? Where can I get the format of these files?
          >
          > Are there any third party tools available for this? How much it would
          > cost for a 10 gig databse?
          >
          > Any help in this regard is appreciated.[/color]

            Comment

            • IMS developer
              #4
              Re: IMS database migration

              Thanks for your help.

              Does trimar fast unload output all the segments to a file
              sequentially?
              I mean, can I write a C program to read IMS segments(using DBD) one by
              one from the outputted file? Is it that simple?

              Also there are so many databse types (DEDB, MSDB, HDAM, GSAM etc).
              Does trimar fast unload work with all these database types and is the
              format of the output files samilar for all database types?

              -MV




              "PM \(pm3iinc-nospam\)" <PM(pm3iinc-nospam)@sympati co.ca> wrote in message news:<DgOzb.129 09$zf2.1482778@ news20.bellglob al.com>...[color=blue]
              > trimar fast unload
              > file-aid ims
              >
              > You should ask your ims dba to see what you've got on-site.
              > I'm a but rusty on my ims skills but i thnk you can get the layout from the
              > DBD's. (dbdgen, psbgen)
              > Most shops have 'one time shots' with ims ssa's to scan.
              >
              > To better estimate the task, see how many segments you have.
              > If you replace ims, don't forget to check to see if you're using GSAM's.
              >
              > PM
              >
              > "IMS developer" <legacymigratio n@hotmail.com> a écrit dans le message de
              > news:12c96e7c.0 312040915.55e69 1ba@posting.goo gle.com...[color=green]
              > > We have a requirement to migrate an IMS database to Oracle. We would
              > > like to write some in house tools for extracting IMS data and
              > > transforming it to Oracle sqlldr format.
              > >
              > > Is it an easy task?
              > > What is the best way of achieving this?
              > > Read IMS FDR files? or use some export utility for reading IMS
              > > segments info ? Where can I get the format of these files?
              > >
              > > Are there any third party tools available for this? How much it would
              > > cost for a 10 gig databse?
              > >
              > > Any help in this regard is appreciated.[/color][/color]

                Comment

                • IMS developer
                  #5
                  Re: IMS database migration

                  I guess once we have the data in Oracle we can always restructure the
                  way we want it.

                  Bill <wfsent4@optonl ine.net> wrote in message news:<FVjAb.389 7$zK6.1409615@n ews4.srv.hcvlny .cv.net>...[color=blue]
                  > Hi All,
                  > why would anyone want to migrate an IMS database 'as-is' to oracle. Why
                  > wouldn't you want to structure the data to meeet your current needs,
                  > rather than the needs of 20 some years ago ?
                  >
                  > Bill
                  >
                  > - IMS has no data types - so dates etc will probably be in character
                  > format (with many invalid dates - at least we have in our IMS databases)
                  > , numbers will be invalid etc etc.
                  >
                  > IMS developer wrote:
                  >[color=green]
                  > > We have a requirement to migrate an IMS database to Oracle. We would
                  > > like to write some in house tools for extracting IMS data and
                  > > transforming it to Oracle sqlldr format.
                  > >
                  > > Is it an easy task?
                  > > What is the best way of achieving this?
                  > > Read IMS FDR files? or use some export utility for reading IMS
                  > > segments info ? Where can I get the format of these files?
                  > >
                  > > Are there any third party tools available for this? How much it would
                  > > cost for a 10 gig databse?
                  > >
                  > > Any help in this regard is appreciated.[/color][/color]

                    Comment

                    • PM \(pm3iinc-nospam\)
                      #6
                      Re: IMS database migration

                      Trimar is/was a set of tools.
                      One of them was used to unload ims data to sequential files.
                      It's a utility that needs a sysin dataset to know what to unload. (segment
                      name, ...)
                      If you don't already have this tool onsite, you should find another
                      solution.
                      An IMS DBA would be the best person to ask what to use. (someone working at
                      your site.)
                      [color=blue]
                      > Does trimar fast unload output all the segments to a file
                      > sequentially?
                      > I mean, can I write a C program to read IMS segments(using DBD) one by
                      > one from the outputted file? Is it that simple?[/color]
                      My IMS related knowledge dates...
                      The way your process the sequential file depends on how you unload the data.
                      GN(get next), GNP(get next within parent), ...
                      The file may look like
                      s001
                      s002
                      s003
                      or
                      s001, s100, s300
                      s002, s100, s200
                      s003, s400


                      Anyway, you may not be allowed to run any tool you wish on production.
                      There are probably some IMS utilities that i don't know of or remember that
                      would
                      unload. For simplicity and probably because i don't master IMS, i'd go with
                      plain
                      cobol with psb+ssa to unload...and reformat to pic x some fields if needed.
                      (easier to make the data sqlldr compatible, what ever that implies)

                      MSDB's are main storage databases and are cyclic in nature if memory serve
                      me good.
                      Moving the data is one thing but keeping the same functionnality under a
                      different dbms is another thing.


                      PM

                      As far as i can see, there is nowhere the word DB2 in this thread.
                      This is my last post in this thread.
                      You should move to a more appropriate newsgroup.
                      Maybe bit.listserv.ib m-main



                        Comment

                        Previous template Next
                        Working...