The following SELECT statement selects the information on each database accessible by the requesting user for which a default journal table is defined:
SELECT * FROM DBC.Database_Default_JournalsV;
Result:
DatabaseName Journal_DB JournalName ------------ ---------- ------------ DtBs1 DtBs1 DtBs1Jrnl DtBs2 DtBs2 DtBs2Jrnl DtBs3 DtBs1 DtBs1Jrnl