Built-in reports for DB2 for z/OS

For DB2, there are no built-in reports specifically for z/OS. In many cases, the existing Guardium built-in reports work fine, with perhaps some minor changes because of the way z-specific fields are mapped to the Guardium internal database.

Some of these mappings are shown in the following table.

Table 1. Key mappings of DB2 for z/OS concepts to Guardium report fields
Concept Entity Attribute
Subsystem ID Client/Server Service Name
Location Name Client/Server Service Description
Database Name Access Period DB2 i/z Database
Plan Name of originating request App User Name (or Access Period) App User Name (or Application User)
DBRM name for originating request (For example, SYSLH200 is used to execute JDBC distributed dynamic statements) Access Period DB2 i/z Program Name
Tip: You can rename report columns as you like by going to the Query-Report Builder, access the query, click the Display Options row and modify the column headings.