How do u achieve record level locking in DB2 versions when
record level locking is not allowed?
- 2 Answers
- 7598 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nahid gorji
By using locksize page and Isolation level CS.
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / s
By storing one row per data page and using page locks.
| Is This Answer Correct ? | 1 Yes | 2 No |
What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?
How will you delete duplicate records from a table?
suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?
What do you need to do before you do EXPLAIN?
How can you display the current date & current time ?
1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.
Explain about dbrm.
What is an access path?
why we create view.
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
What is difference between alias and synonym in db2?
How do I import a csv file into db2?
COBOL 
