In the past, it was up to the user to organize not only the archiving process, but also ensure proper coding of SQL to include or exclude the archive data. This article provides an overview of the new transparent archive capabilities introduced by DB2 11 for z/OS.
SQL is way more than a data access language. Join author and internationally-recongised DB2 consultant Dan Luksetich for this informative and entertaining presentation on the power of SQL.
Cutting SAP Down To (a Manageable) Size
The DBA wouldn’t touch it as there are 83,000 tables in SAP. He was busy with other applications, and he had no time in dealing with a big package that was a mess.
Today volunteer Eddy Coppens of SuadaSoft, talks about his experience of migrating DB2 for LUW, while at the same time changing the collating sequence, resulting in a complex migration project.
In DB2 9.5 for Linux, UNIX and Windows the Workload Management Feature (WLM) was introduced. Besides the obvious capability of managing workloads it added a whole bunch of new monitoring possibilities. These new options provide great ability to focus database monitoring on the really important point