471,073 Members | 1,398 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,073 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 1604

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by R. Clausen | last post: by
1 post views Thread by uthuras | last post: by
5 posts views Thread by Philip Nelson | last post: by
3 posts views Thread by chettiar | last post: by
1 post views Thread by Asphalt Blazer | last post: by
reply views Thread by leo001 | last post: by

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.