IMS database migration

[IMS developer]

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.

[PM \(pm3iinc-nospam\)]

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" <le*************@hotmail.com> a écrit dans le message de
news:12**************************@posting.google.c om...

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.

[Bill]

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:

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.

[IMS developer]

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)@sympatico.ca> wrote in message news:<Dg*********************@news20.bellglobal.co m>...

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" <le*************@hotmail.com> a écrit dans le message de
news:12**************************@posting.google.c om...

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.

[IMS developer]

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

Bill <wf*****@optonline.net> wrote in message news:<FV********************@news4.srv.hcvlny.cv.n et>...

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:

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.

[PM \(pm3iinc-nospam\)]

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.)

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?

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.ibm-main