This is something we have happening from time to time on a couple of our
systems.

We have to do this to resolve the problem:

Db2admin setschedid <username> <password>
Db2admin setid <username> <password>
Db2admin stop
Db2admin start

Med vennlig hilsen,

Odd Bjørn Andersen

ErgoGroup
IKT-driftstjenester
Postboks 4364 Nydalen, 0402 Oslo
Telefon 23 14 50 00, Telefaks 23 14 50 01
Direkte tlf.nr. 970 84 597
www.ergogroup.no

-----Opprinnelig melding-----
Fra: Otfrid Altfeld
[mailto:db2udbdba-ezmlmshield-x3031590.[Email address protected]
Sendt: 27. oktober 2005 10:49
Til: LazyDBA Discussion
Emne: AW: F1, F1 - The scheduler is not running since last night

Hi Jitendra.

Try

db2admin stop
db2admin start

We had the same problems and created a OS-Task that contains the DB2 Admin
stop and start commands and is executed once every day.

Hope that will help you.

Kind regards,
Otfrid

-----Ursprüngliche Nachricht-----
Von: Jitendra Kumar [mailto:db2udbdba-ezmlmshield-x20777678.[Email address
protected]
Gesendet: Donnerstag, 27. Oktober 2005 08:43
An: LazyDBA Discussion
Betreff: F1, F1 - The scheduler is not running since last night

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



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



DB2 & UDB email list listserv db2-l LazyDBA home page