HI Experts,

I am getting below given error when i try to select Task Center in Control Center.

DBA1176N The Control Center failed to automatically catalog the
Tools Catalog Database "" for system "CY1274".


Explanation:

Possible explanations are:
* The database is specified incorrectly at the DB2 Administration
Server for system "<system-name>".
* 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.

If the problem persists, contact IBM Support.


Thanks & Regards
Ratheesh.K.Nair

What is your DB2 version and OS? What is the output of "db2 get admin cfg"?

Andy

DB2 VERSION:9.5c Express
OS VERSION:Windows XP

got the result

db2 => get admin cfg

Admin Server Configuration

Authentication Type DAS (AUTHENTICATION) = SERVER_ENCRYPT

DAS Administration Authority Group Name (DASADM_GROUP) =

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

Java Development Kit Installation Path DAS (JDK_PATH) = AUTOMATIC (D:\Program
s\IBM\SQLLIB\java\jdk)
Java Development Kit Installation Path DAS (JDK_64_PATH) = AUTOMATIC (D:\Prog
rams\IBM\SQLLIB\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) = 2

First you need to create the tools catalog. Look here for details:

IBM DB2 9.5 Information Center for Linux, UNIX, and Windows

Then you need to set the admin cfg for:

Tools Catalog Database (TOOLSCAT_DB) =
Tools Catalog Database Instance (TOOLSCAT_INST) =
Tools Catalog Database Schema (TOOLSCAT_SCHEMA) =

Andy

Thanks Andy..

Do i need to run
CREATE TOOLS CATALOG ADMINISTRATOR USE EXISTING DATABASE DB1;
for each and every database?


How to set the admin cfg for:

Tools Catalog Database (TOOLSCAT_DB) =
Tools Catalog Database Instance (TOOLSCAT_INST) =
Tools Catalog Database Schema (TOOLSCAT_SCHEMA) =


TIA

1) You only need to create one tools catalog per db2 admin (das).

2) Look at the UPDATE ADMIN CFG command.

Andy

pattilatha panikku poyathu entina