Data Load and Updates



IBM's flagship relational database management system

Data Load and Updates

Postby DB2@NEW » Tue Aug 19, 2008 5:12 am

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
DB2@NEW
 
Posts: 2
Joined: Mon Aug 18, 2008 11:28 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Data Load and Updates

 

Re: Data Load and Updates

Postby dick scherrer » Tue Aug 19, 2008 6:49 am

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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: Data Load and Updates

Postby DB2@NEW » Tue Aug 19, 2008 7:31 pm

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
DB2@NEW
 
Posts: 2
Joined: Mon Aug 18, 2008 11:28 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Data Load and Updates

Postby dick scherrer » Wed Aug 20, 2008 2:39 am

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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post