x002548's Blog

Not Just a Number - Brett Kaiser
posts - 89, comments - 586, trackbacks - 39

January 2004 Blog Posts

Customers! Not to mention IT Staff!

posted @ Friday, January 30, 2004 2:18 PM | Feedback (1) | Filed Under [ Disconnected Ramblings ]

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          ...

posted @ Friday, January 30, 2004 2:01 PM | Feedback (3) | Filed Under [ DB2 ]

Powered by:
Powered By Subtext Powered By ASP.NET