ADSM-L

Re: DB & LOG Volume layout - new

2006-01-24 09:05:53
Subject: Re: DB & LOG Volume layout - new
From: "Allen S. Rout" <asr AT UFL DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 24 Jan 2006 09:05:22 -0500
>> On Mon, 23 Jan 2006 17:16:06 -0500, Paul Zarnowski <psz1 AT CORNELL DOT EDU> 
>> said:

> At 06:56 AM 1/23/2006, Dirk Kastens wrote:
>> Paul Zarnowski schrieb:
>>> TSM does not do round-robin allocation
>>> of DB pages across it's volumes.  It fills up one, then works on the
>>> next.

>> Are you shure? I think this only applies to log volumes.

> That's the way it was explained to me years ago.  Easy enough to
> test, I guess.  Start a new server with a few empty db volumes, and
> watch the I/O activity.


Paul's got it.  Even with a non-new server, take a look at Q DBVOL
f=d.  It'll be quite unusual to have more than one volume  partially
full.  If TSM assigned pages round-robin, then the usual case would be
(fairly) even byte occupancy per volume.

In fact, you can observe just this in DISK volumes in a primary
stgpool; if you build a stgpool out of disparate sizes, the small ones
will get full first.


- Allen S. Rout