Hi,

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?

Thanks for help,
toby

Could you supply the entire script that produce suche error?...

If you used

CREATE TABLE "DB.TAB_usrt"
...

you also have to use

DROP TABLE "DB.TAB_usrt"

DROP TABLE DB.TAB_usrt or Select * from db.tab_usrt would not be matched since internally it will look for DB.TAB_USRT.

Otherwise: if the table was created using

CREATE TABLE DB.TAB_USRT (capital or small characters don't matter as long as "" is not used)

then also drop it this way:

DROP TABLE DB.TAB_USRT

Advice: don't mix large and small characters using ""