Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
VSAM to DB2 conversion - SQL
- Thread starter 345A
- Start date
Use the IBM-supplied sample program DSNTIAUL to create load cards. This is an unload program. Although there will not be any data, the program will still create the load cards.
If there isn't a one-to-one correspondence between VSAM files and tables (and there shouldn't be if the model is normalized), the fields on the VSAM file will have to be distrbuted into different flat files. Use programs, Syncsort, IDCAMS, IEBGENER, whatever makes sense.
Sort the data into cluster order before loading for a faster load.
Load the data into the tables using DSNUTILB utility. (Executed natively or via DSNUPROC.
If there isn't a one-to-one correspondence between VSAM files and tables (and there shouldn't be if the model is normalized), the fields on the VSAM file will have to be distrbuted into different flat files. Use programs, Syncsort, IDCAMS, IEBGENER, whatever makes sense.
Sort the data into cluster order before loading for a faster load.
Load the data into the tables using DSNUTILB utility. (Executed natively or via DSNUPROC.
- Status
Similar threads
- Locked
- Question