What is bind package and plan in db2?
No Answer is Posted For this Question
Be the First to Post Answer
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
What is lock escalation?
What is the role of data manager in the db2 database?
What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.
what is difference between random and sequence file access
How do you select a row using indexes in db2?
Explain db2.
Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is a result table?
Why db2 is called db2?
How would one remove old reorg information from the DB2 catalog?