IBM Support

DB2 error (sqlcode: -805)

Question & Answer


Question

How to resolve DB2 sql -805 errror

Cause

The statement cannot complete because the necessary package was not found in the catalog.
The JAVA trace similar to following
10/6/10 8:53:36:795 EDT] 0000056d SystemOut O 06 Oct 2010
08:53:36:793 [ERROR] Failed SQL query in MboSet.getNextRecordData():
select * from query where app = 'STARTCNTR' and (owner =
'OWNER ' or ispublic = 1) order by clausename
com.ibm.db2.jcc.b.SqlException: Package "NULLID.SYSLH205
0X5359534C564C3031" was not found.
at com.ibm.db2.jcc.b.sf.e(sf.java(Compiled Code))
at com.ibm.db2.jcc.c.jb.p(jb.java(Compiled Code))
at com.ibm.db2.jcc.c.jb.h(jb.java(Compiled Code))
at com.ibm.db2.jcc.c.jb.a(jb.java(Compiled Code))
at com.ibm.db2.jcc.c.w.a(w.java(Inlined Compiled Code))
at com.ibm.db2.jcc.c.cc.f(cc.java(Compiled Code))
at com.ibm.db2.jcc.b.sf.n(sf.java(Inlined Compiled Code))
at com.ibm.db2.jcc.b.sf.a(sf.java(Compiled Code))
at com.ibm.db2.jcc.b.sf.a(sf.java(Compiled Code))
at com.ibm.db2.jcc.b.sf.executeQuery(sf.java(Compiled Code))
at psdi.mbo.MboSet.getNextRecordData(MboSet.java(Compiled Code))
at psdi.mbo.MboSet.fetchMbos(MboSet.java(Compiled Code))
at psdi.mbo.MboSet.getMbo(MboSet.java(Compiled Code))
at psdi.mbo.MboSet.isEmpty(MboSet.java(Compiled Code))
at psdi.app.signature.QuerySet.getQueriesForUser(QuerySet.java:70)
at
psdi.app.signature.SignatureService.getQueriesForUser(SignatureService.j
ava(Inlined Compiled Code))
at
psdi.app.signature.SignatureService.getUserAuthForApp(SignatureService.j
ava(Compiled Code))
at psdi.security.Profile.loadAppMaps(Profile.java(Compiled Code))
at psdi.security.Profile.getAppInfo(Profile.java(Compiled Code))
at
psdi.webclient.system.controller.AppInstance.<init>(AppInstance.java(Com
piled Code))
at
psdi.webclient.system.controller.RequestHandler.handleEvent(RequestHandl
er.java(Compiled Code))
...

Answer

Please run from DB2 command line the following statement

db2 bind @db2cli.lst collection NULL CLIPKG 30

This statement will BIND all db2 packages located in db2cli file and increase the number of sections for SQL statements.

Related Information

DB2

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
17 June 2018

UID

swg21451591

Page Feedback