By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,756 Members | 1,749 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,756 IT Pros & Developers. It's quick & easy.

UDF has schema issues

P: n/a
Hello all,

I have migrated a database from 8.2 to 9 FP3 by restoring a backup
into a DB2 9 instance. Operating system is Solaris. The migration
during the restore claims to have been successful.

Now, there is this function created back on the 8.2 side by me. Works
as intended on 8.2. In the DB2 9 database, it has decided to use my
schema (as the definer/owner) to resolve unqualified table names.
Path and func path both point to the application schema.
SYSCAT.ROUTINEDEP says that the dependencies are tables in the
application schema. Yet when executing the function, it complains
that it can't find the tables in MY schema.

Has anyone else experienced this? We have more instances of
essentially the same issue.



Sep 20 '07 #1
Share this Question
Share on Google+
1 Reply

P: n/a
Tomas wrote:

the database was restored from a backup of a 8.2 database with a
redirected restore, into the DB2 9 FP3 instance. When I created the
function, the schema was set to <main_schemaand path was
<sysibm,sysfun,sysproc,main_schema>. This is reflected in the
FUNC_PATH in the catalog. It also doesn't matter what the CURRENT
SCHEMA or PATH is when executed, it always complains about not finding
the table in the definer/owner schema (mine). The application always
sets the correct schema and path in the connection string, but I've
tested it with several other users and settings for current path and

We have opened a PMR to see if we can get this figured out.
That would have been my next proposed step.

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Sep 21 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.