Jousma, David wrote:

>Hope everyone had a good holiday.  

What holiday? I don't see any holiday! ;-D ;-D ;-D ;-D

>Today we have a roughly 36GB of LOCAL page for each system, that was setup in 
>2006 spread across 4 mod-9's.   Back then we didn't have the amount of memory 
>on the processors that we have now, nor did we have DB2's using data above the 
>bar.   Most of the systems in our sysplex have around 40Gb of memory 
>configured online.   We have many more DB2 V10 instances active now than we 
>did in 2006.   Without doing a lot of math and measurements, I'm leaning 
>towards giving each system between 80 and 100Gb's of local page spread across 
>4 LOCAL page datasets for each system?   We have dynamic PAV's enabled.   That 
>would be 3-4 mod27's each.  I could go with mod-54's, at 2 per system, but not 
>really sure how much the actual number of virtual DASD devices even matters 
>anymore?

I think, you should say WHY are you asking? Performance issue? Response time? 
Batch jobs doing 'query from hell'? Workload issue? Other jobs / subsystems 
grabbing all memory? Anything else? 

Just please define your 'system'. DB2 [sub] system or LPAR system? SysPlex?

For myself, I would go for 4 local page datasets distributed on at least two 
different control units for DASD. Just try to spread your paging out on more 
devices if you can do that. I would increase your number 4 to 8 or more if that 
is possible in your environment.

I'm just begging one or three questions:

What is your DB2 priority in WLM?
Do you have any response time problems?
What is your LPAR / LPARS CPU/Memory limits? This could probably raised and 
thus eliminate your paging problem?

>Just trying to do the right thing.

Probably not. ;-D It is really difficult to try to help you. I think you should 
post your actual problem you're trying to solve.

Groete / Greetings
Elardus Engelbrecht

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Reply via email to