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 [EMAIL PROTECTED] 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 **********************************************************************