Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How many buffer pools are available in db2?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is reorg and runstats in db2?

1203


How do I copy a table in db2?

988


How to execute stored procedures?

1109


How can you count the number of rows from a table tab?

1075


How to rename a table in DB2 ?

1074


What is consistency token in db2?

1112


Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1178


What are the contents of dclgen?

1088


Explain packages.

1090


How to run db2 command in windows?

1175


What is the maximum size of a char data type in db2?

994


What is the difference between oracle and db2?

1074


have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1717


What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1137


Can we insert update delete in view?

948