Friday, 19 August 2011

IBM DB2 useful scripts

Show not valid views and triggers in database

select viewschema,viewname,valid from syscat.views where viewschema = 'shema name' and valid <> 'Y';

select trigname,valid from syscat.triggers where trigschema = 'shema name' and valid <> 'Y';

No comments: