ADSM-L

Re: Database sizing question

2000-08-23 09:15:39
Subject: Re: Database sizing question
From: "Cook, Dwight E" <cookde AT BP DOT COM>
Date: Wed, 23 Aug 2000 08:15:49 -0500
due to the way adsm/tsm internally manages "stuff" it is best to have one
logical file/device per physical device.
if you want to get really anal you can start splitting things (db, log, &
data files) across adaptors, making db & log files the first device out on
an ssa loop, then put the db & log mirror files out on a different adapter
(on maybe a different buss within the processor)
ok, I'll shut up now ;-)
Dwight

> ----------
> From:         Jason Morgan -
> Finance[SMTP:Jason.Morgan AT BLAENAU-GWENT.GOV DOT UK]
> Reply To:     ADSM: Dist Stor Manager
> Sent:         Wednesday, August 23, 2000 7:35 AM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      Re: Database sizing question
> Sensitivity:  Private
>
> 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>