What is DYNSLT keyword? How do you perform selection using DYNSLT
What is ibm db2 used for?
What else is there in the PLAN apart from the access path?
What is difference between *omit and *nopass?
Why do we bind in db2?
What are leaf pages?
How many databases are there?
how to resolve -811
What is db2 bind process?
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
Define buffer pool.
Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?
What is meant by repeatable read?