MVSFORUMS.com

yrcreddy · Beginner Joined: 28 Dec 2005 Posts: 27 Topics: 12

Hi,

we have a requiremt.that is we need to conver DB2 tables data into VSAM files.is there any whay to do this using JCL.
Can you please help me how to do it in the easier way.
_________________
Thanks,
Ramachandra Reddy

shekar123 · Posted: Wed Aug 02, 2006 12:56 am Post subject:

yrcreddy,

First unload the DB2 table data into a dataset and then use REPRO to copy the unloaded data to the VSAM dataset. Hope this helps.
_________________
Shekar
Grow Technically

yrcreddy · Beginner Joined: 28 Dec 2005 Posts: 27 Topics: 12

shekar,

Thanks for your update.
we need to convert aroud 400 tables into vsam files.
For uploading data into flot files.we have to write 400 programs i mean for each table one program.
is there any other way to do this.
_________________
Thanks,
Ramachandra Reddy

shekar123 · Posted: Wed Aug 02, 2006 1:43 am Post subject:

yrcreddy,

You need not code any program to unload data from a DB2 Table however u can use IBM Supplied Utility DSNTIAUL.

DSNTIAUL is a sample unload program of DB2. This program, which is written in assembler language, unloads some or all rows from up to 100 DB2 tables. With DSNTIAUL, you can unload data of any DB2 built-in data type or distinct type. You can unload up to 32KB of data from a LOB column. DSNTIAUL unloads the rows in a form that is compatible with the LOAD utility and generates utility control statements for LOAD. DSNTIAUL also lets you execute any SQL non-SELECT statement that can be executed dynamically.

Check this link for examples of unloading of the tables using DSNTIAUL

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAPH11/APPENDIX1.3.1?DT=20010710165542
_________________
Shekar
Grow Technically

yrcreddy · Beginner Joined: 28 Dec 2005 Posts: 27 Topics: 12

Shekar,

Thanks for your quick response.i went thru the document which you had given in the site.can you please clarify the following query.The site saying the follwong plan name and libraries as follow.

DSN SYSTEM(DSN)
RUN PROGRAM(DSNTIAUL) PLAN(DSNTIB71) -
LIB('DSN710.RUNLIB.LOAD')

Do we need to change any thing while using the DSNTIAUL utility program in my JCL.
_________________
Thanks,
Ramachandra Reddy

shekar123 · Posted: Wed Aug 02, 2006 3:17 am Post subject:

yrcreddy,

Check in your shop for the PDS which will contain the utility Program DSNTIAUL and give the plan name also the same.Hope it helps.

yrcreddy · Beginner Joined: 28 Dec 2005 Posts: 27 Topics: 12

Shekar,

I have verified the the utility program in my shoop.but we didn't find the utility load lib.can you please help me is there any easier why to do this.
_________________
Thanks,
Ramachandra Reddy

coolman · Posted: Wed Aug 02, 2006 10:51 am Post subject:

Look up your prod jobs to see if they have any unload db2 tables, basically copy the step and put it as an instream proc - Call this proc, 100 times from the job - Repeat this job 4 times. So, you would essentially have 4 jobs to unload all 400 tables or many shops would seek the help of DBA's to do this request - The jobs when submitted by DBA's get a better priority and would be much faster - Moreover, they would have to BMC Unload, Plantinum and other new utilities in the market
________
iolite portable vaporizer

kolusu · Posted: Wed Aug 02, 2006 11:06 am Post subject:

coolman · Posted: Wed Aug 02, 2006 2:18 pm Post subject:

I have a question here - I haven't tried it though - So would the SYSPUNCH get overlaid and would just have the LOAD cntl for the last table that was unloaded?
________
iphone games

kolusu · Posted: Thu Aug 03, 2006 7:33 am Post subject: