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 |
what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?
3 Answers Cap Gemini, Tech Mahindra,
1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).
could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..
if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records
What happens to a cursor after a commit?
Name some fields from SQLCA.
What are packages in db2?
What is a LIKE table and how is it created?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is CHECK PENDING ?
What is a predicate?
How to execute stored procedures?