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;