, January 25, 2002 1:20 PM
To: [EMAIL PROTECTED]
Subject: Re: Database Specs
I agree, and I will do that... and thanks for the info... but why does my
performance and tuning manual say not to span more than 12 volumes?
-Original Message-
From: William F. Colwell [mailto:[EMAIL PROTECTED
: Database Specs
Joe - the number of volumes isn't the problem. You need to increase the bufpoolsize
in the server
dsm.opt file. Here is a 'q db f=d' from my system. The bufpoolsize parameter becomes
the
'buffer pool pages' value in the q db
Thanks...
-Original Message-
From: Malbrough, Demetrius [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 25, 2002 2:30 PM
To: [EMAIL PROTECTED]
Subject: Re: Database Specs
If you are going to increase the BUFPoolsize parameter make sure you do it
based on
the amount of System Memory
(Use the RESET
BUFP command to reset the cache hit statistics.)'
Regards,
Demetrius Malbrough
UNIX/TSM Administrator
-Original Message-
From: William F. Colwell [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 25, 2002 1:13 PM
To: [EMAIL PROTECTED]
Subject: Re: Database Specs
Joe - the number of volumes isn't the problem. You need to increase the bufpoolsize
in the server
dsm.opt file. Here is a 'q db f=d' from my system. The bufpoolsize parameter becomes
the
'buffer pool pages' value in the q db.
Bill Colwell
- - -
tsm: NEW_ADSM_SERVER_ON_PORT_1600>q db f=d
I'm running TSM v 4.1.3 on System\390. My database is 47G and spread across 25
physical volumes (gets a 78% cache hit / not so great).
One of my performance and tuning books recommends not spreading your database over
more than 12 physical volumes. Could anyone explain why? What kind of
per
