Enhance DB2 -DISPLAY PROFILE with keyword DETAIL Merged

The -DISPLAY PROFILE command allows to determine if profiling is active or inactive on a specific DB2 member. The command returns output similar to:


-display profile
 DSNT753I +DB2A DSNT1DSP DISPLAY PROFILE REPORT FOLLOWS:
          STATUS = ON
          TIMESTAMP = 2022-07-25-12.00.10.0000000
          PUSHOUTS = 0 OUT OF 10000
          DISPLAY PROFILE REPORT COMPLETE.
 DSN9022I +DB2A DSNT1DSP 'DISPLAY PROFILE' NORMAL COMPLETION

If the profile status is ON or SUSPENDED, the output contains a timestamp about when profiling started.

The output does not indicate whether, and if so, which profiles are currently started. Using the provided timestamp and the related DB2 member name, one has to query the profile history tables and select the related rows. However, this is multi-step process:

• Get the DB2 member name

• Get the timestamp (and subtract some seconds)

• Select row(s) from the profile table and all related rows from the attribute-history tables

• Within the result sets, check the STATUS column.

We believe it would be a good idea to introduce a DETAIL keyword to the DISPLAY PROFILE command, which then results in an output similar to:

-display profile detail
DSNT753I +DB2A DSNT1DSP DISPLAY PROFILE DETAIL REPORT FOLLOWS:
         STATUS = ON
         TIMESTAMP = 2022-07-25-12.00.10.0000000
         PUSHOUTS = 0 OUT OF 10000
 
         PROFILEID STATUS
         ---------- ------------------------
         123        ACCEPTED
         124        ACCEPTED
         125        REJECTED
         126        ACCEPTED
         127        PARTIALLY ACCEPTED
         …          … … …
         DISPLAY PROFILE REPORT COMPLETE.
DSN9022I +DB2A DSNT1DSP 'DISPLAY PROFILE' NORMAL COMPLETION

Column PROFILEID shows the PROFILEID of started profiles; column STATUS returns the consolidated status summary, ACCEPTED for a fully activated profile, PARTIALLY ACCEPTED for an activated profile with one or multiple rejected attributes, and REJECTED for a rejected profile.

With that in place, an administrator is not only allowed to determine if profiling is active, he can now determine whether the most recent START PROFILE was completely successful, or not, and which profiles are activated.