VSAM to DB2 conversion

craig2020 · New User Joined: 30 Jan 2007 Posts: 7 Location: Chennai

Hi
We are currently working on a project to convert VSAM to DB2 in a legacy online system .

We have completed the creation of tables for all the VSAM files used in the online system as per the recommendations of DBA.

Now we are in the process of rewriting the application. We have plans to employ dual method(usage of VSAM and Db2 parallel for some time) and then drop the usage of VSAM files once the system is without any issues after employing the DB2 tables.

Most of the field structures in VSAM and the DB2 are different.
eg:
Field in VSAM Column in Table.
s9(10)v9(2) - s9(15)v9(3) comp-3
9(8) ----------- x(10)

To employ the dual method, we need to have a common routine which converts the structure of fields in the VSAM file to DB2 column structure and vice versa.

Is there any routine available to convert structure of the fields or can anybody provide some example routines which can do the above work. Please provide your inputs and valuable suggestions.

Thanks for your help in advance

birdy K · Posted: Wed Jul 02, 2008 3:56 pm Post subject:

I think, there is no such routine to change the structure of fields. Have to do manually. Corrections are welcome.

Rajkumar_n · Posted: Wed Jul 02, 2008 8:43 pm Post subject:

Define a new file in your program which is compatible to DB2 lay out and
populate required data to the file. Then have one more job to load the data from this new file to DB2

dick scherrer · Posted: Wed Jul 02, 2008 10:17 pm Post subject:

Hello,

When the field attributes are changed, it will probably cause the code using those fields to change also - the original code will most likely no longer work correctly.

Just a reminder if this hadn't already been thought of. . .

craig2020 · New User Joined: 30 Jan 2007 Posts: 7 Location: Chennai

Hi Dick Scherrer,

Yes you are right. To avoid making changes to the codes which are useing the field attributes of the vsam files we are converting the attributes of corresponding columns in the table to that of the field attributes of the VSAM file, when ever the table is read.
This ensures that we do not need to make changes in the programs, which eventually reduces the impact down the line.

To acheive this we are trying find a common routine to convert the field attributes of the table columns to that of the VSAM file

Whenever the VSAM file gets updated online, then the field needs to be converted to match the attribute of the corresponding table column , so that it gets updated in the table.
For this we need a routine to convert the attribute of the VSAM file to that of the table colums.

Hope this clarifies your question. We appreciate any suggestion and advice on this. Thanks.