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:fminns AT WILEY.CO DOT UK]
Sent: Wednesday, October 02, 2002 9:47 AM
To: ADSM-L AT VM.MARIST DOT EDU
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
****************************************************************************
**