Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / March 2005

Tip: Looking for answers? Try searching our database.

db2updv8 lead to strange error

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
uthuras@hotmail.com - 22 Mar 2005 12:18 GMT
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/".
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.