472,353 Members | 1,207 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

SYSPROC.SYSINSTALLOBJECTS not found in one DB but exist in another DB in the same instance

Hi All,

I have two Databases in one DB2 instance V8.2 run on Windows2000. I do
the same thing to the two databases when I apply DB2 Fixpak7 to bring
the instance to V8.2.
I try to use "activity monitor" on both databases. One DB is ok and
another one reports error:

Routine "*LOBJECTS" (specific name "SQL040928114054710") is
implemented with code in library or path "...ALLOBJECTS",
function "SYSPROC.SYSINSTALLOBJECTS" which cannot be accessed.
Reason code: "4". SQLSTATE=42724

Who can explain that, and how to fix it?

Thanks in advance.

Nov 12 '05 #1
0 1223

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

Similar topics

by: Ari Royce Hidayat | last post by:
Dear ALL, Is there some one ever faces this problem? And fix it? The scenario is: There's an html page that hosts a .net object (using...
by: Ari Royce Hidayat | last post by:
Tx a lot for idea. I've tried it, and still get not clue what causes it. I also tried to see the log file generated by IEHost (by adding...
by: Andy S. | last post by:
Hi, I'm running DB2 v 7.2 FP 9. After connecting to DB2, i ran the following commands: set path = "SYSIBM","SYSFUN","DB2ADMIN","SYSPROC" ...
by: efiryago | last post by:
Are stored procedures in SYSPROC schema documented and supportedd? I am particularly intersted in the procedure SYSPROC.DB2LOAD which seems to be a...
by: PaulR | last post by:
Hi, I have used the Table Function SYSPROC.SNAPSHOT_APPL_INFO in a Trigger body, and am having problems granting suitable permissions to allow...
by: UDBDBA | last post by:
Hi: How can one call SYSPROC.DB2LOAD procedure within a SQL stored procedure. I get the following error: DB21034E The command was processed...
by: db2adm1 | last post by:
I am getting the following error while trying to alter a table's column...I am trying to increase the decimal length of the column from 5 to 6...
by: chettiar | last post by:
I am trying to do the following from within a procedure. set vcsql = 'Call SYSPROC.ADMIN_CMD(' || '''load from /dev/null of del replace into...
by: alexia.bee | last post by:
Hi all, In some weird reason, excel instance won;t die if i remove the comment from 4 lines of setting values into struct. here is a snipcode...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand....
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS...
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python...

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.