Hello Ewald, I think the missing OBJECTs with CREATOR of NULLID are from
running a BIND from UDB DB2/Connect against a DB2/VM server using DB2??LST.
Please check your UDB DB2/Connect PD.
However, you also have to run the following 'GRANT's before running the UDB
DB2/Connect BIND:
CONNECT
The Database Administration Guide explains the Stored Procedure servers.
It's Chapter 11 in the 7.5 manual.
The SQL Reference can tell you how to create a stored procedure server
for your database. See the CREATE PSERVER statement.
I hope this helps,
Nora Graves
nora.e.gra...@irs.gov
Main IRS,
BTW, on the subject of stored procedures...
We have DB2/VSE 7.3 running on multiple VSE systems.
We have been running DB2/UDB 7.x client on Windows going thru a DB2 Connect 7.x
single user edition.
Right...this setup doesn't require a stored procedure server.
However, when we added a DB2
Those modules get created by prepping DB2 connect into the DB2 databases
on the VM side. How you get DB2 Connect to work without those modules is
more perplexing to me to tell you the truth, but maybe that was possible
in older releases of DB2 Connect. Anyway, there is a bind process that
You have to rebind packages.
You didn't say if you have the DB2 Connect Server version(s) or the standalone
client.
From each DB2 Connect Server, you have to rebind to each release of DB2 VM/VSE
in which that Connect Server will access.
Then, from each type of client (Win/.XP, Win/7 32 bit,