The only way to reorganize the database is an UNLOADDB, LOADFORMAT, LOADDB. Nothing else accomplishes this. If your database has had lots of filespace deletions the tree can get severly unbalanced and negatively affect performance.
Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -----Original Message----- From: Farren Minns [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 9:47 AM To: [EMAIL PROTECTED] Subject: Question about database fragmentation Hi All I wonder who can help me with this. Does the database become very fragmented over time? If so, is there any way of telling how much? Also, is the only fix for this to do a dump and reload of the database? If the answer to the final question is yes, how easy are dump/reloads? We recently upgraded from TSM 3.7.3.8 to 4.2.2.12 and had to run an auditdb first (which completed without any problems). Many thanks in advance All the best Farren Minns - TSM and Solaris System Admin - John Wiley and Sons Ltd Our Chichester based offices have amalgamated and relocated to a new address John Wiley & Sons Ltd The Atrium Southern Gate Chichester West Sussex PO19 8SQ Main phone and fax numbers remain the same: Phone +44 (0)1243 779777 Fax +44 (0)1243 775878 Direct dial numbers are unchanged Address, phone and fax nos. for all other Wiley UK locations are unchanged **************************************************************************** **
