Db2 Tools

 View Only

NEW: CA Log Analyzer Gains I/O Saving Option

By Jakub Hofman posted Mar 31, 2021 05:21 AM

  

We are pleased to announce that we released new Bypass Extract feature in CA Log Analyzer for Db2 for z/OS (PLA) that lets you avoid this unnecessary reading and writing. Thus, you save I/O operations, CPU, and Elapsed Time.

PLA uses the extract file to store filtered data from the Db2 log. The extract file is a pair of datasets. You can use permanent datasets to generate different reports over the same log range or for future auditing purposes (the extract file is much smaller than Db2 log, since it contains required log data only). Often, you do not need the extract file and you are using temporal datasets. But PLA still writes all the filtered data into the extract file and reads it to handle the reporting.

With the new Bypass Extract feature and compared to PLA jobs that use extract file, you can:

  • Save up to 45% of I/O
  • Improve CPU consumption up to 10%
  • Lower Elapsed Time (up to 40% faster)




This performance improvement was measured on 3.5 million log records using DML report with level DETAIL without filtering. Performance improvement depends on the Db2 log data and the report type.


How to invoke Bypass Extract functionality?

Set the new option Create Extract File ==> N on the Report Source Specification panel or save the default for this option in the CA Log Analyzer Profile.


Required PTFs

To get Bypass Extract feature, you need to install the following PTFs:

  • LU00131, LU00132, LU00133

Article was written by Vit Kalina.
0 comments
8 views

Permalink