Saturday, 17 May 2014

How to check what views and tables are inoperative

How to check what views and tables are inoperative

syscat.tables - status
Apply the query below to find what views and tables are inoperative:

db2 "select substr(tabname,1,20) as TABLE, status, type from syscat.tables where status='X'"
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)