What is a lock?

Answer Posted / s

Lock is a DB2 structure used to ensure data integrity when
applications, utilities, commands are all accessing the
same data.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the contention situations caused by locks?

586


Which is faster delete or truncate?

671


How to resolve deadlock issue

17941


What language is db2 written in?

592


What is meant by dclgen?

618






What are the various isolation levels possible?

643


How do I add a column to a table in db2?

616


How can record locking be achieved in those DB2 versions which do not support it?

619


While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

1814


How to view db2 table structure?

583


What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

702


What is the maximum length of sqlca?

859


What is the use of db2 optimizer?

603


What is data manager?

603


How does a cursor work?

554