What are the disadvantages of PAGE level lock?
Answers were Sorted based on User's Feedback
Answer / s
Less concurrency. Lock contention occurs when an
application program is trying to acquire a lock that is
already held by another program.
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / thomas john
high resource utilization when large updates are to be done
Is This Answer Correct ? | 2 Yes | 2 No |
List out the three types of page locks that can be held.
What is runstats db2?
wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?
Where would you find information about the type of database authority held by the user?
What kind of database is db2?
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
Name the lockable units in DB2?
On which levels locks can be applied?
What is the purpose of the QUIESE Utility?
How does db2 sample database connect?
What do you do to keep the cursor from closing after a commit?
how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none