How do u achieve record level locking in DB2 versions when
record level locking is not allowed?
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 |
How do you pull up a query which was previously saved in qmf?
What is null in db2?
What is the syntax of SELECT statement when embedded in a COBOL program?
For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?
What is the database descriptor?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What information can you find in SYSIBM.SYSLINKS table?
What is meant by explain?
what are extents?
Why cursor is used in db2?
WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?