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 Connect 9.5 Server, and 9.5 clients, any use of the DB2 Command Center on the PC, requires a DB2 Stored Procedure Server running on the mainframe. Now, I don't know if it was the DB2 Connect version change that required the stored procedure server or that the DB2 client version change that required the stored procedure server, but now, anytime a DB2 9.x client starts using the DB2 Command Center, the stored procedure server DFLT0001 fires up to handle the request. Tom Duerbusch THD Consulting >>> "E. Roller" <ewald.rol...@rolf-benz.com> 3/25/2011 9: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
