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;