MVSFORUMS.com

[Okonita]

When attempting to schedule a task in DB2, I get an error that tells me that the DB2 scheduler is not active or is not properly configured. Any assistance that you can give me in resolving this issue will be greatly appreciated. Thanks.

Edited by the moderator to merge the duplicate posts.


Additional info: DB2 scheduler problem: SQL22221N
SQL22221N The scheduler is not active. Reason code "1".

Explanation:

The scheduler was unable to handle the request because the scheduler is not active for one of the following reasons;
1 The scheduler is not enabled
2 The scheduler is not configured properly

Any help to resolve this issue will be highly appreciated.

[kolusu]

Okonita,

Please post any additional info in the same tpoic. Please do not create more than 1 topic for the same question. This forum is basically dedicated to mainframe related questions. Your questions is windows related. I am deleting the new topic with additional info and transforming the contents into the old post . I haven't worked much on DB2 for windows. I have searched for the error and this is what I got.

Verify that the scheduler has been enabled. The scheduler is enabled using the SCHED_ENABLE DB2 Administration Server configuration parameter. Verify the current setting of the SCHED_ENABLE parameter by viewing the DB2 Administration Server configuration parameters using the GET ADMIN CONFIGURATION command. To modify the value of any configuration parameter, use the UPDATE ADMIN CONFIGURATION command.

Also check that the windows scheduler service. look under Scheduled tasks and you should find MSTask.exe. Click on the properties and make it Auto-start

Also you might find some helpful tips from the following link.

http://iibm01.inf.uni-jena.de/db2v8doku/index.htm


Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu