I too will some day in the future need to reorg a TSM database. I am currently working to split our 122GB database into two TSM instances. I will be doing the same as Andy!!!
Andy, Do I understand correctly that you simply pointed clients to the new server and did a full backup and some time later deleted the old node from the old server? Remco, Would you be willing to share your SQL query that reports on DB fragmentation? Thanks to all, 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