473,379 Members | 1,312 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,379 software developers and data experts.

db2updv8 lead to strange error

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

Nov 12 '05 #1
1 1564
could you check the file "db2schem" in path
".../sqllib/function/unfenced/".

Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Mark A | last post by:
On the forum at ibm.software.db2.udb it was mentioned that one should run db2updv8 after installing fixpack 9 (or 9a). But there is no mention of db2updv8 in FP9a installation readme file. Anyone...
10
by: Mahesh S | last post by:
Hi I am trying to create a federated database using information integrator. When I tried creating wrapper on by right clicking on "Federated database objects" which appears under every...
0
by: andrejf | last post by:
After upgrading from v7 fp11 to v8 fp12 and migrating the databasase, db2updv8 fails. The routine IS visible in the catalog. On other databases i can rerun db2updv8 when they have the routine...
1
by: Asphalt Blazer | last post by:
I am running db2updv8 -d databasename and i get this error exec(): 0509-036 Cannot load program db2updv8 because of the following errors: 0509-022 Cannot load module...
7
by: rfinch | last post by:
Very new to this but using the MS working with dynamics CRM 3.0 book to run web application to retrieve lead records from CRM 3.0. Have followed the book instructions on page 380-382. But am...
2
by: aj | last post by:
DB2 LUW 8.2 FP15 When going from FP14 to FP15, is it necessary to issue the db2updv8 command for each database? Is this only intended to be used when moving from 8.1 to 8.2 (ie FP7), or is it...
6
by: =?Utf-8?B?UGF1bCBQcmV3ZXR0?= | last post by:
Hi - I have 4 webservers in my webfarm. All Win2k3 web edition. Before yesterday, none of them were service packed. I have now applied SP2 to two of them, and I'm getting a very weird MSDTC...
9
by: Trapulo | last post by:
Hello, with ASP.NET 2.0 Ajax every unexpected error is managed client-side with a popup that reports the error to the user. In ASP.NET 3.5 this behavor has been changed: how can I have a similar...
1
by: HarishAdea | last post by:
Hi, I am trying to run the JAVA pgm, but it is giving error as "selection does not contain a main type". The filename is "ScoreLeadSummary.java" when i try to run it or debug,it gives the pop...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.