I was asked to provide a way to find journal receivers and discern whether or not they are attached or detached.

journal receivers attached or not.sql

--
-- description: Which journal receivers are currently attached?
--
select attached_journal_receiver_library, attached_journal_receiver_name
  from qsys2.journal_info
  where journal_library = 'PRODLIB'
  order by 1,2;
  

--
-- description: Which journal receivers are detached?
--
with attached(jl, jrcv) as (
select attached_journal_receiver_library, attached_journal_receiver_name
  from qsys2.journal_info
  where journal_library = 'PRODLIB'
  order by 1,2
)
select objname as detached_jrnrcv, a.*
  from table (
      qsys2.object_statistics('PRODLIB', '*JRNRCV')
    ) as a
    where objname not in (select jrcv from attached) ;