Re: Database backup performance

2001-07-06 Thread Zoltan Forray/AC/VCU
PROTECTED] voice: 804-828-4807 Petr Prerost cc: Sent by: Subject: Re: Database backup performance "ADSM: Dist Stor Manager" <[EM

Antwort: Re: Database backup performance

2001-07-06 Thread Gerhard Wolkerstorfer
kerstorfer [EMAIL PROTECTED] am 05.07.2001 18:14:35 Bitte antworten an [EMAIL PROTECTED] An: [EMAIL PROTECTED] Kopie: (Blindkopie: Gerhard Wolkerstorfer/DEBIS/EDVG/AT) Thema:Re: Database backup performance *1* I have increased it to 9 to see what happens. This could help in a

Re: Database backup performance

2001-07-05 Thread Zoltan Forray/AC/VCU
Petr Prerost cc: Sent by: Subject: Re: Database backup performance "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]

Re: Database backup performance

2001-07-04 Thread Petr Prerost
Hi Zoltan , what is your tapeiobufs setting ? Can you see better tape throughput with migration processing ? regards Petr - Puvodnm zprava - Od: "Zoltan Forray/AC/VCU" <[EMAIL PROTECTED]> Komu: <[EMAIL PROTECTED]> Odeslano: 2. cervence 2001 15:47 Pr

Re: Database backup performance

2001-07-03 Thread John Naylor
Zoltan, Your cache hit percentage is way too low, but that is not going to impact on your database backup performance anyway. I am not sure that you need to increase the number of bufferpool pages. My database is larger and has a smaller bufferpool with a better cache hit %. If you are happy

Database backup performance

2001-07-02 Thread Zoltan Forray/AC/VCU
I want to thank everyone who responded to my question(s). It seems that *EVERYONE* goes faster than us, some by a big margin. I just finished upgrading the OS/390 server from ADSM 3.1.2.50 to TSM 4.1.3. I was hoping the DB backup would be faster. Unfortunately, there is "no joy in Mudville". T

Re: Database backup performance

2001-06-28 Thread Richard L. Rhodes
Our db backup stats are below. We do 2 db backups per day, one to disk and one to tape. all pages: 11,266,048 (44g) used pages: 8,387,060 (34g) disk bkup: 60min - local ESS disk tape bkup: 60min - 3590 drives processor: 6k-s7a

Re: Database backup performance

2001-06-27 Thread Paul Zarnowski
We back up 19,591,179 pages in 4 hours. This is an 83GB database, 91% utilized. Server is an RS/6000 M80. Backup media is DLT 7000 tape. Translates to 5.3MB/s by my calculation. Our incremental backups usually take 15-30 minutes.

Re: Database backup performance

2001-06-27 Thread Bill Colwell
Zoltan, I have a very large os/390 server. The last full dbb went at a rate of 3.3 million pages/hr, almost 5 times fater than yours. Since v1 r1 of adsm I haven't found any tricks to speed this up except to change hardware. My current system is cpu: 9672-ra6 tape: 9840 running 3590 emulation

Re: Database backup performance

2001-06-27 Thread John Naylor
Zoltan, Sorry I forgot to mention, as you are OS390 it will be worth looking at the RMF statistics for the period of the database backup. This should show which resource is causing your backup to run so slow. It could be cpu or possibly disk contention, John

Re: Database backup performance

2001-06-27 Thread John Naylor
Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc:(bcc: John Naylor/HAV/SSEG) Subject: Re: Database backup performance I guess I should have clarified that the server is on OS/390, not *NIX !! Thanks for all the responses on how long it takes. Now, how about ways to im

Re: Database backup performance

2001-06-27 Thread Zoltan Forray/AC/VCU
I guess I should have clarified that the server is on OS/390, not *NIX !! Thanks for all the responses on how long it takes. Now, how about ways to improve the speed ? I am trying a backup to 3590 drives, to see how much of a difference it makes. So far, there does seem to be a speed difference.

Re: Database backup performance

2001-06-27 Thread Rainer Wolf
=...) > > -Original Message- > > From: Zoltan Forray/AC/VCU [SMTP:[EMAIL PROTECTED]] > > Sent: Wednesday, June 27, 2001 3:37 PM > > To: [EMAIL PROTECTED] > > Subject: Database backup performance > > > > Any suggestions on how to improve DB backup performance ?

Re: Database backup performance

2001-06-27 Thread Richard Sims
Doing the math on the quoted database backup sizes and times, plus my own, shows customers experiencing a db backup data rate of 3 - 4 MB/sec. That is well below the capabilities of the disk and tape technology in use, and points to the often-criticized TSM database system being the drag on perfo

Re: Database backup performance

2001-06-27 Thread David Longo
Our DB is 13.5GB, 65% utilized. Full backup in 30 minutes to IBM 3575 library with C-XL drives. TSM 3.7.4.0 on AIX 4.3.3, IBM RS6000 F50. David Longo >>> [EMAIL PROTECTED] 06/27/01 09:37AM >>> Any suggestions on how to improve DB backup performance ? Doing a FULL DB backup of our 15GB ADSM (y

Re: Database backup performance

2001-06-27 Thread Rushforth, Tim
Our DB is 21 GB, 85% Utilized. Backup time is 34 minutes. Running TSM 3.7.4 on Windows 2000. Backup to DLT 7000 tape. This translates to about 9 MB/sec. Tim Rushforth City of Winnipeg

Re: Database backup performance

2001-06-27 Thread Richard Cowen
>Doing a FULL DB backup of our 15GB ADSM (yes, not TSM YET. Hoping to convert to 4.1.3 RSN !!) server, sometimes takes 4-hours. >Since I read a previous message about someone having a 52GB DB, I was wondering how long it takes to backup that much DB since my meager DB takes so long ? About 3

Re: Database backup performance

2001-06-27 Thread Lambelet,Rene,VEVEY,FC-SIL/INF.
- > From: Zoltan Forray/AC/VCU [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, June 27, 2001 3:37 PM > To: [EMAIL PROTECTED] > Subject: Database backup performance > > Any suggestions on how to improve DB backup performance ? > > Doing a FULL DB backup of our 15GB

Database backup performance

2001-06-27 Thread Zoltan Forray/AC/VCU
Any suggestions on how to improve DB backup performance ? Doing a FULL DB backup of our 15GB ADSM (yes, not TSM YET. Hoping to convert to 4.1.3 RSN !!) server, sometimes takes 4-hours. Since I read a previous message about someone having a 52GB DB, I was wondering how long it takes to backup tha