ADSM-L

Re: Database sizing question

2000-08-23 08:35:01
Subject: Re: Database sizing question
From: Jason Morgan - Finance <Jason.Morgan AT BLAENAU-GWENT.GOV DOT UK>
Date: Wed, 23 Aug 2000 13:35:03 +0100
Are there any recommended DB filesizes  ? For a 4gig Database would you use
4*1gb on different spindles ? 2*2gb files or 1 4.5gb file ?

> -----Original Message-----
> From: Cook, Dwight E [SMTP:cookde AT BP DOT COM]
> Sent: 23 August 2000 12:40
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      Re: Database sizing question
> Sensitivity:  Private
>
> Ahhhhh  I just use an entire 4.5 GB or 9.2 GB drive for each DB file and
> just add another one once I run low (hit about 85-90%util)
> I've seen cache problems (low hit %) when you have an abundance of space
> with nothing in it.
> Dwight
>
> > ----------
> > From:         Coles, Peter[SMTP:PJCg AT PGE DOT COM]
> > Reply To:     ADSM: Dist Stor Manager
> > Sent:         Tuesday, August 22, 2000 3:19 PM
> > To:   ADSM-L AT VM.MARIST DOT EDU
> > Subject:      Database sizing question
> > Sensitivity:  Private
> >
> > I am in the process of moving from ADSM on an AIX system to TSM on
> OS/390
> > (I
> > know, I know). In calculating the database size in accordance with TSM
> > Implementation Guide (Redbook) for 40 servers with approximately 3.4
> > million
> > files with a 60 day retention requirement I get a db size of ~128 GB.
> This
> > seems a bit much for me. Currently on the AIX side my db size is 3.7 GB.
> >
> > Any ideas....
> > Peter Coles
> > Pacific Gas and Electric Company
> > pjcg AT pge DOT com
> >
<Prev in Thread] Current Thread [Next in Thread>