How do u achieve record level locking in DB2 versions when record level lockin

How do u achieve record level locking in DB2 versions when
record level locking is not allowed?

Question Posted / guest

2 Answers
8437 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How do u achieve record level locking in DB2 versions when record level locking is not allowed?..

Answer / nahid gorji

By using locksize page and Isolation level CS.

Is This Answer Correct ?

2 Yes

2 No

How do u achieve record level locking in DB2 versions when record level locking is not allowed?..

Answer / s

By storing one row per data page and using page locks.

Is This Answer Correct ?

1 Yes

2 No

Post New Answer

More DB2 Interview Questions

Is it possible to create an Instance in DB2 using DB2 Control Center ?

0 Answers MCN Solutions,

What is load utility in db2?

0 Answers

What is the difference between oracle and db2?

0 Answers

Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?

2 Answers Deloitte,

How would you find out the total number of rows in a db2 table?

0 Answers

What can the SET option of the Repair Utility accomplish?

1 Answers

What is cursor stability?

1 Answers

How to design maps

1 Answers Virtusa,

Describe major components of db2?

0 Answers

Where besides the DB2 catalog is database object information stored by DB2?

1 Answers

What is the difference between a package and a plan?

6 Answers Infosys, L&T, Mphasis,

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

0 Answers Broadridge,

For more DB2 Interview Questions Click Here