asked on

What DB2 bufferpool stategy would you use for OLTP vs OLAP/Data warehouse database?

Dear gurus,

Can I get some opinion, comments on strategy and best practices for defining bufferpools for a Online transaction processing system vs. a data warehouse/OLAP/DSS system?

All comments, links, etc. welcomed.

Thanks

Enyimba

SOLUTION

waynezhu

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Kent Olsen

Hi Enyimba,

Is this a hypothetical question or do you have a real need to do this?

Kent

Enyimba

ASKER

Real reason to do it...you see, I consult variously and I do have a little bit of experience. But I place a high value and respect to the experience that I glean from talking and interacting with seasoned gurus like yourself and many others in primarily IBM DB2 products.

For every good or elementary questions that I may ask, I probably have my own opinion, but always, I mean I always like to vet my opinion against those of people that I consider superior in their knowledge and opinion to my own. I do not have any "complex", I just happen to think that at any time in life "...there are greater and lesser persons than myself". I don't remember where I got the quote from, but I think it is always true for anybody...

So, can I get an answer from you?

Enyimba

SOLUTION

waynezhu

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Kent Olsen

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

waynezhu

I believe kdo and myself had provided enough information the question.