| D. Portier 2006-04-27, 8:08 am |
| 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
========================================
==================================
|