That was exactly it. I had the service start with the administrator account.
Thanks a lot.
Fabio
DAVID NUNNS D13 wrote:
--- Received from GA.DNUNN2 791 6069 01-03-04 13.38
-> [EMAIL PROTECTED]
Fabrio,
As you know -567 is: SQL0567N authorization-ID is not a valid authorization ID
I have had similiar problems on NT when behind the scenes it was using the default userid SYSTEM, which is invalid to DB2 as it begins with SYS.
I would double check that the DAS is using a reasonable userid (such as db2admin), and that the instances are using one as well (do this from Start/Settings/Control Panel/Services/ select the DAS service and select
startup, this indicates what userid it is running under).
David Nunns Norwich Union
------------------------------------------------------------------------
From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Date: Mon, 1 Mar 2004 09:06:58 -0300 Subject: [DB2EUG] Error Creating tasks
Hi,
I have recently migrated from DB2 V5.2 to DB2 8.1 Express. After the migration I created a tools catalog in an existing Database. When I try to create any type of task in the task center or try to schedule a Database backup I get the follwing error:
SQL22282N 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.
I am logged in as DB2ADMIN and have looked at all the possibilities the error gives, but everything is fine. I�ve migrated 10 different database and all but one give this errors. Does anyone have any suggestions?
Thanks in advance,
Fabio
-- Fabio Pasquali Gerente de Inform�tica Supermaia Supermercados Ltda. Tel: 55 (61) 242-4242 R:211 Fax: 55 (61) 242-4205 E-mail: [EMAIL PROTECTED]
- ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
Norwich Union, an Aviva company, is authorised and regulated by the Financial Services Authority.
This E-mail transmission may contain confidential or legally privileged
information that is intended for the addressee only. Any views or
opinions presented are solely those of the author and do not
necessarily represent those of Norwich Union.
If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or reliance upon the contents of this E-mail is strictly prohibited.
If you have received this E-mail transmission in error, please notify the sender immediately, so that Norwich Union may arrange for its proper delivery. Please then delete the message from your inbox.
--
Fabio Pasquali
Gerente de Inform�tica
Supermaia Supermercados Ltda.
Tel: 55 (61) 242-4242 R:211 Fax: 55 (61) 242-4205
E-mail: [EMAIL PROTECTED]
- ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
