Page 2 of 2

Re: DB2 Performance Tuning

PostPosted: Fri Jul 25, 2008 5:46 pm
by jayind
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

Re: DB2 Performance Tuning

PostPosted: Fri Jul 17, 2009 12:23 pm
by SANDHYA BUDHI
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.

Re: DB2 Performance Tuning

PostPosted: Wed Dec 16, 2015 11:41 am
by henri2398
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.