IBM Mainframe Forum

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

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.

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.