任务中心无法显示任务列表

gong_yue 2008-05-29 03:07:24
各位高手,任务中心部署了若干DB2后台任务,主要是备份和导数。一直运行正常。今日通过图形界面进入任务中心后,发现不能显示之前的任务列表了。系统报如下错误:
ICM0035N 当装入存取控制列表时发生了 SQL 错误。
[IBM][CLI Driver][DB2/NT] SQL1476N 由于错误 "-433",当前事务已回滚。
SQLSTATE=40506




解释:

当“信息目录管理器 API”在装入 IBM DB2
通用数据库工具目录的存取控制列表中的信息时发生了 SQL 错误。

用户响应:

有关此 SQL 错误的更多信息,查看《消息参考》。
请问有哪位仁兄能解决啊??
...全文
267 3 打赏 收藏 转发到动态 举报
写回复
用AI写文章
3 条回复
切换为时间正序
请发表友善的回复…
发表回复
huoyin 2008-05-31
  • 打赏
  • 举报
回复
SQL1476N The current transaction was rolled back because of error sqlcode .
Explanation:
The transaction was rolled back because:

An implicit or explicit CLOSE CURSOR failed, or
A table was being created with the NOT LOGGED INITIALLY option, or NOT LOGGED INITIALLY was activated for an existing table. During the same unit of work, either an error occurred, or a ROLLBACK TO SAVEPOINT statement was issued. This unit of work is rolled back, with the following effects:
any table that was created in this unit of work is dropped.
any NOT LOGGED INITIALLY tables that were activated in the transaction are marked inaccessible, and can only be dropped.
the sqlcode will be 0 if a ROLLBACK TO SAVEPOINT was issued in the transaction.
A rollback to savepoint failed or release savepoint failed.
User Response:
Correct the problem as indicated by the error sqlcode , then run the transaction again. Remove any ROLLBACK TO SAVEPOINT statement that is used in the same transaction in which a NOT LOGGED INITIALLY table is created or activated.

sqlcode : -1476

sqlstate : 40506

songfrh 2008-05-30
  • 打赏
  • 举报
回复
是不是使用了 NOT LOGGED INITIALLY
删除掉
DongloveRen 2008-05-30
  • 打赏
  • 举报
回复
sf

5,889

社区成员

发帖
与我相关
我的任务
社区描述
IBM DB2 是美国IBM公司开发的一套关系型数据库管理系统,它主要的运行环境为UNIX(包括IBM自家的AIX)、Linux、IBM i(旧称OS/400)、z/OS,以及Windows服务器版本
社区管理员
  • DB2
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧