WLM question

Tina Hilton

WLM question
We are changing WLM to goal mode from compatibility mode. Our OS/390 guy
thought they were told in class something about making sure the DB2 buffers
were big enough before changing to goal mode. I can't find anything in the
DB2 books about WLM requiring bigger bufferpools or any other buffers. Does
this sound familiar to anyone? We are running DB2 V5.1 on OS/390 2.6.

Thanks.

Tina Hilton
Database Analyst
Bertelsmann mediaSystems
(317) 542-6891
[login to unmask email]



Eric Pearson

Re: WLM question
(in response to Tina Hilton)
I know a bit about WLM and a bit about bufferpools.
The only way I can see any connection is that WLM goal mode
might enable more Stored Procedure address spaces which
might open things up for more workload.

However, buffer pool requirements are driven entirely
by SQL (and certain utility) requirements. If the SQL
and utility workload does not change, the bufferpool
requirements should not change.

Probably what they heard was something more generic
like 'DB2 likes lots of buffers. If it does not have
them your WLM activities will not accomplish much since
eveyone will still be waiting for I/O.'

regards,

eric pearson
NS ITO Database Support


-----Original Message-----
From: Hilton, Tina, BmS - NMI -PM [mailto:[login to unmask email]
Sent: Friday, December 22, 2000 9:50 AM
To: [login to unmask email]
Subject: WLM question


We are changing WLM to goal mode from compatibility mode. Our OS/390 guy
thought they were told in class something about making sure the DB2 buffers
were big enough before changing to goal mode. I can't find anything in the
DB2 books about WLM requiring bigger bufferpools or any other buffers. Does
this sound familiar to anyone? We are running DB2 V5.1 on OS/390 2.6.

Thanks.

Tina Hilton
Database Analyst
Bertelsmann mediaSystems
(317) 542-6891
[login to unmask email]