How many Buffer pools are there in DB2 and what are they ?
There are 4 Buffer pools. They are BP0,BP1,BP2 and BP32.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
Explain what are componentbuffer and databuffer? 17.11.08
Component Buffer: Component Buffer contains all the Data of active component Data Buffer: Data Buffer contains Data other then the Data in the Component Buf...Explain what are componentbuffer and databuffer? 17.11.08
Component Buffer: Component Buffer contains all the Data of active component Data Buffer: Data Buffer contains Data other then the Data in the Component Buf...Describe TCP flow control ? 21.08.08
The receiver will have buffers in order to collect the frames sent by sender. the buffer should not get over loaded. if the buffer becomes full, the receiver se...Tell me few peoplecode functions you worked with? 12.08.08
Component Buffer consists of rows of buffer fields that hold data for the reocrds associated with the page including primary scrolls, derived work records etc....Tell me about component Buffer? 12.08.08
When you open any page in a component, the system retrieves all of the data records for the entire component and stores them in one set of record buffers, organ...How many buffer pools are available in db2 ? 21.03.08
Ten 32k size buffer pools and fifty 4k size buffer pools (bp0 to bp49)default buffer pools are bp0,bp1,bp2 & bp32...How many buffer pools are there in DB2 ? 07.03.08
There are four buffer pools: BP0, BP1, BP2, and BP32....What is a buffer pool ? 07.03.08
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...How would you go about increasing the buffer cache hit ratio? 06.08.06
Use the buffer cache advisory over a given workload and then query the v$db_cache_advice table. If a change was necessary then I would use the alter system set...The functions memcmp( ) and memicmp( ) 12.03.06
#include #include main( ) { char str1[] = "This string contains some characters" ; char str2[] = "this string contains" ; int result ; result = me...