Does ACFRPTXR supports SYSID to specify the DB2 system name?

Products

• ACF2
• ACF2 - DB2 Option
• ACF2 for zVM
• ACF2 - z/OS
• ACF2 - MISC

Issue/Introduction

How can the ACFRPTXR report be run to report everyone who has access to some DB2 tables based on SYSID to specify the DB2 system name?

Environment

Release : 16.0

Component : CA ACF2 for z/OS

Resolution

The sysid is part of the resource name for DB2 rules so you can run the ACFRPTXR report for DB2 rules using the NAME parameter ie. NAME(sysidrulekey). For example:

For DB2 TYPE(TBL) rules for any sysid and table name TSTTBL:
//SYSIN DD *
RSRC     
TYPE(TBL)
NAME(****TSTTBL)
CLASS(D)
NORRSUM 

For DB2 TYPE(TBL) rules for sysid DSN4 and table name TSTTBL:
//SYSIN DD *
RSRC     
TYPE(TBL) 
NAME(DSN4TSTTBL)
CLASS(D)
NORRSUM