Hello,

I've currently installed the developer toolkit for websphere commerce 5.6
together with  DB2 V8.1.10. PE
After performing the commands : 'setdbtype db2' and 'createdb.db2', without
any exceptions or errors, there
are no stored procedures in my DB2 database.

For that reason I execute the 'createsp.db2' command. However that command
doesn't succeed. My log file
shows cryptic diagnostic texts.. Does anyone know what causes the problem? I
have also tried to issue
the command with DB2 V8.1.11... i got a slightly different diagnostic text,
but SQL Codes (SQL0443N) and
state (SQLSTATE=38000) are identical.

Help!


Here are the details of the log file...

 ========================================
==================================
QL1026N  The database manager is already active.

connect to mall user db2admin using



Database Connection Information



Database server        = DB2/NT 8.2.3

SQL authorization ID   = DB2ADMIN

Local database alias   = MALL





set schema db2admin

DB20000I  The SQL command completed successfully.



put routine from availreceipts.spa owner db2admin use registers

SQL0443N  Routine "PUT_ROUTINE_SAR" (specific name "PUT_SAR") has returned
an

error SQLSTATE with diagnostic text "-31,      ,

C:\IBM\SQLLIB\bnd\psmgtptp.bnd".  SQLSTATE=38000



put routine from currentversion.spa owner db2admin use registers

SQL0443N  Routine "PUT_ROUTINE_SAR" (specific name "PUT_SAR") has returned
an

error SQLSTATE with diagnostic text "-31,      ,

C:\IBM\SQLLIB\bnd\psmgtptp.bnd".  SQLSTATE=38000



put routine from allocateitem.spa owner db2admin use registers

SQL0443N  Routine "PUT_ROUTINE_SAR" (specific name "PUT_SAR") has returned
an

error SQLSTATE with diagnostic text "-31,      ,

C:\IBM\SQLLIB\bnd\psmgtptp.bnd".  SQLSTATE=38000



put routine from xxxxxxxx.spa owner db2admin use registers

SQL0443N  Routine "PUT_ROUTINE_SAR" (specific name "PUT_SAR") has returned
an

error SQLSTATE with diagnostic text "-31,      ,

C:\IBM\SQLLIB\bnd\psmgtptp.bnd".  SQLSTATE=38000

... etc
 ========================================
==================================

[ Post a follow-up to this message ]