search cancel

Running SQL query for ENF event data. Where is the info on the actual USER causing the event?

book

Article ID: 49411

calendar_today

Updated On:

Products

CA 1 Tape Management CA 1 Tape Management - Copycat Utility CA 1 Tape Management - Add-On Options Compress Data Compression for MVS Compress Data Compression for Fujitsu Datacom DATACOM - AD CIS COMMON SERVICES FOR Z/OS 90S SERVICES DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS COMMON PRODUCT SERVICES COMPONENT Common Services CA ECOMETER SERVER COMPONENT FOC EASYTRIEVE REPORT GENERATOR FOR COMMON SERVICES INFOCAI MAINTENANCE IPC UNICENTER JCLCHECK COMMON COMPONENT Mainframe VM Product Manager CHORUS SOFTWARE MANAGER CA ON DEMAND PORTAL CA Service Desk Manager - Unified Self Service PAM CLIENT FOR LINUX ON MAINFRAME MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME GRAPHICAL MANAGEMENT INTERFACE WEB ADMINISTRATOR FOR TOP SECRET Xpertware

Issue/Introduction

Description:

In the previous version of ENF (ie. r1.0), before Datacom/AD was used for the database, the CAS9DB QUERY utility was used to obtain information relating to a specific event. One useful piece of information was USER. Where USER was the user belonging to the JOBNAME causing the event.

Starting with ENF r12, when Datacom/AD started to be utilized as the database of choice, running an SQL job (PGM=DBSQLPR) with USER as one of the SELECT criteria, the user belonging to the JOBNAME is not returned. Instead the ENF AUTHID CAS9ENFS is returned.

Example:

//SQL EXEC PGM=DBSQLPR,REGION=0M,PARM='AUTHID=CAS9ENFS'
SELECT DSN,DATE,TIME,JOBNAME,USER
FROM CAS9ENFS.DSCLOSE;

Solution:

When coding the SELECT statement enclose USER in double quotes as follows:

//SQL EXEC PGM=DBSQLPR,REGION=0M,PARM='AUTHID=CAS9ENFS'
SELECT DSN,DATE,TIME,JOBNAME,"USER"
FROM CAS9ENFS.DSCLOSE;

Environment

Release: CA90SV00200-14.1-Common Services-for z/OS
Component: