Results 1 to 4 of 4
  1. #1
    Join Date
    May 2004
    Posts
    25

    Unanswered: Error SQL22282N when scheduling a Task.

    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....

  2. #2
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276
    hi,
    please, check your db2diag.log and lookup for another errores.
    the rc 5 is a consequence of another error.

    abel.

  3. #3
    Join Date
    Nov 2004
    Posts
    374

    schedule

    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
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

  4. #4
    Join Date
    May 2004
    Posts
    25
    Yes.

    It was authorization error.

    Thanks Przytula.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •