UDF has schema issues

[Tomas]

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.

thanks,

/T

[Serge Rielau]

Tomas wrote:

Serge,

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
schema.

We have opened a PMR to see if we can get this figured out.

That would have been my next proposed step.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab