If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Task Center Error

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-02-04, 11:31
JDionne JDionne is offline
Registered User
 
Join Date: Aug 2002
Location: Charlotte NC
Posts: 663
Task Center Error

I am running DB2 Enterprise Eddition Version 8 with no fix paks( Im D/L Fixpak 5 as we type) Im running on Windows 2003 server with no Service pack (dont know that there is one yet) Every time I try to schedual a task through the controle center I get the following error.
SQL22282N The scheduler is unable to access the Tools Catalog Database. Reason code = "1" and SQLCODE "-567".

I have gone through the help and made sure the schema is asociated with the instance and the right database is set up. I have made sure that my id was in the admin group with both databases (the tools DB and the DB im tring to schedual a task for). Im lost at this point. Im new to DB2 so I know its probably something very simple. Any help would be great.
Jim
Reply With Quote
  #2 (permalink)  
Old 04-03-04, 01:01
Tank Tank is offline
Registered User
 
Join Date: Feb 2004
Location: Copenhagen
Posts: 220
Re: Task Center Error

Have you checked the admin cfg variables
to see if they are pointing to the correct
toolsdb and toolscatalog?

BOW
__________________
Kristian K. Hansen
Project Supervisor
National Board of Health
Reply With Quote
  #3 (permalink)  
Old 04-03-04, 01:52
chansteve1234 chansteve1234 is offline
Registered User
 
Join Date: Sep 2003
Posts: 27
If u have not create the tools catalog, use following command to create
create tools catalog <catalog name> use existing tablespace <a 32 k tablespace> in database <db name> force

You should create one 32k system temp tablespace also.

If u have created the tools catalog, make sure u have set following parameter with following cmmand,

db2 -v update admin cfg using sched_enable on
db2 -v update admin cfg using toolscat_inst <yr instance name>
db2 -v update admin cfg using toolscat_db <database which have tools catalog>
db2 -v update admin cfg using toolscat_schema <schema which have tools catalog>
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On