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

答案:3 悬赏:10 手机版

解决时间 2021-11-11 14:19

提问者网友：树红树绿
2021-11-11 03:35

最佳答案

五星知识达人网友：天凉才是好个秋
2021-11-11 04:13

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.

全部回答

1楼网友：末日狂欢
2021-11-11 07:00

-805 51002 在计划中没有发现DBRM或程序包名

2楼网友：一秋
2021-11-11 05:51

SQL0805N Package "" 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}]

我要举报

如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！