Posts
83
Comments
600
Trackbacks
40
January 2004 Entries
Customers! Not to mention IT Staff!

posted @ Friday, January 30, 2004 2:18 PM | Feedback (1)
Calculate the most effecient Storage size based on the catalog

The Following code is used to identify reccomended allocations, whether it be in Cylinders or tracks, and how much to allocate for a tablespace.

 

SELECT           NAME                                                         
              ,  NACTIVE*PGSIZE                             AS KILOBYTES      
              ,  PGSIZE                                     AS PAGE_SIZE      
              ,  NACTIVE                                    AS PAGES          
              ,  DECIMAL((NACTIVE/12.00),15,2)              AS TRACKS         
              ,  DECIMAL(((NACTIVE/12.00)/15),15,2)         AS CYLINDERS      
              ,  CASE                                                         
                   WHEN DECIMAL(((NACTIVE/12.00)/15),15,2) > 1 THEN           
                        'CYLINDERS'                            ELSE           
                        'TRACKS   '                                           
                   END                                      AS RECMNED_ALLOC  
              ,  CASE                                                         
                   WHEN INTEGER(NACTIVE/12.00) <> NACTIVE/12.00 THEN          
                       (INTEGER(NACTIVE/12)+1)*48               ELSE          
                        INTEGER(NACTIVE/12)   *48                             
                   END                                      AS FULL_TRACK_BYTES
              ,  CASE                                                         
                   WHEN INTEGER(((NACTIVE/12.00)/15.00)) <>                   
                                 (NACTIVE/12.00)/15.00          THEN          
                (INTEGER((NACTIVE/12.00)/15.00)+1)*720          ELSE          
                 INTEGER((NACTIVE/12.00)/15.00)   *720                        
                   END                                      AS FULL_CYLDR_BYTES
      FROM       SYSIBM.SYSTABLESPACE                                         
     WHERE       CREATOR = 'BX89ACDA'                                         
       AND       DBNAME = 'SLD000DA'                                          
  ORDER BY 1;                                                                 
             

posted @ Friday, January 30, 2004 2:01 PM | Feedback (3)