with xsr as (select xsrobjectid, xsrobjectschema, xsrobjectname 
        from sysibm.sysxsrobjects where decomposition != 'N') 
        select dschema, dname, dtype, bschema, bname from sysibm.sysdependencies t1 
        where not exists (select xsrobjectschema, xsrobjectname from xsr t2 
        where t1.bschema = t2.xsrobjectschema and t1.bname = t2.xsrobjectname) 
        and btype = 'Z'  ;

   with packages as (select creator, name, unique_id from sysibm.sysplan) 
        select bcreator, bname, btype, dcreator, dname, dunique_id from 
        sysibm.sysplandep where not exists (select creator, name from packages 
        where creator = dcreator and   name = dname and   unique_id = dunique_id)  ;

with
  packages as (
    select creator, name, unique_id
    from sysibm.sysplan
  ) 
select *
-- bcreator, bname, btype, dcreator, dname, dunique_id
from sysibm.sysplandep
where
  not exists (
    select creator, name
    from packages 
    where creator = dcreator
      and name = dname
      and unique_id = dunique_id
)

select * --creator, name, unique_id
from sysibm.sysplan
where -- name like 'DBMS_JOB%'
  creator like 'SYSIBMADM%'
order by name