Mention the different locking levels that are available in db2.
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
Discuss about db2 bind?
List out the data types available.
Define sqlca.
Explain packages.
Mention the definition of cobol in varchar field.
Explain the function done by data manager?
Define buffer pool.
Outputs of explain are with matchcols = 0. What does this signify?
Explain in detail about buffer manager and its functionalities?
Mention the various locks that are available in db2.
Explain about dbrm.
What does a deadlock mean in DB2?
What is the advantage in De-normalizing tables in DB2?