I'm having strange problem after upgrading my database using db2updv8
utility. The database reside on AIX 5.2 box. I'm using DB2 V8.1 FP 4a.
My developer use DataStage 7.0 to access the database on the AIX box.
Each time when a job is executed at DataStage, it will give the
following warning messages
CIF41TSDSIFM01..LOAD_JOB_LOG.W_STGDB: SQLTables: Error retrieving
system catalog information for requested tables(s).
CIF41TSDSIFM01..LOAD_JOB_LOG.W_STGDB: [IBM][CLI Driver][DB2/6000]
SQL0444N Routine "SQLTABLES" (specific name "TABLES") is implemented
with code in library or path ".../sqllib/function/unfenced/db2schem",
function "sqltables" which cannot be accessed. Reason code: "4".
SQLSTATE=42724
However, the job complete with out errors. Just wonder whether this
warning will effect data integrity. I've checked the db2diag.log and
DAS log files for error, but there are no errors registered. I executed
db2updv8 utility as the DB2 Federated database fail when i try to
create a wrapper and prompt me to upgrade the database using db2updv8
utility.
Please help!!
Uthuras
Shyam Peri - 23 Mar 2005 14:09 GMT
could you check the file "db2schem" in path
".../sqllib/function/unfenced/".