Interested to Buy Any Domain ? << Click Here >> for more details...
How many buffer pools are available in db2?
- 2 Answers
- 7319 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 |
When is the authorization check on DB2 objects done - at BIND time or run time?
When Can you be sure that a query will return only one row?
What is ibm db2 client?
how to resolve -811
What is the logical entity between plan and Package?
Where to download IBM DB2 Certification Dumps for the below: C2090-311 : IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 C2090-312 : IBM DB2 11 DBA for z/OS C2090-313 : DB2 11 Application Developer for z/OS C2090-317 : DB2 11 System Administrator for z/OS C2090-541 : DB2 9.7 DBA for Linux UNIX and Windows C2090-543 : DB2 9.7 Application Development C2090-544 : DB2 9.7 Advanced DBA for LUW C2090-545 : DB2 9.7 SQL Procedure Developer C2090-546 : DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade C2090-610 : DB2 10.1 Fundamentals C2090-611 : DB2 10.1 DBA for Linux, UNIX, and Windows C2090-612 : DB2 10 DBA for z/OS C2090-614 : DB2 10.1 Advanced DBA for Linux UNIX and Windows C2090-615 : DB2 10.5 Fundamentals for LUW C2090-617 : DB2 10 System Administrator for z/OS C2090-730 : DB2 9 Family Fundamentals C2090-733 : DB2 9 Application Developer C2090-735 : DB2 9.5 SQL Procedure Developer C2090-737 : DB2 9 System Administrator for z/OS Exam
What is copy book?
Define db2 and its databases?
What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?
What is subquery ?
what is the use of commit ? and what is the syntax?
I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?
COBOL 
