Identifying all ACF2 for Db2 rules for a Db2 subsystem.

Products

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

Issue/Introduction

Have a Db2 for z/OS subsystem that has been decommissioned and want to delete all resource
rules associated with this subsystem.  How to generate a list of all rules for a particular Db2
subsystem regardless of type.  Do not want to have to know what all the types are and then
generate a list for each type.  Alternatively is there a way of deleting all these Db2 rules?

 

Environment

Release : 1.3

Component : CA ACF2 Option for Db2

Resolution

These is no method to list all of the ACF2 for Db2 resource rules for a given Db2 subsystem with
a single command. The suggested method is the following sample JCL where the SYSID is
TEST in this example:


//STEP01 EXEC PGM=ACFBATCH
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
SET DB2(BPL) SYSID(TEST)
LIST LIKE(-)
SET DB2(COL) SYSID(TEST)
LIST LIKE(-)
SET DB2(CON) SYSID(TEST)
LIST LIKE(-)
SET DB2(DBS) SYSID(TEST)
LIST LIKE(-)
SET DB2(FNC) SYSID(TEST)
LIST LIKE(-)
SET DB2(JAR) SYSID(TEST)
LIST LIKE(-)
SET DB2(PKG) SYSID(TEST)
LIST LIKE(-)
SET DB2(PLN) SYSID(TEST)
LIST LIKE(-)
SET DB2(PRC) SYSID(TEST)
LIST LIKE(-)
SET DB2(ROL) SYSID(TEST)
LIST LIKE(-)
SET DB2(SCH) SYSID(TEST)
LIST LIKE(-)
SET DB2(SEQ) SYSID(TEST)
LIST LIKE(-)
SET DB2(STG) SYSID(TEST)
LIST LIKE(-)
SET DB2(SYS) SYSID(TEST)
LIST LIKE(-)
SET DB2(TBL) SYSID(TEST)
LIST LIKE(-)
SET DB2(TSP) SYSID(TEST)
LIST LIKE(-)
SET DB2(TYP) SYSID(TEST)
LIST LIKE(-)
SET DB2(VAR) SYSID(TEST)
LIST LIKE(-)
/*


The delete process would be the same:

//STEP01 EXEC PGM=ACFBATCH
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
SET DB2(BPL) SYSID(TEST)
DELETE LIKE(-)
SET DB2(COL) SYSID(TEST)
DELETE LIKE(-)
SET DB2(CON) SYSID(TEST)
DELETE LIKE(-)
SET DB2(DBS) SYSID(TEST)
DELETE LIKE(-)
SET DB2(FNC) SYSID(TEST)
DELETE LIKE(-)
SET DB2(JAR) SYSID(TEST)
DELETE LIKE(-)
SET DB2(PKG) SYSID(TEST)
DELETE LIKE(-)
SET DB2(PLN) SYSID(TEST)
DELETE LIKE(-)
SET DB2(PRC) SYSID(TEST)
DELETE LIKE(-)
SET DB2(ROL) SYSID(TEST)
DELETE LIKE(-)
SET DB2(SCH) SYSID(TEST)
DELETE LIKE(-)
SET DB2(SEQ) SYSID(TEST)
DELETE LIKE(-)
SET DB2(STG) SYSID(TEST)
DELETE LIKE(-)
SET DB2(SYS) SYSID(TEST)
DELETE LIKE(-)
SET DB2(TBL) SYSID(TEST)
DELETE LIKE(-)
SET DB2(TSP) SYSID(TEST)
DELETE LIKE(-)
SET DB2(TYP) SYSID(TEST)
DELETE LIKE(-)
SET DB2(VAR) SYSID(TEST)
DELETE LIKE(-)
/*


The following can be executed to identify the ACF for Db2 resource types:

//STEP01   EXEC PGM=ACFBATCH      
//SYSPRINT DD SYSOUT=*            
//SYSIN    DD *           
SET C(GSO) MSYSID(****) 
LIST LIKE(APPLDEF.DB2-)


The Db2 APPLDEF definitions can be found in the ACF2 for Db2
hlq.CACPJCL0 member CP13ADF.