Creating a report of Ideal Dataview Administrators

Products

• Ideal
• Datacom
• Datacom/DB

Issue/Introduction

When administering the Ideal system, is there a way to produce a report of the people with Ideal Dataview Administrator access?

I tried using the PERSYS report, but it was too involved and gave me too much information.

Resolution

There are many different ways to get administrative information from the Ideal system. Here are two options:

1. Using DBSQLPR to combine data from multiple Datadictionary tables:

//*Your JOB statement goes here
//*------------------------------------------------------------------*
//*
//*   Datacom SQL Report of Ideal Dataview Administrators from
//*       the Datacom Datadictionary
//*
//*   Expected condition code EQ 00
//*
//*------------------------------------------------------------------*
//         EXPORT  SYMLIST=(*)    <-- Do not remove this statement
//*
//*     1. Enter the JOB statement details for your system.
//*
//*     2. DSN of Datacom Custom and Base Loadlibs
//  SET    CUSLIB=<<Datacom CUSLIB
//  SET    BASLIB=<<Datacom Base Loadlib
//*
//*     3. Enter the authorization level to search
//*        Some possibilities are $$ID-ADM, $$ID-DVW, $$DD-ADMIN
//  SET    DDAUTH='$$ID-DVW'
//*
//*------------------------------------------------------------------*
//*
//SQLCARD  EXEC PGM=DBSQLPR,
//  PARM='AUTHID=SYSADM,NOECHO,NOTYPE,PAGELEN=60,ROWLIMIT=9999999'
//STEPLIB  DD DISP=SHR,DSN=&CUSLIB
//         DD DISP=SHR,DSN=&BASLIB
//OPTIONS  DD DUMMY
//SYSPRINT DD SYSOUT=*
//STDOUT   DD SYSOUT=*
//SYSIN    DD  *,SYMBOLS=(JCLONLY)
--
-- This section defines the report header
--
Select  Substr(CHAR(CURRENT TimeStamp),1,19) "Date-Time",
        CURRENT DATACOM MUF_NAME       "MUF",
        DIR_NAME                       "CXX",
        Substr(CHAR(ENABLE_TIME),1,19) "MUF Start Time",
        'Users with &DDAUTH'         "DBSQLPR Datadictionary Report"
    From SYSADM.MUF_Identity;
Select ' ' " " From MUF_Identity;
--
-- This section defines the detail report
--
Select  PER.ENTITY_NAME            "Userid",
        PER.DESCRIPTION            "User Name",
        REL.OBJ_OCC_NAME           "Relationship"
   From SYSADM.PERSON  PER
     Inner Join SYSADM.RELATIONSHIP  REL
       On  PER.ENTITY_NAME  =  REL.SUBJ_OCC_NAME
       And PER.ENTITY_VER   =  REL.SUBJ_VRS_NUM
   Where PER.STATUS       =  'P'
     And REL.ENTITY_NAME  =  'PER-ATZ-AUTH'
     And REL.OBJ_OCC_NAME =  '&DDAUTH'
   Order by PER.ENTITY_NAME
;
/*
//

2. Using Datadictionary native reporting. This will produce some of the information, but it will not have the user name detail, only the authorization ID. Use your standard JCL to run the DDUTILTY program with this input:

//SYSIN    DD  *                               
-USR DATACOM-INSTALL,NEWUSER                   
-DEF PATH,P1                                   
-DEF TRACE,AUTHORIZATION.PERSON,PER-ATZ-AUTH   
-END                                           
-RPT START,AUTHORIZATION,$$ID-DVW(PROD,PRIV),P1
-RPT INDENTED                                  
-END                                           
/*      

 

Additional Information

As always, please contact Broadcom support for Datacom if you have further questions.