How many buffer pools are there in DB2?

Answer Posted / sunil1405

4 Buffer pools. BP0,BP1,BP2

Is This Answer Correct ?    5 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is db2 command?

574


What is the usage of open cursor command?

590


What are the full forms of spufi and dclgen and why are they used?

642


How connect db2 database to datastage?

751


What is db2 stogroup?

664






Are views updateable?

633


Can you tell me how can you find out the # of rows updated after an update statement?

602


What is isolation level in db2?

571


How does db2 sample database connect?

559


what is the sqlcode -501

11230


How do I create a view in db2?

589


How do I add a column to an existing table in db2?

578


How can you do the explain of a dynamic sql statement?

626


what is diffrence b/w file-aid tool and file-aid utility???

4156


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

613