Interested to Buy Any Domain ? << Click Here >> for more details...
How many buffer pools are available in db2?
- 2 Answers
- 7176 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
You can define:
50 4KB BP0-BP49
10 8KB BP8K0-BP8K9
10 16KB BP16K0-BP16K9
10 32KB BP32K0-BP32K9
The number of buffer pools you define is specific to the
DB2 sysbsystem and depends on the DB2 workload. If you dont
have enough real memory to support your bufferpools,
performance will affected severely because of paging.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
What is runstats db2?
What types of tables are there in the db2 database?
how to u check the query is executing or not ?where will u check for sqlcode ?
How can you compare table column after update and before update?
In terms of DB2 indexing, what is the root page?
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
What is a page?
what is the difference between where clause and having clause
Which components manage deadlocks in db2?
What is an instance in db2?
Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?
if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)
COBOL 
