What ACF2 commands can I use to list all db2 users that are connected to a specific secondary AUTHID.
The ACF2 records that are used fro secondary authids are XREF(SGP) records.
To list a specific entry, issue the following command
SET X(SGP) MSYSID(****)
the following style of output will be displayed...
SYS* / GROUP1 LAST CHANGED BY USER02 ON 12/15/17-12:25
INCLUDE(USR0007 USR0008 USR0009 USR001 USR0010 USR0011
USR0019 USR002 USR002*)
The last entry in the example list shows a masked include entry.
The list all users that match this mask, enter the following commands
The following style of output will be returned
USR0020 usr0020 user 0020 ext 20
USR0021 usr0021 user 0021 ext. 21
USR0028 usr0028 user 0028 ext. 28
after ascertaining all users that are included, you can then remove users that are in the EXCLUDE list.
In this example US0028 is excluded from the list of users.
You should be able to see all users that are attached to this secondary authid.
The full list of users attached to secondary authid GROUP1 in this example would be..
USR0007 USR0008 USR0009 USR001 USR0010 USR0011
USR0019 USR002 USR0020 USR0021