How can I list all DB2 USERS that are connected to a secondary authid with ACF2?

Document ID : KB000117573
Last Modified Date : 24/10/2018
Show Technical Document Details
Question:
What ACF2 commands can I use to list all db2 users that are connected to a specific secondary AUTHID.
Answer:
The ACF2 records that are used fro secondary authids are XREF(SGP) records.
To list a specific entry, issue the following command
ACF
SET X(SGP) MSYSID(****)
LIST GROUP1
END

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*)
EXCLUDE(USR0028) SOURCE

The last entry in the example list shows a masked include entry.
The list all users that match this mask, enter the following commands 

ACF
SET LID
SET TERSE
LIST LIKE(USR002*)
END

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