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
8454 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

Explain package in db2 and its advantages?

0 Answers

i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?

4 Answers

In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.

5 Answers CTS,

what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)

4 Answers IBM,

What is lock contention?

1 Answers

how to identify the pseudo conversation by seeing the program

2 Answers DELL,

Usually, which is more important for DB2 system performance - CPU processing or I/O access?

1 Answers

What is referential integrity?

5 Answers

what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??

4 Answers Xansa,

How to resolve -818 sql code in DB2?

2 Answers Cap Gemini,

Describe the elements of the SELECT query syntax?

3 Answers

what is plan? is plan executable or package?

4 Answers

For more DB2 Interview Questions Click Here