db2 DBA1176N The Control Center failed

longan_plot發表於2013-08-16
使用 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
由紅色部分說明沒有建立“工具目錄資料庫”,工具目錄詳細說明如下:
%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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章