Explain in detail about buffer manager and its functionalities?
a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.
What is query_cache_limit?
Where is the access path logic created by the DB2 Optimizer stored?
What is a SELECT statement?
How to get Top 10 Salaries from a Table
What does the REORG Utility do?
How can record locking be achieved in those DB2 versions which do not support it?
Explain the contention situations caused by locks?
Which command is used to remove all rows from a table?
What is meant by AUTO COMMIT?
How does cobol compile db2 program?
What is a buffer in memory?