使用 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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/27015256/viewspace-768650/