当前位置:数据库 > DB2 >>

DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC: NULLID.SYSLH203 0X5359534C564C3031

2011-10-08 09:42:21,817 ERROR pool-1-thread-12 - com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC: NULLID.SYSLH203 0X5359534C564C3031 at com.ibm.db2.jcc.c.fg.e(fg.java:1596) at com.ibm.db2.jcc.b.gb.o(gb.java:747) at com.ibm.db2.jcc.b.gb.g(gb.java:143) at com.ibm.db2.jcc.b.gb.a(gb.java:39) at com.ibm.db2.jcc.b.w.a(w.java:34) at com.ibm.db2.jcc.b.vb.g(vb.java:139) at com.ibm.db2.jcc.c.fg.n(fg.java:1177) at com.ibm.db2.jcc.c.fg.a(fg.java:1832) at com.ibm.db2.jcc.c.fg.a(fg.java:473) at com.ibm.db2.jcc.c.fg.executeQuery(fg.java:457) at com.sunyard.etp.ag.transSteps.delimeter.TransStep80000000009618.execute(TransStep80000000009618.java:54) at com.sunyard.cbif.etp.base.TransactionStep.doTransAction(SourceFile:174) at com.sunyard.cbif.etp.base.TransactionFlow.execute(SourceFile:406) at com.sunyard.cbif.etp.base.TransactionFlow.execute(SourceFile:644) at com.sunyard.cbif.cbi.tcpip.TCPIPChannelRequestHandler.runNoSessionTransactionFlow(SourceFile:194) at com.sunyard.cbif.cbi.tcpip.TCPIPChannelRequestHandler.runTransactionFlow(SourceFile:153) at com.sunyard.cbif.cbi.base.AbstractChannelRequestHandler.handleChannelRequest(SourceFile:64) at com.sunyard.cbif.cbi.tcpip.AbstractTCPIPInputHandler.tcpipChannelDo(SourceFile:443) at com.sunyard.cbif.cbi.tcpip.AbstractTCPIPInputHandler.processOutput(SourceFile:487) at com.sunyard.cbif.etp.services.tcpip.TCPIPReadHandlerThread.run(SourceFile:120) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:651) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:676) at java.lang.Thread.run(Thread.java:595)
答案:Your databases has only 3 packages of this kind. 
They are SYSLH200,201,202. 
But your query requires one more additional package SYSLH203. If you are a DBA, go to SQLLIB/BND directory then issue the following command 

db2 bind @db2cli.lst blocking all grant public sqlerror continue CLIPKG 5 

If you are application programmer, contact your DBA to perform above bind. You can bind upto CLIPKG 30.
其他:-805 51002 在计划中没有发现DBRM或程序包名 SQL0805N Package "<package-name>" was not found.
Explanation:
The statement cannot complete because the necessary package was not found in the catalog.
包 NULLID.SYSLH203 在系统中找不到,重新绑定一下。语法如下;
REBIND [PACKAGE] package-name [VERSION version-id]
[RESOLVE {ANY | CONSERVATIVE}] [REOPT {NONE | ONCE | ALWAYS}] 

上一个:db2的SQL问题
下一个:从Linux备份DB2数据库到AIX上怎么恢复?

Oracle
MySQL
Access
SQLServer
DB2
Excel
SQLite
SYBASE
Postgres
如果你遇到数据库难题:
请访问www.zzzyk.com 试试
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,