473,396 Members | 1,990 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,396 software developers and data experts.

db2updv8: Fail to create routine SYSPROC.DB2LK_DEP_OF

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 int the catalog.

I already bound @db2cli.lst and @db2ubind.lst and db2schema.bnd grant
public.

I also noticed, that non dbadm users get sql551 when executing sql
with sign() function:

select abs(sign(data)) from table

They get sql0551 complaining on execute of object "sysfun.sign"

Sep 7 '06 #1
0 1731

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

Similar topics

2
by: R. Clausen | last post by:
I am wanting to create a database in UDB (WIN) v8 FP4 using a backup from UDB (WIN) v7.2 FP4. When the restore is complete, I get a DB2 Message 'The command completed successfully.', however, when...
1
by: uthuras | last post by:
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...
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...
5
by: Philip Nelson | last post by:
I get - db2inst1@dvorak /db2data $ db2 "create database DBTST001 automatic storage yes on /db2data/db2db dbpath on /db2data/db2db" SQL0805N Package "NULLID.SQLE2F0J 0X4141414141654557" was not...
3
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 bi.Provisioned_Spam''' || ')'; execute immediate...
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...
0
by: Eil | last post by:
Have 2 databases under the same db2 udb instance (aix 5.3.0.0, db2 udb V8.1, fixpak 9). Able to run the db2advis command successfully against one database. On the other database, always...
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...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
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
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

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.