MVSFORUMS.com

Vallem · Beginner Joined: 20 Feb 2003 Posts: 4 Topics: 2

Hi,

I want to unload lot of data (around 5 million) using batch JCL.

I don't want to use cobol/db2 program as it is taking lot of time to run. Can i use any DB2 utilities for this?

Thanks

kolusu · Posted: Tue Mar 25, 2003 10:59 am Post subject:

vallem,

check the following link for unloading a db2 table using the db2 utility DSNTIAUL which lets you unload a max of 100 tables at a time.Check the last example given in the link which explains unloading multiple tables.

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

Hope this helps...

cheers

kolusu

Vallem · Beginner Joined: 20 Feb 2003 Posts: 4 Topics: 2

Kolusu,

Thanks alot for the quick info.
MVS Forums is helping me a lot!!

Best wishes,
Vallem

dalaly · Beginner Joined: 29 Nov 2002 Posts: 56 Topics: 23

Vallem,

We are glad that we can help out. If you find this board usefull please pass the word around to your friends and co-workers.

Best regards,
-Dalaly and Kolusu