SQLCODE: -443

[tom]

hello all,
while am trying to access the db2 database from a J2ee application it
is giving the following
error.
com.crystaldecisions.report.web.viewer.CrystalRepo rtViewer
Error formatting page : JDBC Error: DB2 SQL error: SQLCODE: -443,
SQLSTATE: 38553, SQLERRMC:
SYSIBM.SQLPROCEDURECOLS;PROCEDURECOLS;SYSIBM:CLI:-805
am trying to access a crystal report using a db2udb stored procedure.
can any one help to solve the error .
thanks in advance.
thomas

[Knut Stolze]

tom wrote:

hello all,
while am trying to access the db2 database from a J2ee application it
is giving the following
error.
com.crystaldecisions.report.web.viewer.CrystalRepo rtViewer
Error formatting page : JDBC Error: DB2 SQL error: SQLCODE: -443,
SQLSTATE: 38553, SQLERRMC:
SYSIBM.SQLPROCEDURECOLS;PROCEDURECOLS;SYSIBM:CLI:-805
am trying to access a crystal report using a db2udb stored procedure.
can any one help to solve the error .

The critical information for you is the "-805". A package cannot be found.
Have a look in the db2diag to narrow this down.

p.s: My initial guess would be that you don't clean-up your resources
properly and keep result sets/statement handles open. Thus, you run out of
packages at some point.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany