统计失效视图
统计失效视图
--统计失效视图个数和视图名称 (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');