We are in the same state, my db is 180 Gb, 87% utilized. At a high level, one of the consultants we talked to suggested loading the database onto 2 different servers and then deleting different storage pools and nodes from each one, essentially putting part of the database on each server. We are at TSM 5.3 so would be going to the same OS and were going to keep the same TSM version. One of the obstacles I have with this method is almost all of my clients belong to the same copypool so I need to separate them before we can even attempt this. Once everyone was backing up to their new server, we could export the remaining nodedata that was backed up since the database backup was done. Good luck with your split, I will be interested to hear what method you use and how it works for you.
-----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Daad Ali Sent: Monday, July 09, 2007 1:54 PM To: [email protected] Subject: [ADSM-L] Splitting the TSM Database into three Hi All, We are discussing a way of splitting our TSM database. It is become very big and slow. We want to split it into 2 or 3(one will be the manager of the other two) I don't know how to split it so I am looking for a procedure/steps on how to do that. Also, after splitting the database, can I assign different platforms (AIX/Windows) to the two DBs. My db is about 200 GBs now and the server is version 5.2.6.0 >q db f=d Available Space (MB): 180,000 Assigned Capacity (MB): 180,000 Maximum Extension (MB): 0 Maximum Reduction (MB): 14,824 Page Size (bytes): 4,096 Total Usable Pages: 46,080,000 Used Pages: 34,660,427 Pct Util: 75.2 Max. Pct Util: 75.4 Physical Volumes: 9 Buffer Pool Pages: 272,144 Total Buffer Requests: 293,217,483 Cache Hit Pct.: 99.05 Cache Wait Pct.: 0.00 Backup in Progress?: No Type of Backup In Progress: Incrementals Since Last Full: 0 Changed Since Last Backup (MB): 5,818.36 Percentage Changed: 4.30 Last Complete Backup Date/Time: 07/09/07 01:15:44 ============== tsm: BRDTSM01>q log f=d Available Space (MB): 12,000 Assigned Capacity (MB): 10,020 Maximum Extension (MB): 1,980 Maximum Reduction (MB): 10,000 Page Size (bytes): 4,096 Total Usable Pages: 2,564,608 Used Pages: 4,369 Pct Util: 0.2 Max. Pct Util: 68.3 Physical Volumes: 6 Log Pool Pages: 128 Log Pool Pct. Util: 8.54 Log Pool Pct. Wait: 0.00 Cumulative Consumption (MB): 4,768,612.50 Consumption Reset Date/Time: 12/07/05 14:37:35 Thanks as always. Daad --------------------------------- Be smarter than spam. See how smart SpamGuard is at giving junk email the boot with the All-new Yahoo! Mail
