Page 1 of 1

Data Load and Updates

PostPosted: Tue Aug 19, 2008 5:12 am
by DB2@NEW
Dear experts,

Hello,

I have to Load 5 million records from one table to another.
Its gonna be a Pure Insert

Another instance , same amount of records is gonna be a Insert or Update.
we will be using the latest DB2 . can anyone send me sample codes as well

Please suggest as how to go about doing this and how to ensure the performance is not affected.

regards,
Terry Smith

Re: Data Load and Updates

PostPosted: Tue Aug 19, 2008 6:49 am
by dick scherrer
Hello and welcome to the forums,

You need to talk with the dba to learn how this is done on your system.

For high volume, it will be faster to unload the data and re-load it rather than trying to do a SELECT . . . INTO.

If you have a process that must issue 5 million individual insert or update statements, it will impact performance.

Re: Data Load and Updates

PostPosted: Tue Aug 19, 2008 7:31 pm
by DB2@NEW
Thank you very much for the suggestion. would be very helpful if you could provide sample code

well we will be using the DB2 Load utility ...Can you furnish with any sample commands to do this.

For Updates think we have to USE DB2 Import utility...

Regards,
Terry

Re: Data Load and Updates

PostPosted: Wed Aug 20, 2008 2:39 am
by dick scherrer
Hello,

You should talk with your dba to learn the proper way to do this on your system. There should already be standard sets of jcl as well as guidelines on how to configure the utility jobs.

This is the Utility Manual for DB2 V8:
http://publibz.boulder.ibm.com/cgi-bin/ ... ugj10/2.30?

It has samples for both LOAD and UNLOAD and many other functions.