How to bypass records by DB2AUTH
search cancel

How to bypass records by DB2AUTH

book

Article ID: 247375

calendar_today

Updated On:

Products

MICS Resource Management

Issue/Introduction

Specifically, can you point me to a document that describes how I can bypass records by DB2AUTH?

During the daily download from SMF in step DAY065.

Environment

Release : 14.2

Component : MICS DB2 ANALYZER

Resolution

Suggested filtering out the records in the DB2EXIT module by DB2AUTH or DB2PLAN column as mentioned in the DIC.Text.

Filter out in USER.SOURCE(#DB2EXIT) module by adding these changes:

 

%INCLUDE  SOURCE(#DB2EXIT);

%LET USRSDB2= USRSDB2;    

 

And create new member USRSDB2 with the following filter condition:

 

IF DB2AUTH EQ ‘XXXX’ THEN SKIP_REC=1

 

The same was mentioned in the document section 10.2.3 output exits;

   sharedprefix.MICS.SOURCE(#DB2EXIT):  

   %LET USRSDB2 = PACKAGE ;

 

   prefix.MICS.USER.SOURCE(PACKAGE):   

   IF   DB2AUTH EQ 'XXXX' THEN SKIP_REC=1;
      

 

 

Additional Information

See case # 3318784.