Scheduling a Task

[database_guy]

I am getting the following error when trying to run or schedule a
task. Please see below. There are more error explanations and I did
not put all of them because I believe it to be one of the 1st few.
Anyway, when I make a change in the task and click OK, the message
pops up and I then hit Cancel but when I go directly back into the
task, my change is there but the task will not run. I looked at the
admin configuration and I notice that I have no entry for the
Scheduler User ID but it does not list a variable for me to add one.
ANYONE, please help?????

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

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

[Richard Page]

Try to issue the db2admin setid command with an administrator id. The
scheduler id can also be set with the db2admin setschedid command but this
is normally used when the tools catalog is not local to your system.

"database_guy" <ps******@yahoo.com> wrote in message
news:95**************************@posting.google.c om...

I am getting the following error when trying to run or schedule a
task. Please see below. There are more error explanations and I did
not put all of them because I believe it to be one of the 1st few.
Anyway, when I make a change in the task and click OK, the message
pops up and I then hit Cancel but when I go directly back into the
task, my change is there but the task will not run. I looked at the
admin configuration and I notice that I have no entry for the
Scheduler User ID but it does not list a variable for me to add one.
ANYONE, please help?????

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

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

[Wesley Gibbs]

Phillip,

I got the task working... I'll let you know on Monday...

Wes

"Richard Page" <rg****@ca.ibm.com> wrote in message news:<bu**********@hanover.torolab.ibm.com>...

Try to issue the db2admin setid command with an administrator id. The
scheduler id can also be set with the db2admin setschedid command but this
is normally used when the tools catalog is not local to your system.

"database_guy" <ps******@yahoo.com> wrote in message
news:95**************************@posting.google.c om...

I am getting the following error when trying to run or schedule a
task. Please see below. There are more error explanations and I did
not put all of them because I believe it to be one of the 1st few.
Anyway, when I make a change in the task and click OK, the message
pops up and I then hit Cancel but when I go directly back into the
task, my change is there but the task will not run. I looked at the
admin configuration and I notice that I have no entry for the
Scheduler User ID but it does not list a variable for me to add one.
ANYONE, please help?????

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

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