The following SELECT statement selects information on each user database to which the requesting user has access, and for which a default journal table is defined.
SELECT * FROM DBC.User_Default_JournalsVX;
Result:
UserName Journal_DB JournalName -------- ---------- ----------- Usr1 Usr1 Usr1Jrnl Usr2 Usr2 Usr2Jrnl Usr3 Usr3 Usr3Jrnl