Database backup performan

Elapsed   DB SIZE   USED    TAPE    DISK   PROCESSOR  OS/390   TSM Ver
  time

1 Hour    11.7G     75%   3494/3590  RVA    9672-R14   2.10     4.1.2    Hour
41 Min     9.3G     54%   3494/3590  RVA    9672-R52   2.10     4.1.2    Hour

Sam Sheppard
San Diego Data Processing Corp.

-----------------------------------------------------------------------`
---------------------------- Top of message ----------------------------
---------------------------- Top of message ----------------------------
>>--> 06-27-01  06:50  ..NETMAIL     ()     Database backup performan
>>--> 06-27-01  06:50  ..NETMAIL     ()     Database backup performan
Date: Wed, 27 Jun 2001 09:37:11 -0400
From: "Zoltan Forray/AC/VCU" <zforray AT VCU DOT EDU>
Subject: Database backup performance
To: ADSM-L AT VM.MARIST DOT EDU
_________________________________Top_of_Message_________________________________

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 that much DB since my meager DB takes
sooooo long ? Note, there is no "operator delay" since it goes to a 3494
ATL, using 3490E drives. I was thinking about moving it to 3590 MAGSTAR but
wasn't sure if it would make much of a difference since the only real
change would be reduction/elimination of tape mounts (currently uses
9-cartridges). Since it is a robot, this would save a few minutes at most.

I have tried increasing the BUFPOOL value (from 32MB to 80MB) with little
noticable improvement. I still haven't reached/sustained the illusive 98%
Cache Utilization !

Since the ADSM address space working set size has often exceed 110MB, I was
wondering what was reasonable (or expected) for thise size DB. How much
further should I increase the BUFPOOL value ?

===========================
Zoltan Forray
Virginia Commonwealth University
University Computing Center
e-mail: zforray AT vcu DOT edu
voice: 804-828-4807

-----------------------------------------------------------------------`
=========================================================================