Interested to Buy Any Domain ? << Click Here >> for more details...
How do u achieve record level locking in DB2 versions when
record level locking is not allowed?
- 2 Answers
- 8468 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 are the three types of page locks that can be held?
In which column of which DB2 catalog would you find the length of the rows for all tables?
What do you mean by cursor?
i have a db2 variable how do u declare tht into working storage section ?
what is the name of the default db2 catalog database?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
Can a array declared with an index be displayed(readable format) in spool?
What are data types?
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)
When is the skeleton cursor table created?
query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop
What is catalog database in db2?
COBOL 
