MVSFORUMS.com

Jai · Beginner Joined: 06 Jun 2003 Posts: 57 Topics: 20

Hi Team,

Please let me know how to use BMC Load.

I have to upload the data through BMC Load.
I have never used it.

Please let me know.

Thanks in advance.
_________________
Have a Great Day.
Thanks & Regards,
Jai

kolusu · Posted: Sat Sep 20, 2003 5:16 pm Post subject:

Jai,

MY shop does not have BMC. So I cannot provide working examples of it. But there are IBM utilities both for unloading as well as loading .

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

Check this link for LOAD UTILITY from IBM

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNUGH11/2.12?DT=20010719144747

Check this link for LOAD utility examples

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNUGH11/2.12.5?SHELF=&DT=20010719144747

To decrease the run time of loading job please sort the file to be loaded on the primary key sequence.

Hope this helps...

cheers

kolusu