I’d like to draw some parallels and highlight important differences between the architecture of the mainframe and the architecture of a data lake. Hopefully, this will help us understand where and how performance gains can be made in one environment versus the other. Mainframe Architecture...
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 ...
This presentation is about the description of the IO infrastructure; its performance and tuning in a Mainframe environment from a DB2 DBA point of view.
EU07B06.flv