Friday, December 16, 2011

SQL0575N View or materialized query table "SCHEMA.TABLE_NAME" cannot be used because it has been marked inoperative. SQLSTATE=51024

exceptionCOM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/SUN64] SQL0575N  View or materialized query table "SCHEMA.TABLE_NAME" cannot be used because it has been marked inoperative.  SQLSTATE=51024

OR

 51024(-575)[IBM][CLI Driver][DB2/SUN64] SQL0575N  View or materialized query table "SCHEMA.TABLE_NAME" cannot be used because it has been marked inoperative.  SQLSTATE=51024
 (0.45 secs)

If you get above exception in JAVA or while executing query in DB2, possible reason could be the view or materialized query table name has been marked inoperative because a table, view, alias, or privilege upon which it is dependent has been removed.

Please report this error to your database administrator so that they may grant privilege for that table, view or alias.