Performance Tuning SQL queries



IBM's flagship relational database management system

Re: DB2 Performance Tuning

Postby jayind » Fri Jul 25, 2008 5:46 pm

Hi Sandhya,

For doing updation we are locking the table in Exclusive mode.


what command did you use to lock the table in exclusive mode? Usually DBAs define the type of locking and to my knowledge WITH HOLD will only lock the record(s) fetched/updated, so please explain the code you have used for exclusive locking?

Regards,
Jayind
jayind
 
Posts: 62
Joined: Wed Apr 23, 2008 1:37 pm
Location: Chennai, India
Has thanked: 0 time
Been thanked: 0 time

Re: Re: DB2 Performance Tuning

 

Re: DB2 Performance Tuning

Postby SANDHYA BUDHI » Fri Jul 17, 2009 12:23 pm

I am planning to write IBM DB2 700 certification Exam. Can you plese help me which book to refer and whether any sample papers are there and mock exams are available in net? I went through the IBM websites and got some basic stuff for preparing this exams.

Thanks for your help.
SANDHYA BUDHI
 
Posts: 19
Joined: Mon Jul 21, 2008 7:52 pm
Has thanked: 0 time
Been thanked: 0 time

Re: DB2 Performance Tuning

Postby henri2398 » Wed Dec 16, 2015 11:41 am

Database recovery is one of the biggest nightmares in this age of Internet, where information are captured and stored for the analytical purposes. And we understand the databases are growing in size day by day. And it is becoming very tough to deliver the quick response.
henri2398
 
Posts: 2
Joined: Tue Oct 27, 2015 1:02 pm
Has thanked: 0 time
Been thanked: 0 time

Previous

Return to DB2

 


  • Related topics
    Replies
    Views
    Last post