-- If you still have pre-V8.2 compiled procedures on your system, 
-- this simple query will indentify invalidated packages.

select substr(procschema,1,8),substr(procname,1,18),        pkgname,explicit_bind_time,last_bind_time
from   syscat.procedures proc inner join syscat.packages pack
       on proc.procschema = pack.pkgschema
where  pack.pkgname = substr(proc.implementation,1,8)
and    pack.valid <> 'Y'
;
