Dear all,
I am using DB2 8.2 on Windows. We have some procedure scheduled thru Task
Center,
the jobs were running fine but since last night no job is running.
When I try to run the job manually it gives the error message -
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.
I checked the SCHED_ENABLE and it is set to ON.
ADMIN CONFIGURATION
Admin Server Configuration
----------------------------------------------
Authentication Type DAS (AUTHENTICATION) = SERVER_ENCRYPT
DAS Administration Authority Group Name (DASADM_GROUP) =
DAS Discovery Mode (DISCOVER) = SEARCH
Name of the DB2 Server System (DB2SYSTEM) = MYDB
Java Development Kit Installation Path DAS (JDK_PATH) = C:\Program
Files\IBM\SQLLIB\\java\jdk\
Java Development Kit Installation Path DAS (JDK_64_PATH) =
DAS Code Page (DAS_CODEPAGE) = 0
DAS Territory (DAS_TERRITORY) = 0
Location of Contact List (CONTACT_HOST) =
Execute Expired Tasks (EXEC_EXP_TASK) = NO
Scheduler Mode (SCHED_ENABLE) = ON
SMTP Server (SMTP_SERVER) =
Tools Catalog Database (TOOLSCAT_DB) = TOOLSDB
Tools Catalog Database Instance (TOOLSCAT_INST) = DB2
Tools Catalog Database Schema (TOOLSCAT_SCHEMA) = SYSTOOLS
Scheduler User ID =
Kindly help me to resolve this problem.
Any help wud be appreciated.
Thanks and regards
Jitendra
DB2 & UDB email list listserv db2-l LazyDBA home page