Results 1 to 14 of 14
  1. #1
    Join Date
    Jan 2009
    Posts
    153

    Unanswered: Task Center Error

    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

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What is your DB2 version and OS? What is the output of "db2 get admin cfg"?

    Andy

  3. #3
    Join Date
    Jan 2009
    Posts
    153
    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

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

  5. #5
    Join Date
    Jan 2009
    Posts
    153
    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

  6. #6
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    1) You only need to create one tools catalog per db2 admin (das).

    2) Look at the UPDATE ADMIN CFG command.

    Andy

  7. #7
    Join Date
    May 2009
    Posts
    2

    hi

    pattilatha panikku poyathu entina

  8. #8
    Join Date
    Dec 2009
    Posts
    62
    I'm having the same problem, but with different output from "get admin cfg", so restarted this thread.

    Windows 2008 Server on HP/Intel Xeon platform.
    Level DB2 v9.5.500.784
    Fix Pack "5"

    What was done before this error began to occur was only the reestart of the Server to accomplish SO update.
    After reboot, DB2 Server is working OK, receiving connections, recording on tables and also responding normally to queries. Control Center works fine, just Journal and Task Center respond with the error message below


    Thanks in advance for any info on this.

    Zevang

    ================================================== ==

    Error Message is:

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


    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.

    ==============================

    I already have the system tools db configured, as shown below:


    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) = SRIBSA01994614

    Java Development Kit Installation Path DAS (JDK_PATH) = AUTOMATIC (C:\Program
    Files\IBM\SQLLIB\java\jdk)
    Java Development Kit Installation Path DAS (JDK_64_PATH) = AUTOMATIC (C:\Prog
    ram Files\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) = ON
    SMTP Server (SMTP_SERVER) =
    Tools Catalog Database (TOOLSCAT_DB) = TOOLSDB
    Tools Catalog Database Instance (TOOLSCAT_INST) = DB2
    Tools Catalog Database Schema (TOOLSCAT_SCHEMA) = SYSTOOLS
    Scheduler User ID =

    Diagnostic error capture level (DIAGLEVEL) = 3

    ================================================== ==========
    Last edited by zevang; 08-17-12 at 15:00.

  9. #9
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Is there anything in db2diag.log? What is the output from "db2 list db directory"?

    Andy

  10. #10
    Join Date
    Dec 2009
    Posts
    62
    Thanks Andy.

    "list db directory" returns:


    db2 => list db directory

    System Database Directory
    Number of entries in the directory = 2

    Database 1 entry:
    Database alias = COSPJ
    Database name = COSPJ
    Local database directory = C:
    Database release level = c.00
    Comment =
    Directory entry type = Indirect
    Catalog database partition number = 0
    Alternate server hostname =
    Alternate server port number =

    Database 2 entry:
    Database alias = TOOLSDB
    Database name = TOOLSDB
    Local database directory = C:
    Database release level = c.00
    Comment =
    Directory entry type = Indirect
    Catalog database partition number = 0
    Alternate server hostname =
    Alternate server port number =

    db2 =>

    ================================================== ==============

    Recent entries in db2diag.log are:
    ...
    2012-08-21-06.36.08.455000-180 I10898620F375 LEVEL: Warning
    PID : 4160 TID : 5892 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    EDUID : 5892 EDUNAME: db2logmgr (TOOLSDB) 0
    FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3108
    MESSAGE : Started archive for log file S0010578.LOG.

    2012-08-21-06.36.08.455000-180 I10898997F498 LEVEL: Warning
    PID : 4160 TID : 5892 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    EDUID : 5892 EDUNAME: db2logmgr (TOOLSDB) 0
    FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3180
    MESSAGE : Completed archive for log file S0010578.LOG to
    E:\LOGARCHIVE\DB2\TOOLSDB\NODE0000\C0000000\ from
    E:\DB2\NODE0000\SQL00001\SQLOGDIR\NODE0000\.

    2012-08-21-06.36.10.311000-180 E10899497F475 LEVEL: Event
    PID : 4160 TID : 2588 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000 DB : TOOLSDB
    APPHDL : 0-46703 APPID: *LOCAL.DB2.120821093602
    AUTHID : DBA
    EDUID : 2588 EDUNAME: db2agent (idle) 0
    FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::TermDbConnect, probe:2000
    STOP : DATABASE: TOOLSDB : DEACTIVATED: NO

    2012-08-21-06.36.10.327000-180 I10899974F325 LEVEL: Error
    PID : 4928 TID : 4340 PROC : db2dasstm.exe
    INSTANCE: DB2 NODE : 000
    EDUID : 4340
    FUNCTION: DB2 Tools, DB2 administration server, DasCommNamedPipeAdapter::write, probe:10
    DATA #1 : signed integer, 4 bytes
    232

    2012-08-21-06.36.10.389000-180 E10900301F432 LEVEL: Info
    PID : 4160 TID : 5524 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000 DB : TOOLSDB
    EDUID : 5524 EDUNAME: db2loggr (TOOLSDB) 0
    FUNCTION: DB2 UDB, data protection services, sqlpgLoggrInitDelOldLog, probe:1440
    DATA #1 : <preformatted>
    Cleaning up logs from RenameArchNum 10578 to delLimit 10579.

    2012-08-21-06.36.16.973000-180 E10900735F475 LEVEL: Event
    PID : 4160 TID : 2588 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000 DB : TOOLSDB
    APPHDL : 0-46714 APPID: *LOCAL.DB2.120821093615
    AUTHID : DBA
    EDUID : 2588 EDUNAME: db2agent (TOOLSDB) 0
    FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:1000
    START : DATABASE: TOOLSDB : ACTIVATED: NO

    2012-08-21-06.36.18.502000-180 E10901212F475 LEVEL: Event
    PID : 4160 TID : 2588 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000 DB : TOOLSDB
    APPHDL : 0-46714 APPID: *LOCAL.DB2.120821093615
    AUTHID : DBA
    EDUID : 2588 EDUNAME: db2agent (idle) 0
    FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::TermDbConnect, probe:2000
    STOP : DATABASE: TOOLSDB : DEACTIVATED: NO

    2012-08-21-06.36.25.100000-180 E10901689F475 LEVEL: Event
    PID : 4160 TID : 2588 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000 DB : TOOLSDB
    APPHDL : 0-46719 APPID: *LOCAL.DB2.120821093621
    AUTHID : DBA
    EDUID : 2588 EDUNAME: db2agent (TOOLSDB) 0
    FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:1000
    START : DATABASE: TOOLSDB : ACTIVATED: NO

    2012-08-21-06.36.26.504000-180 E10902166F475 LEVEL: Event
    PID : 4160 TID : 2588 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000 DB : TOOLSDB
    APPHDL : 0-46719 APPID: *LOCAL.DB2.120821093621
    AUTHID : DBA
    EDUID : 2588 EDUNAME: db2agent (idle) 0
    FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::TermDbConnect, probe:2000
    STOP : DATABASE: TOOLSDB : DEACTIVATED: NO

    2012-08-21-06.36.33.166000-180 E10902643F475 LEVEL: Event
    PID : 4160 TID : 2588 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000 DB : TOOLSDB
    APPHDL : 0-46686 APPID: *LOCAL.DB2.120821093629
    AUTHID : DBA
    EDUID : 2588 EDUNAME: db2agent (TOOLSDB) 0
    FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:1000
    START : DATABASE: TOOLSDB : ACTIVATED: NO

    2012-08-21-06.36.34.476000-180 E10903120F475 LEVEL: Event
    PID : 4160 TID : 2588 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000 DB : TOOLSDB
    APPHDL : 0-46686 APPID: *LOCAL.DB2.120821093629
    AUTHID : DBA
    EDUID : 2588 EDUNAME: db2agent (idle) 0
    FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::TermDbConnect, probe:2000
    STOP : DATABASE: TOOLSDB : DEACTIVATED: NO

    2012-08-21-06.36.41.059000-180 E10903597F475 LEVEL: Event
    PID : 4160 TID : 2588 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000 DB : TOOLSDB
    APPHDL : 0-46730 APPID: *LOCAL.DB2.120821093637
    AUTHID : DBA
    EDUID : 2588 EDUNAME: db2agent (TOOLSDB) 0
    FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:1000
    START : DATABASE: TOOLSDB : ACTIVATED: NO

    2012-08-21-06.36.41.824000-180 I10904074F440 LEVEL: Error
    PID : 4928 TID : 4340 PROC : db2dasstm.exe
    INSTANCE: DB2 NODE : 000
    APPID : *LOCAL.DB2.120821093637
    EDUID : 4340
    FUNCTION: DB2 Tools, DB2 administration server, JobExecutionThread_run, probe:20
    DATA #1 : String, 22 bytes
    Scheduler RC = -22205
    DATA #2 : String, 10 bytes
    MD RC = 0
    DATA #3 : String, 12 bytes
    SQLCODE = 0

    2012-08-21-06.36.42.042000-180 I10904516F431 LEVEL: Info
    PID : 4160 TID : 5808 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000 DB : TOOLSDB
    EDUID : 5808 EDUNAME: db2loggr (TOOLSDB) 0
    FUNCTION: DB2 UDB, data protection services, sqlpghck, probe:1390
    DATA #1 : <preformatted>
    ExtNum 10579 state 10101 baselsn 0000001B66788000 nextlsn 0000001B66788589

    2012-08-21-06.36.42.073000-180 I10904949F375 LEVEL: Warning
    PID : 4160 TID : 5680 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    EDUID : 5680 EDUNAME: db2logmgr (TOOLSDB) 0
    FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3108
    MESSAGE : Started archive for log file S0010579.LOG.

    2012-08-21-06.36.42.089000-180 I10905326F498 LEVEL: Warning
    PID : 4160 TID : 5680 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    EDUID : 5680 EDUNAME: db2logmgr (TOOLSDB) 0
    FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3180
    MESSAGE : Completed archive for log file S0010579.LOG to
    E:\LOGARCHIVE\DB2\TOOLSDB\NODE0000\C0000000\ from
    E:\DB2\NODE0000\SQL00001\SQLOGDIR\NODE0000\.

    2012-08-21-06.36.44.008000-180 E10905826F475 LEVEL: Event
    PID : 4160 TID : 2588 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000 DB : TOOLSDB
    APPHDL : 0-46730 APPID: *LOCAL.DB2.120821093637
    AUTHID : DBA
    EDUID : 2588 EDUNAME: db2agent (idle) 0
    FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::TermDbConnect, probe:2000
    STOP : DATABASE: TOOLSDB : DEACTIVATED: NO

    2012-08-21-08.41.56.688000-180 I10906303F373 LEVEL: Warning
    PID : 4160 TID : 4348 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    EDUID : 4348 EDUNAME: db2logmgr (COSPJ) 0
    FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3108
    MESSAGE : Started archive for log file S0005586.LOG.

    2012-08-21-08.41.57.078000-180 I10906678F494 LEVEL: Warning
    PID : 4160 TID : 4348 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    EDUID : 4348 EDUNAME: db2logmgr (COSPJ) 0
    FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3180
    MESSAGE : Completed archive for log file S0005586.LOG to
    e:\logarchive\DB2\COSPJ\NODE0000\C0000000\ from
    E:\DB2\NODE0000\SQL00002\SQLOGDIR\NODE0000\.
    ...

    ================================================== ======

    Windows service "DB2DAS" is apparently running properly.
    Last edited by zevang; 08-21-12 at 11:47.

  11. #11
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Can you connect and access TOOLSDB directly? (not through Control Center)

    Andy

  12. #12
    Join Date
    Dec 2009
    Posts
    62
    I could do the following at the command line window:

    db2 => connect to toolsdb
    Database Connection Information

    Database server = DB2/NT64 9.5.5
    SQL authorization ID = DBA
    Local database alias = TOOLSDB

    db2 =>
    db2 => list tables
    Table/View Schema Type Creation time

    ------------------------------- --------------- ----- --------------------------


    0 record(s) selected.

    db2 => describe table systools.mdthistoryty00
    Data type Column
    Column name schema Data type name Length Scale N
    ulls
    ------------------------------- --------- ------------------- ---------- ----- -
    -----
    OBJECT_ID SYSIBM BIGINT 8 0 N
    ACL_ID SYSIBM BIGINT 8 0 N
    NAME SYSIBM VARCHAR 200 0 N
    ICM$OWNER SYSIBM VARCHAR 128 0 N
    ICM$CREATED_BY SYSIBM VARCHAR 128 0 N
    ICM$CREATED_TIME SYSIBM TIMESTAMP 10 0 N
    ICM$LAST_UPD_BY SYSIBM VARCHAR 128 0 N
    ICM$LAST_UPD_TIME SYSIBM TIMESTAMP 10 0 o
    ICM$APPLICATION SYSIBM BIGINT 8 0 N
    ICM$APP_READERS SYSIBM BIGINT 8 0 N
    ICM$APP_UPDATERS SYSIBM BIGINT 8 0 N
    TASKID00 SYSIBM BIGINT 8 0 N
    SUFFIX00 SYSIBM INTEGER 4 0 N
    TASKNAME00 SYSIBM VARCHAR 128 0 Y
    NOTIFICATIONRESULT00 SYSIBM CLOB 1000000000 0 Y
    RETRYCOUNT00 SYSIBM INTEGER 4 0 Y
    BYTECOUNT00 SYSIBM INTEGER 4 0 Y
    ROWCOUNT00 SYSIBM INTEGER 4 0 Y
    SUMMARYRETURNCODE00 SYSIBM VARCHAR 8448 0 Y
    RUNNINGSTATUS00 SYSIBM CHARACTER 1 0 Y
    START00 SYSIBM TIMESTAMP 10 0 Y
    END00 SYSIBM TIMESTAMP 10 0 Y
    DURATION00 SYSIBM INTEGER 4 0 Y
    RETURNCODE00 SYSIBM INTEGER 4 0 Y
    TOWNER00 SYSIBM VARCHAR 128 0 Y
    DWCSTEPID00 SYSIBM VARCHAR 128 0 Y
    JESJOBID00 SYSIBM VARCHAR 1000 0 Y
    EDITIONID00 SYSIBM VARCHAR 128 0 Y
    DESCRIPTION00 SYSIBM VARCHAR 1024 0 Y
    SOURCEDBNAME00 SYSIBM VARCHAR 8 0 Y
    SOURCEDBTYPE00 SYSIBM VARCHAR 3 0 Y
    TARGETDBNAME00 SYSIBM VARCHAR 8 0 Y
    TARGETDBTYPE00 SYSIBM VARCHAR 3 0 Y
    TARGETWAREHOUSENAME00 SYSIBM VARCHAR 8 0 Y
    FOLLOWONACTIONRESULT00 SYSIBM CLOB 10000000 0 Y
    JOURNALRESULT00 SYSIBM VARCHAR 16384 0 Y
    TASKHISTORYID00 SYSIBM BIGINT 8 0 N
    EXECUTIONSYSTEMID00 SYSIBM VARCHAR 256 YEXECUTIONPARTITIONID00 SYSIBM VARCHAR 256 Y
    TASKTYPE00 SYSIBM CHARACTER 1 0 Y
    INVOCATIONMETHOD00 SYSIBM CHARACTER 1 Y
    USERID00 SYSIBM VARCHAR 128 0 Y
    SHOWRESULTSPANELCLASSNAME00 SYSIBM VARCHAR 256 Y
    ROOTTASKHISTORYID00 SYSIBM BIGINT 8 0 N
    SCRIPTCONTENT00 SYSIBM CLOB 1000000000 0 Y
    TASKCATEGORY00 SYSIBM VARCHAR 2048 0 Y
    V7JOBID00 SYSIBM INTEGER 4 0 Y

    47 record(s) selected.



    db2 => select object_id, name from systools.mdthistoryty00

    OBJECT_ID NAME
    -------------------- ------------------------------------------------------
    18255 Name1341115281145
    18261 Name1341118881266
    18267 Name1341119781168
    18273 Name1341120681241
    18279 Name1341121581892
    18285 Name1341122480623
    18291 Name1341123380790
    18297 Name1341124281378
    18303 Name1341125179876
    18309 Name1341126080027
    18315 Name1341126981067
    18321 Name1341127880891
    18324 Name1341128786564
    18333 Name1341129079174
    ...


    I tried and could remotely access the Task Center and Journal using DB2 Client at my Workstation machine.
    Last edited by zevang; 08-21-12 at 14:37.

  13. #13
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    I think you need to contact IBM support to figure this one out.

    Andy

  14. #14
    Join Date
    Dec 2009
    Posts
    62
    Andy,
    Thanks for the effort ;-)
    Will do.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •