search cancel

can I run any CA ACF2 reports against an alternate database. I do not want to impact the live databases.

book

Article ID: 41825

calendar_today

Updated On:

Products

ACF2 ACF2 - DB2 Option ACF2 for zVM ACF2 - z/OS ACF2 - MISC PanApt PanAudit

Issue/Introduction

Question:

Can any of the ACF2 reports run against alternate databases instead of the live databases?

 

Answer:

An alternate set of databases can be used to run SOME ACF2 reports.

There are 3 acf2 reports that can run against alternative databases..
ACFRPTRX and ACFRPTXR by using the following JCL.. 
(here are some examples)


//STEP2 EXEC PGM=ACFRPTRX,REGION=4096K
//LOGONIDS DD DISP=SHR,DSN=ACF2.ALT.LOGONIDS
//INFOSTG DD DISP=SHR,DSN=ACF2.ALT.INFOSTG
//RULES DD DISP=SHR,DSN=ACF2.ALT.RULES
//SYSUT1 DD UNIT=SYSDA,SPACE=(CYL,(9,9)),DCB=BUFNO=30
//SYSUT2 DD UNIT=SYSDA,SPACE=(CYL,(9,9)),DCB=BUFNO=30
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
TITLE(acfrptxr)
NOACF2
DSET
RMASK(SYS1.-)
LID(USER0**)

/
//REPORT EXEC PGM=ACFRPTXR,
// PARM='DSET,NOACF2,RRSUM,DSN(SYS1.LINKLIB)'
//*
/* THIS JOB PRODUCES THE ACFRPTXR CROSS-REFERENCE REPORT FOR
//* DATA SET SYS1.LINKLIB
//*//LOGONIDS DD DISP=SHR,DSN=ACF2.LOGONIDS
//INFOSTG DD DISP=SHR,DSN=ACF2.INFOSTG
//RULES DD DISP=SHR,DSN=ACF2.RULES
//SYSPRINT DD SYSOUT=A
//SYSUT1 DD UNIT=SYSDA,SPACE=(CYL,(2,2)),DCB=BUFNO=30
//SYSUT2 DD UNIT=SYSDA,SPACE=(CYL,(2,2)),DCB=BUFNO=30



ACFRPTSL can run against the backup file produced when a backup is taken of the logonids database.
Here is an example


//STEP2 EXEC PGM=ACFRPTSL,REGION=4096K
//BACKUP DD DISP=SHR,DSN=ACF2.BKLIDS
//SYSUT1 DD UNIT=SYSDA,SPACE=(CYL,(9,9)),DCB=BUFNO=30
//SYSUT2 DD UNIT=SYSDA,SPACE=(CYL,(9,9)),DCB=BUFNO=30
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
TITLE(PERSONNEL WITH IDLE =1 and PROC = $ABCAAAA - $ABCZZZZ)
REPORT(SHORT)
INPUT(BKUP)
IF(IDLE = 1 AND TSOPROC GE '$ABCAAAA' AND TSOPROC LE '$ABCZZZZ')
SFLDS(TSOPROC,IDLE)

Environment

Release:
Component: ACF2MS