ANALYZE SCHEDULE report shows many deadlock jobs
search cancel

ANALYZE SCHEDULE report shows many deadlock jobs

book

Article ID: 234302

calendar_today

Updated On:

Products

Scheduler Job Management

Issue/Introduction

'ANALYZE SCHEDULE name=sname' returns many deadlock jobs.

Resolution

Use the DATE parameter when running ANALYZE.

Syntax:  ANALYZE SCHEDULE NAME=sname,DATE=date

When the Date keyword is not specified, all potential scheduling deadlocks are reported.  ANALYZE acts as if every schedule and job were selected by ignoring date criteria 
keywords.  The result is erroneous deadlocks.  Some examples of date criteria keywords are WDAY, MON, TUE, WDOM3.

When the Date keyword is specified, the date criteria keywords are honored, causing ANALYZE to report just those deadlocks that Autoscan would detect.