OPSLOG records to track column value changes in all SSM managed RDF tables

Products

• OPS/MVS Event Management & Automation

Issue/Introduction

I would like to produce some sort of OPSLOG records that track column value changes in all of my SSM-managed RDF tables.   

Environment

OPS/MVS-Event Management & Automation-for JES2

Resolution

The SSMAUDIT parameter controls whether changes to both the SSM resource tables and the directory tables are logged to OPSLOG using the trace message OPS7914T. This message includes the SQL operation, the table name, key, and the job name and program name of the address space that issued the SQL command.

For SQL updates, the first monitored column name changed and the first 16 characters of the new value are also displayed.

In addition we also have five other parameters named SSMMONITOREDCOL1 to SSMMONITOREDCOL5. They are used in conjunction with SSMAUDIT when the value YES is set for OPSLOG recording purposes.

Each SSMMONITOREDCOLn parameter can specify an eighteen-character SQL column name. Columns specified within these parameters are actively monitored by System State Manager for all SSM-managed tables. 

User-defined exits may be written to react to the global events generated by changes to these columns. Changes to these columns are logged to the OPSLOG using the trace message OPS7914T if SSMAUDIT is set to YES.