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
PBR RPN explained. Haakon Roberts, DB2 for z/OS Development Introduction. DB2 tables continue to grow in size and these days it is not unusual to encounter tables containing tens of billions of rows. Consequently, DB2 for z/OS must continue to evolve to ensure such large amounts of data...
Given a table partitioned by ascending date with a highest Limit Key = 'MAXVALUE' create alter statements ALTER TABLE [a.b] ALTER PARTITION [n] ENDING AT ('yyyy-mm-dd'); to bring table/partition limit keys up to the most recent possible period. * Statements sequenced in descending order by ...