IBM Support

IV98210: DATABASE DEADLOCK OCCURRING WHEN CANCELLING A CARRIED FORWARD JS WITH EXTERNAL DEPENDENCIES

 

APAR status

  • Closed as program error.

Error description

  • When using IWS 9.3.0.03, a deadlock
    can occur when a Job Stream cancel is issued for a carried
    forward Job Stream which has external dependencies.
    .
    Below the conflicting updates in case of Oracle database ...
    .
      Sql_id = cmh85z7axu0w4
      Cursor text =     UPDATE mozart.PJOR_JOB_RUNS
      SET PJOR_MODIFY_TIME                 =:1 ,
        PJOR_CANCEL_STATUS                 =:2 ,
        PJOR_STATUS                        =:3 ,
        PJOR_REPLY_NEEDED                  =:4
      WHERE (( mozart.PJOR_JOB_RUNS.PJOR_ID=:5 )
      AND ( mozart.PJOR_JOB_RUNS.PPLN_ID   =:6 ))
    .
    and ...
    .
      Sql_id=4vcd73hjjqgyz
      update mozart.PJOR_JOB_RUNS set
        PJOR_NUM_UNRESOLVED_DEPS=PJOR_NUM_UNRESOLVED_DEPS-1,
        PJOR_NUM_RES_DEPS=PJOR_NUM_RES_DEPS-1 where PJOR_ID=:1
    

Local fix

Problem summary

  • See APAR descrption
    

Problem conclusion

  • The APAR will be fixed in 93FP4 and 94FP2
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV98210

  • Reported component name

    TIV WKLD SCHDL

  • Reported component ID

    5698WKB93

  • Reported release

    9L3

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-07-18

  • Closed date

    2017-07-26

  • Last modified date

    2018-12-13

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    TIV WKLD SCHDL

  • Fixed component ID

    5698WKB93

Applicable component levels

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSGSPN","label":"IBM Workload Scheduler"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9L3","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
12 September 2023