Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2002
    Posts
    25

    Red face Unanswered: task in db2 v8.1.2

    The Task Center was working correctly, but soon it changes the configuration of of db2 of the following way:

    DB2 UPDATE DBM CFG USING SYSCTRL_GROUP SYSCTRL

    DB2 UPDATE DBM CFG USING SYSADM_GROUP SYSADM

    and now when I want to execute a task of Task Center shows the following error:

    The scheduler is unable to access the Tools Catalog Database.
    Reason code = "5" and SQLCODE "-567".

    Explanation:

    The scheduler function cannot be processed because the scheduler
    is unable to access the Tools Catalog Database for the reason
    specified by the "<reason-code>" as follows:

    1. The given user ID, or password, is incorrect.

    2. Incorrect Tools Catalog Database configuration in the DB2
    Administration Server configuration parameters. One or more
    of the following DB2 Administration Server configuration
    parameters is incorrect:

    - TOOLSCAT_DB

    - TOOLSCAT_SCHEMA

    3. The Tools Catalog Database is already being used by another
    scheduler on the same system.

    4. The Tools Catalog Database is only supported through TCP/IP
    as a communication protocol.

    5. Unexpected errors. Refer to SQLCODE "<sqlcode>" for more
    details.

    User Response:

    The action corresponding to the reason code is:

    1. Check your user ID and password and try again.

    2. Verify that the DB2 Administration Server TOOLSCAT_DB and
    TOOLSCAT_SCHEMA configuration parameters have been set
    correctly. View the current settings of TOOLSCAT_DB and
    TOOLSCAT_SCHEMA using the GET ADMIN CONFIGURATION command.
    To modify the value of any DB2 Administration Server
    configuration parameter, use the UPDATE ADMIN CONFIGURATION
    command. If you continue to receive this error message after
    attempting the suggested response, please contact IBM
    Support.

    3. Contact your system administrator.

    4. Attempt the following:

    - If the tools catalog database is local to the scheduler, then
    set up the instance specified by the DB2 Administration
    Server configuration parameter toolscat_inst to use
    TCP/IP communications.

    - If the tools catalog database is remote to the scheduler,
    then ensure that the node used by the toolscat_db admin
    configuration parameter supports TCP/IP as the
    communication protocol.

    5. Refer to the DB2 Administration Server's First Failure Data
    Capture Log for additional information.

    Contact IBM Support if you continue to receive this message
    after attempting the suggested solutions.

  2. #2
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    Elaborate

    Hi,

    Please elaborate did you do the changes manually. Secondly, what is your operating system. Are you facing the problem since the start or is it afer the changes.
    HTH

    Nitin

    Ask the experienced rather than the learned

  3. #3
    Join Date
    Dec 2002
    Posts
    25

    Unhappy Re: Elaborate

    the operating system is Windows 2000 advance server and the Task Center was working well, but after of the changes this does not work and each you see I want to execute a task from the Task Center leaves that error to me...

  4. #4
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    Drop and Recreate

    Hi,

    I feel the best alternative is to drop and recreate your toolsdb.

    That should help.
    HTH

    Nitin

    Ask the experienced rather than the learned

Posting Permissions

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