当前位置:操作系统 > Unix/Linux >>

统计失效视图

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

 


CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,