List out the buffer pools in db2
No Answer is Posted For this Question
Be the First to Post Answer
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 composite index and how does it differ from a multiple index?
Q3. How will you fetch duplicate values from a DB2 table?
What is the connection string to connect to the DB2 Database ?
What is table space in db2?
how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures
What is the SQL Communications Area and what are some of its key fields?
What is db2 and what is the use of db2 optimizer?
Is db2 free?
What is page size in db2?
What is db2 stogroup?
Are views updateable?