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