This document applies only to the following language version(s):
English
QuestionHow to resolve DB2 sql -805 errror
CauseThe 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))
...
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.
添加新评论0 条评论