January 2004 Blog Posts

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