Search

1 to 3 of 3
Sort by

Blog Entry
PBR RPN explained

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


Library Entry
ALTER TABLE ALTER PARTITION ENDING AT (Date sequence)

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