Answer Posted / manisha shukla
A buffer pool is main storage that is reserved to satisfy
the buffering requirements for one or more tablespaces or
indexes, and is made up of either 4K or 32K pages.
There are four buffer pools: BP0, BP1, BP2, and BP32.
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
Explain the contents that are a part of dclgen.
What is check constraint. Explain with example.
What is the maximum size of a char data type in db2?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
Explain about mirror activator disk mirroring?
What is the difference between drop table and delete table?
What's The Error Code For Unique Index Voilation?
What is a bind card?
What is package in db2 mainframe?
What is the information associated with sysibm.syslinks table?
What are the contents of a dclmgen?
What is load utility in db2?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is the reason behind not using select * in embedded sql programs?
What does sqlcabc has?