ITPub博客

首页 > Linux操作系统 > Linux操作系统 > db2 DBA1176N The Control Center failed

db2 DBA1176N The Control Center failed

原创 Linux操作系统 作者:longan_plot 时间:2013-08-16 10:45:39 0 删除 编辑
使用 db2ca 里的task center 新建时报错如下:
DBA1176N  The Control Center failed to automatically catalog the 
Tools Catalog Database "" for system "LINUX-DB2".
Explanation: 

Possible explanations are: 
*  The database is specified incorrectly at the DB2 Administration
   Server for system "".
*  The database manager that contains the database is not configured for
   TCP/IP communication.

User response: 

Possible solutions include: 
*  Verify that the DB2 Administration Server configuration parameters
   are correctly specified.
*  Verify that the database manager is configured for TCP/IP
   communications.

db2 version: DB2 v9.7.0.7
os version:linux 6.1
检查admin cfg
db2inst1@linux-db2 ~]$ db2 get admin cfg

            Admin Server Configuration

 Authentication Type DAS                (AUTHENTICATION) = SERVER_ENCRYPT

 DAS Administration Authority Group Name  (DASADM_GROUP) = dasadm1

 DAS Discovery Mode                           (DISCOVER) = SEARCH
 Name of the DB2 Server System               (DB2SYSTEM) = LINUX-DB2

 Java Development Kit Installation Path DAS   (JDK_PATH) = AUTOMATIC (/home/dasusr1/das/java/jdk)
 Java Development Kit Installation Path DAS   (JDK_64_PATH) = AUTOMATIC (/home/dasusr1/das/java/jdk)

 DAS Code Page                            (DAS_CODEPAGE) = 0
 DAS Territory                           (DAS_TERRITORY) = 0

 Location of Contact List                 (CONTACT_HOST) = 
 Execute Expired Tasks                   (EXEC_EXP_TASK) = NO
 Scheduler Mode                           (SCHED_ENABLE) = OFF
 SMTP Server                               (SMTP_SERVER) = 
 Tools Catalog Database                    (TOOLSCAT_DB) = 
 Tools Catalog Database Instance         (TOOLSCAT_INST) = 
 Tools Catalog Database Schema         (TOOLSCAT_SCHEMA) = 
 Scheduler User ID                                       = 

 Diagnostic error capture level              (DIAGLEVEL) = 3
由红色部分说明没有创建“工具目录数据库”,工具目录详细说明如下:
http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2Fcom.ibm.db2.luw.admin.gui.doc%2Fdoc%2Ft0008695.html&lang%3Dzh_CN
创建工具目录数据库:
[db2inst1@linux-db2 ~]$ db2 CREATE TOOLS CATALOG ADMINISTRATOR USE EXISTING DATABASE SAMPLE   --SAMPLE是数据库名称
DB20000I  The CREATE TOOLS CATALOG command completed successfully.
[db2inst1@linux-db2 ~]$ db2 get admin cfg

            Admin Server Configuration

 Authentication Type DAS                (AUTHENTICATION) = SERVER_ENCRYPT

 DAS Administration Authority Group Name  (DASADM_GROUP) = dasadm1

 DAS Discovery Mode                           (DISCOVER) = SEARCH
 Name of the DB2 Server System               (DB2SYSTEM) = LINUX-DB2

 Java Development Kit Installation Path DAS   (JDK_PATH) = AUTOMATIC (/home/db2inst1/sqllib/java/jdk64)
 Java Development Kit Installation Path DAS   (JDK_64_PATH) = AUTOMATIC (/home/db2inst1/sqllib/java/jdk64)

 DAS Code Page                            (DAS_CODEPAGE) = 0
 DAS Territory                           (DAS_TERRITORY) = 0

 Location of Contact List                 (CONTACT_HOST) = 
 Execute Expired Tasks                   (EXEC_EXP_TASK) = NO
 Scheduler Mode                           (SCHED_ENABLE) = ON
 SMTP Server                               (SMTP_SERVER) = 
 Tools Catalog Database                    (TOOLSCAT_DB) = SAMPLE
 Tools Catalog Database Instance         (TOOLSCAT_INST) = db2inst1
 Tools Catalog Database Schema         (TOOLSCAT_SCHEMA) = ADMINISTRATOR
 Scheduler User ID                                       = 

 Diagnostic error capture level              (DIAGLEVEL) = 3

[db2inst1@linux-db2 ~]$ db2level
DB21085I  This instance or install (instance name, where applicable: 
"db2inst1") uses "64" bits and DB2 code release "SQL09077" with level 
identifier "08080107".
Informational tokens are "DB2 v9.7.0.7", "s121002", "IP23374", and Fix Pack 
"7".
Product is installed at "/opt/ibm/db2/V9.7".

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/27015256/viewspace-768650/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2013-07-24

  • 博文量
    22
  • 访问量
    224655