统计失效视图

--统计失效视图个数和视图名称   (0 个失效)         
select * from syscat.views v where v.VALID <>'Y';

--统计失效包个数和名称  （26个失效P8491299,STADMG01）       
select * from SYSCAT.PACKAGES p where p.VALID<>'Y';

--统计生产环境视图个数  （267个）
SELECT * FROM SYSCAT.VIEWS v where trim(v.VIEWSCHEMA) in ('APPS','GAM') order by viewname;

--统计生产环境函数个数 （77个）
SELECT * FROM SYSCAT.functions f where trim(f.funcschema) IN
('APPS','FBP_FRAME_PKG','FBP_FUNCTION_PKG','FOL_NOTICE_FACADE','CREATE_ACCOUNT_COMBINATION','SIE_BOE_INVOICES_PKG','FBP_GENERATION_NUMBER_PKG','WFR_RULESENGINE_PKG','WFR_RULESENGINE_PREVIEW_PKG','FBP_DATA_SYNC_PKG','SIE_BOE_EXCEL_PKG','SIE_BOE_ACCRUED_PKG','FBP_DATA_REGEDIT_API','JAM','GAM','FOL_BPEL_FACADE','WFR_RULESENGINE_NEW_PKG');

--统计生产环境存储过程个数 （100个）
SELECT * FROM SYSCAT.procedures p where trim(p.procschema)
in ('APPS','FBP_FRAME_PKG','FBP_FUNCTION_PKG','FOL_NOTICE_FACADE','CREATE_ACCOUNT_COMBINATION','SIE_BOE_INVOICES_PKG','FBP_GENERATION_NUMBER_PKG','WFR_RULESENGINE_PKG','WFR_RULESENGINE_PREVIEW_PKG','FBP_DATA_SYNC_PKG','SIE_BOE_EXCEL_PKG','SIE_BOE_ACCRUED_PKG','FBP_DATA_REGEDIT_API','JAM','GAM','FOL_BPEL_FACADE','WFR_RULESENGINE_NEW_PKG');