Search

Library Entry

Tablespace Capacity Check (updated)

Calculates how full and how close to maximum capacity a partition is. This is for DB2/z. Updated to use NPAGES instead of NACTIVE.

TSMAX.txt

Library Entry

RTS Indexspace Capacity Report

SELECT 'DB3G' AS "SSID" , SUBSTR(TSDBNAME CONCAT '.' CONCAT IXNAME CONCAT '.' CONCAT CHAR(PART),1,25) AS "DB.IXNAME.PART" , DEC...

Library Entry

RTS Indexspace Capacity Report

SELECT 'DB3G' AS "SSID" , SUBSTR(TSDBNAME CONCAT '.' CONCAT IXNAME CONCAT '.' CONCAT CHAR(PART),1,25) AS "DB.IXNAME.PART" ...