I'm running DB2 Express-C on a Server 2003 box acting as an additional
domain controller in our small domain.

I'm trying to create a simple task to connect to a database, call a
stored procedure and the disconnect.

I've made the task OK, but whenever I try to run the task I get the
following email:

The task MYSCHEMA.MyTaskName with status Not successful ran on the DB2
Administrative Server on dbserver.mydomain.local and completed with
return code -22201. The task started on dbserver(0) at 2008-02-08
11:17:58.0 and completed at 2008-02-08 11:17:59.0. The task lasted 1
seconds.

SQL22201N seems to do with user authentication, but I've tried
multiple user accounts, verified each of their passwords and still no
luck.

Any ideas???

On Feb 8, 1:38 pm, Mesan <935m...@gmail.com> wrote:
> I'm running DB2 Express-C on a Server 2003 box acting as an additional
> domain controller in our small domain.
>
> I'm trying to create a simple task to connect to a database, call a
> stored procedure and the disconnect.
>
> I've made the task OK, but whenever I try to run the task I get the
> following email:
>
> The task MYSCHEMA.MyTaskName with status Not successful ran on the DB2
> Administrative Server on dbserver.mydomain.local and completed with
> return code -22201. The task started on dbserver(0) at 2008-02-08
> 11:17:58.0 and completed at 2008-02-08 11:17:59.0. The task lasted 1
> seconds.
>
> SQL22201N seems to do with user authentication, but I've tried
> multiple user accounts, verified each of their passwords and still no
> luck.
>
> Any ideas???

I'm assuming you're using the DB2 Task Center. Are you able to get
any tasks to run immediately? Each task has a security and by default
only the task creator is able to execute the task. When you edit a
task the last tab is the security tab. If you schedule the task to
run, the userid must have execute rights in the security tab.

HTH,
Norm