Personal tools
You are here: Home → DB2 → How To's → How to check what views and tables are inoperative
Navigation
Log in


Forgot your password?
 
Document Actions

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'"
Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls