ADSM-L

DataBase "Position, Position, Position" and AIX SSA Disk on a 346 6

2002-11-08 10:42:41
Subject: DataBase "Position, Position, Position" and AIX SSA Disk on a 346 6
From: "Talafous, John G." <Talafous AT TIMKEN DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 8 Nov 2002 10:32:26 -0500
Greetings *SMers,
  There has been discussion regarding TSM performance and a common theme is
DataBase layout. I would like to hear your opinions on the best layout for
our database. We are TSM 4.2.1.9 on AIX 5.1, a 3466-C00 with three full
drawers of SSA disks. We have a 3494 library with 3590E1A drives. Our cache
hit percentage is most often greater than 99%. Occasionally though, it will
drop into the 96-98% range. BufPoolSize: 126,976K. We have 3GB of memory on
the RS6000 H50. Our database is currently 117GB and is 85% utilized
(25,625,266 used pages!). Our DB backups take hours.
  With all this in mind, are there any experts that could suggest an
'optimum' DB layout?

John G. Talafous              IS Technical Principal
The Timken Company            Global Software Support
P.O. Box 6927                 Data Management
1835 Dueber Ave. S.W.         Phone: (330)-471-3390
Canton, Ohio USA  44706-0927  Fax  : (330)-471-4034
talafous AT timken DOT com           http://www.timken.com


**********************************************************************
This message and any attachments are intended for the
individual or entity named above. If you are not the intended
recipient, please do not forward, copy, print, use or disclose this
communication to others; also please notify the sender by
replying to this message, and then delete it from your system.

The Timken Company
**********************************************************************

<Prev in Thread] Current Thread [Next in Thread>
  • DataBase "Position, Position, Position" and AIX SSA Disk on a 346 6, Talafous, John G. <=