DB2定时执行任务的错误

wewi

DB2 ESE 安装没有错误，使用环境为redhat  as3 , ibm java2-1.4.1,db2 ese 8.1未加补丁, 在使用过程中发现有问题，碰到的朋友一起讨论一下如何解决：

现象：在进行数据备份设置的时候，发现如果选择定时执行任务，想要自己设定repeating schedule的时候，一点这个schedule窗口就死，鼠标可以移动但单击无反应。如果选认添加任务并立即执行可以操作，但在任务中也不能修改，提示错误如下：

1177N  A database connection to the Tools Catalog Database
"TOOLSDB" cannot be made. SQLCODE "40003"
ICM00001N  An SQL error occurred while connecting to the
database.  Database = "TOOLSDB", Catalog = "SYSTOOLS".
[IBM][CLI Driver] CLI0108E  Communication link failure.
SQLSTATE=40003


Explanation:

A database connection to the Tools Catalog Database
"<database-name>" cannot be made. SQLCODE "<sqlcode>"

User Response:

Refer to the user response for the SQLCODE returned from the
connect operation.  

另外终端显示
java.lang.VerifyError: (class: com/ibm/db2/common/xmlutils/xmlserializer/XMLSerializerDriver, method: XMLRead signature: (Ljava/io/InputStream;)Ljava/lang/Object;) Incompatible object argument for method call
        at com.ibm.db2.tools.taskcenter.NotificationMessage.getContentsAsByteArray(Unknown Source)
        at com.ibm.db2.tools.taskcenter.NotificationMessage.initializeDefaultNotificationText(Unknown Source)
        at com.ibm.db2.tools.taskcenter.NotificationMessage.setMessageToDefaultText(Unknown Source)
        at com.ibm.db2.tools.taskcenter.NotificationMessage.getDefaultMessage(Unknown Source)
        at com.ibm.db2.tools.taskcenter.NotificationActionsPanel.<init>(Unknown Source)
        at com.ibm.db2.tools.taskcenter.NewTaskDialog.createNotebook(Unknown Source)
        at com.ibm.db2.tools.taskcenter.NewTaskDialog.makeLayout(Unknown Source)        at com.ibm.db2.tools.taskcenter.NewTaskDialog.initInThread(Unknown Source)
        at com.ibm.db2.tools.taskcenter.NewTaskDialog.initialize(Unknown Source)        at com.ibm.db2.tools.taskcenter.NewTaskDialog.<init>(Unknown Source)
        at com.ibm.db2.tools.taskcenter.TaskCenterNewTaskDialog.<init>(Unknown Source)
        at com.ibm.db2.tools.taskcenter.EditTaskPropertiesAction.actionPerformed(Unknown Source)
        at com.ibm.db2.tools.common.CommonMenu$RunAction.run(Unknown Source)
        at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:205)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:529)
        at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:238)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:182)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:176)        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)        at java.awt.EventDispatchThread.run(EventDispatchThread.java:131)

wewi

图

gmcj

第一个问题是因为你没有建tools catalog table,因为做schedule需要这个数据库.查看一下手册,上面有具体的解释,大致的语法为:
CREATE TOOLS CATALOG ...

由于RHEL内部的一个问题,所以对IBM DB2的支持有问题,具体解释和解决方法请看这里吧:
http://www-306.ibm.com/software/ ... e/rhel3faq.html#a14