Hi All:
It look like I have posted this question in the wrong Forum.
So I put it here. If anybody knows every thing pls. help.

I have WSE UDB V8.1.3 for Windows. Im getting this error: "Error SQL22282N, Reason Code:5, SQLCODE -567". when trying to create/update a task in the Task Center.
I have checked all the variables in ADMIN CFG and they seem to be right.

(SCHED_ENABLE) = ON
(TOOLSCAT_DB) = TOOLS_DB
(TOOLSCAT_INST) = DB2
(TOOLSCAT_SCHEMA) = CATOOLS

I have created ToolsDB as a separate database. I have heard that this can be created into an existing database. I don't know if it will make some difference.

My questions:
a) How can I solve this error.
b) One more thing to test: How can I set the "Scheduler User ID" using the "setschedid" param?. I have tried to set it as the Command Reference says but I still get some syntax error.

Thanks....

hi,
please, check your db2diag.log and lookup for another errores.
the rc 5 is a consequence of another error.

abel.

567 is an authorization error
are you dba ?
can you change the job : are you the owner ?
no problem when creating the job : only update ?
the sched id is not needed - see db2 doc : only for remote scheduling ..
Hope this will help
Regards, Guy Przytula

Yes.

It was authorization error.

Thanks Przytula.