What are the levels of isolation available with DB2V4
Answers were Sorted based on User's Feedback
Answer / nag(igate)
CS Cursor Stability
RS Read Stability
RR Repeatable Read
UR Uncomitted Read
NC no commit-similar to UR
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / s
CS Cursor Stability
RS Read Stability
RR Repeatable Read
UR Uncomitted Read
| Is This Answer Correct ? | 0 Yes | 1 No |
wht is d/f between union and joins ?
How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).
How to resolve -504 sql code in DB2?
How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?
In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?
What is the latest version of ibm db2?
What is EXPLAIN?
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)
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What is lock escalation in db2?
What is deadlock?
What is UNION,UNION ALL?