Unanswered: Non existing table showing in syscat.tables
This is for version 8.1 on 4 logical partition system on AIX.
I have this tables called DB.TAB_usrt that show up in syscat.tables and sysibm.systables. Also db2 list tables for all shows this table exist.
This is not a view. Its a table.
But when I try to drop this table it give me following error :
SQL0204N "DB.TAB_usrt" is an undefined name. SQLSTATE=42704
Also db2look doesn't generate any ddl for this table.
I have updated stats on all tables including system tables. But problem still exists.
Is anything currupt here? Why syscat.tables show up this non existing table?