Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2012
    Posts
    12

    Unanswered: Tools Catalog Database - Failed to create Task

    Hi All,

    We have db2 9.7 with IBM Maximo v7.1 running.

    There is on issue while creating a new task(for offline backup) in Task Center.

    Steps-Create new task (for offline backup)
    >> open the Task Center
    >> Open the current backup task, and type SQL Script in tab Script
    >> configure offline line schedule
    >> Under security tab, there are users accounts configured 'Administrator'
    and DB2admin

    Issue:
    In Task Center, while creating a new Task which fails with error message:
    SQL22283N Task '1.0' does not exist in the Tools Catalog Database.


    DB2diag.log entry:

    2013-07-25-11.00.15.774000+180 E1858290F475 LEVEL: Event
    PID : 5828 TID : 7592 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000 DB : TOOLSDB
    APPHDL : 0-4831 APPID: *LOCAL.DB2.130725080816
    AUTHID : DB2ADMIN
    EDUID : 7592 EDUNAME: db2agent (TOOLSDB) 0
    FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:1000
    START : DATABASE: TOOLSDB : ACTIVATED: NO

    2013-07-25-11.00.16.236000+180 E1858767F475 LEVEL: Event
    PID : 5828 TID : 7592 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000 DB : TOOLSDB
    APPHDL : 0-4831 APPID: *LOCAL.DB2.130725080816
    AUTHID : DB2ADMIN
    EDUID : 7592 EDUNAME: db2agent (idle) 0
    FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::TermDbConnect, probe:2000
    STOP : DATABASE: TOOLSDB : DEACTIVATED: NO


    Kindly help me how to fix it.

    Regards
    Shah

  2. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hi Shah,

    Which account do you use to run DAS Windows Service?
    Does this user have DBADM authority in TOOLSDB?
    Regards,
    Mark.

  3. #3
    Join Date
    Aug 2010
    Location
    Singapore
    Posts
    197
    Does TOOLSDB exist ? if not please create it
    - Ananth
    DB2 DBA LUW
    "coming second, just means you are the first loser"

  4. #4
    Join Date
    Apr 2012
    Posts
    12
    Hi All,

    Issue fixed after granting privilege;

    DB2 GRANT DBADM WITH DATAACCESS WITH ACCESSCTRL ON DATABASE TO USER db2admin

    There was already Toolsdb created, I was creating backup task by db2admin but only privilege was missing from db2admin.

    Thanks Mark and Ananth for your nice cooperation.

    Regards
    Shah

Posting Permissions

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