Mention and explain the contention situations caused by locks?
What is db2? Explain.
What is bind and rebind in db2?
What is the difference between IN subselects and EXISTS subselect?
What is DCLGEN ?
What is the physical storage length of time data type?
How can you split a table in to exactly half?
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??
What is reorg and runstats in db2?
What is Reorg Recovery? when will you run it?
Is db2 a programming language?
What is dbrm? What it contains?
Which isolation level provides highest data integrity?