use of filterac

Products

• Bind Analyzer for DB2 for z/OS
• SQL-Ease for DB2 for z/OS
• SYSVIEW Performance Management Option for DB2 for z/OS
• Plan Analyzer for DB2 for z/OS
• Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

cut down on number of records being cut to out history

using Filterac possibly. 

How would we do that?

we want to cut down on number of records being cut to out history files.

As an example just cut records greater than half a second CPU. How to do that?

 

 

Environment

z/os db2

Resolution

Using FILTERAC would be the easiest way. 

Example supplied

 

FILTERAC: FILTER (FLASH) ACCT 

WHERE THD-ELAPSED > 0.5 /* > half secS 

TITLE=('Thread History Filter')