DB2 - cannot invalidate a view
As for the view being valid after dropping a column: The view is defined as SELECT * so the view is still valid. 

Regarding the validity of the view after dropping the table just use field VALID from SYSCAT.VIEWS, see below.

db2 =&gt; DROP TABLE DB2INST1.TEMP_T
DB20000I  The SQL command completed successfully.
db2 =&gt; SELECT SUBSTR(VIEWNAME,1,32) AS TABLE, VALID FROM SYSCAT.VIEWS WHERE VIEWNAME='TEMP_V'

TABLE                            VALID
-------------------------------- -----
TEMP_V                           N

  1 record(s) selected.

db2 =&gt; CREATE TABLE DB2INST1.TEMP_T ( COL_A  CHAR(5) )
DB20000I  The SQL command completed successfully.
db2 =&gt; SELECT SUBSTR(VIEWNAME,1,32) AS TABLE, VALID FROM SYSCAT.VIEWS WHERE VIEWNAME='TEMP_V'

TABLE                            VALID
-------------------------------- -----
TEMP_V                           N

  1 record(s) selected.

db2 =&gt; SELECT * FROM DB2INST1.TEMP_V

COL_A
-----

  0 record(s) selected.

db2 =&gt; SELECT SUBSTR(VIEWNAME,1,32) AS TABLE, VALID FROM SYSCAT.VIEWS WHERE VIEWNAME='TEMP_V'

TABLE                            VALID
-------------------------------- -----
TEMP_V                           Y

  1 record(s) selected.