What is buffrpool? Where we use it ?

Answer Posted / s

Bufferpools are areas of virtual storage where DB2
temporarily stores the pages of tablespaces and indexes.

Is This Answer Correct ?    12 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sqlca’s maximum length?

645


How to execute stored procedures?

601


What are the various isolation levels possible?

627


What is the use of db2 optimizer?

587


What does runstats do in db2?

584






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 .....

1866


Is db2 a mainframe database?

551


can all users have the privilage to use the sql statement select * (dml)?

615


What is collection in db2 bind?

557


Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

587


What is schema in db2?

555


What is a bind in db2?

570


What is deadlock in db2?

558


What is the maximum No of rows per page?

606


What is cursor stability in db2?

783