I have successfully migrated the IBM DB2 8.2 LUW to IBM DB2 9.7 Express-C on Windows 2003 Server. But when i change the system date back one week from current date I can't access some new tables that was created before changing the date without schema prefix, If I use schema prefix then I can access the table (schema.Tablename).
Logging with "db2admin"
Try to access "test" table of db2admin like "select * from test" got error "Table not found".
Try to access "test" table of db2admin like "select * from db2admin.test" result successfully displayed.
Note: db2 values current schema shows "db2admin"