Geoff Allen wrote:
>I've currently been trying to find bottlenecks in our database. When
>we do a restore from a rather large filesystem (about 25,000 home
>directories at the top level), our ADSM server thrashes the db disks
>for a long time (20-40 minutes). During this time, the client appears
>
ger" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:(bcc: Tab Trepagnier/Corporation/Laitram/US)
Subject: DB volume layout (was Re: Database sizing question)
"Cook, Dwight E" <[EMAIL PROTECTED]> writes:
> due to the way adsm/tsm internally manages "st
"Cook, Dwight E" <[EMAIL PROTECTED]> writes:
> due to the way adsm/tsm internally manages "stuff" it is best to have one
> logical file/device per physical device.
I've currently been trying to find bottlenecks in our database. When
we do a restore from a rather large filesystem (about 25,000 ho
Thank to all that have responded to my query. Your help is much appreciated.
Peter
-Original Message-
From: Brian Nick [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 23, 2000 5:26 AM
To: [EMAIL PROTECTED]
Subject: Re: Database sizing question
Peter,
Just a bit of info. We are
Wednesday, August 23, 2000 7:35 AM
> To: [EMAIL PROTECTED]
> 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 ?
pace
> with nothing in it.
> Dwight
>
> > --
> > From: Coles, Peter[SMTP:[EMAIL PROTECTED]]
> > Reply To: ADSM: Dist Stor Manager
> > Sent: Tuesday, August 22, 2000 3:19 PM
> > To: [EMAIL PROTECTED]
> > Subject: Database sizing question
ED]cc:
> Subject: Database sizing question
Sent by:
"ADSM: Dist
Stor Manager"
<[EMAIL PROTECTED]
RIST.EDU>
08/22/2
Just some more statistics to ponder.
ADSM v3.1.2.55
AIX 4.2.1
tsm: ADSM>select sum(num_files),stgpool_name from occupancy group by
stgpool_name
Unnamed[1] STGPOOL_NAME
--- --
22254868 ARCHTAPE archives on tape
40030448 BACKUP35
L PROTECTED]]
> Reply To: ADSM: Dist Stor Manager
> Sent: Tuesday, August 22, 2000 3:19 PM
> To: [EMAIL PROTECTED]
> 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
Peter,
The data base size is not only dependent on the number of files on de servers
(clients) and the retention period but also on the number of versions you keep.
Our data base (on OS/390) is 11.2 GigaBytes in size. Our client contain over 4
million files, retention period is (for most) 365 day
s CO 80949-1313
(719) 531-5926
Fax: (719) 260-5991
Email: [EMAIL PROTECTED]
www.storsol.com
www.storserver.com
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Coles, Peter
Sent: Tuesday, August 22, 2000 2:20 PM
To: [EMAIL PROTECTED]
Subject: Datab
hem in the same directory,
i.e., on the same physical disk. That's bad. So I do it by hand.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Coles, Peter
Sent: Tuesday, August 22, 2000 4:20 PM
To: [EMAIL PROTECTED]
Subject: Database sizing question
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. Thi
13 matches
Mail list logo
