Globals parm and table selection

book

Article ID: 6616

calendar_today

Updated On:

Products

CA Bind Analyzer for DB2 for z/OS CA Detector CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Database Detector for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

Given that several tables are set to AUDIT ALL, is it possible to use the GLOBALS parm to select specific objects from the SMF records?   

Environment

Release:
Component: CIDB

Resolution

You can use the WHERE clause in GLOBALS statement only for common field names like DB-NAME and PAGESET-NAME

WHERE 

Specifies Event Trace Record selection criteria that is applied before any selection by request 

statements.