Hi,
i tried scheduling a task in db2 but it gives me this error

SQL22221N The scheduler is not active. Reason code "1".

the parameter named 'sched_enable' in the admin config file is also set to 'ON', still giving the same error. if anybody had faced the same problem before, do let me know how it worked for you.

What DB2 version and OS?

Andy

What does it say in the Messages and Codes manual for that error?

its db2 version 8.1 and OS is windows

did you try restarting your db2 admin server.... that is the second resolution provided by IBM after SCHED_ENABLE thing which you have already done....

restarted the server also, still facing the same problem....

Yes..I too faced the same problem.IBM suggested that DAS or Tools Catalog might be corrupted. They asked me to re-configure the DAS and Tools catalog database(ie Droping and creating). After that it worked for me !!!

hi mohan,
I hope this solution will work for me also...but can you tell me how do I reconfigure the tools catalog database? The parameter TOOLSCAT_DB is assigned value DWCTRLDB, but I can find no database in any of my node with this name, so no issue of dropping it. and if i recreate it, m i supposed to create it with same name or....? I just have no idea about how to recreate tools catalog database.

Please try this command, if you dont have a DB name called DWCTRLDB

db2 "create tools catalog systools create new database DWCTRLDB".

After that stop and start the DAS.

thanks a lot...its working