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 SQLDBA IDENTIFIED BY SQLDBAPW; SET ERRORMODE CONTINUE; GRANT SELECT ON SYSTEM.SYSCATALOG TO NULLID WITH GRANT OPTION; GRANT SELECT ON SYSTEM.SYSCOLUMNS TO NULLID WITH GRANT OPTION; GRANT SELECT ON SYSTEM.SYSINDEXES TO NULLID WITH GRANT OPTION; GRANT SELECT ON SYSTEM.SYSTABAUTH TO NULLID WITH GRANT OPTION; GRANT SELECT ON SYSTEM.SYSKEYCOLS TO NULLID WITH GRANT OPTION; GRANT SELECT ON SYSTEM.SYSINDEXES TO NULLID WITH GRANT OPTION; GRANT SELECT ON SYSTEM.SYSTABAUTH TO NULLID WITH GRANT OPTION; GRANT SELECT ON SYSTEM.SYSKEYCOLS TO NULLID WITH GRANT OPTION; GRANT SELECT ON SYSTEM.SYSSYNONYMS TO NULLID WITH GRANT OPTION; GRANT SELECT ON SYSTEM.SYSKEYS TO NULLID WITH GRANT OPTION; GRANT SELECT ON SYSTEM.SYSVIEWS TO NULLID WITH GRANT OPTION; GRANT SELECT ON SYSTEM.SYSCOLAUTH TO NULLID WITH GRANT OPTION; GRANT SELECT ON SYSTEM.SYSPROGAUTH TO NULLID WITH GRANT OPTION; GRANT SELECT ON SYSCAT.ROUTINES TO NULLID WITH GRANT OPTION; GRANT SELECT ON SYSCAT.INDEXES TO NULLID WITH GRANT OPTION; GRANT SELECT ON SYSCAT.INDEXCOLUSE TO NULLID WITH GRANT OPTION; COMMIT WORK RELEASE; ...Roland --- On Fri, 3/25/11, E. Roller <ewald.rol...@rolf-benz.com> wrote: From: E. Roller <ewald.rol...@rolf-benz.com> Subject: DB2 Connect and DB2 V7.5 To: IBMVM@LISTSERV.UARK.EDU Date: Friday, March 25, 2011, 10:54 AM Hi, struggling on with implementing DB2 V7.5, on VM I got some DRDA Problems with DB2 Connect. Environment: Database P1 is on Level 7.3 Database T1 is on Level 7.5 DB2 Connect V7.2 connects to P1 and T1 with no problems DB2 Connect V8.1 connects to P1 with no problems DB2 Connect V8.1 connecting to T1 ends up with errors: Warning: SQL error: [IBM][CLI Driver][SQLDS/VM] SQL0805N Package ".NULLID.SYSSN200" was not found. SQLSTATE=51002 , SQL state 51002 in SQLExecDirect in /web/intern/htdocs/archivts/TA0010.php on line 292 Warning: SQL error: [IBM][CLI Driver][SQLDS/VM] SQL0805N Package ".NULLID.SYSSN200" was not found. SQLSTATE=51002 , SQL state 51002 in SQLExecDirect in /web/intern/htdocs/archivts/TA0010.php on line 325 The difference of the databases P1 and T1 are in SYSTEM.SYSACCESS table: the old V7.3 fatabase contains the following entries (and some more), I don't know, where they come from: TNAME CREATOR ------------------ ------- SYSLN100 NULLID SYSLN101 NULLID SYSLN102 NULLID SYSLN200 NULLID SYSLN201 NULLID SYSLN202 NULLID SYSLN300 NULLID SYSLN301 NULLID SYSLN302 NULLID SYSLN400 NULLID SYSLN401 NULLID SYSLN402 NULLID SYSSN100 NULLID SYSSN101 NULLID SYSSN102 NULLID SYSSN200 NULLID SYSSN201 NULLID SYSSN202 NULLID SYSSN300 NULLID SYSSN301 NULLID In the V7.5 database these entries are missing. Reading the Database Administration Guide, I found out, that I have to set up a Stored Procedure Server for DB2 UDB V8.x connections. This is new with DB2 V7.3, the old database on this level works well without a Stored Proc Server. What do I miss ?? TIA Ewald Roller
