Enhance command -DISPLAY PROFILE with keyword DETAIL

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 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 currently activated.