IBM Support

IV93337: POOR PERFORMANCES of PLAN DELETE ON ORACLE

 

APAR status

  • Closed as program error.

Error description

  • The PlanDelete operation that is triggered immediatly after the
    planman resync is slow on Oracle.
    
    This is slow because it is not performed in chuncks and then
    could cause table lock escalation.
    This in turn could cause deadlocks/timeouts, because in this
    phase the mirroring event processing is restarting.
    
    This has been seen only in large customer environment (>100.000
    jobs per day).
    

Local fix

  • N/A
    

Problem summary

  • See APAR DESCRIPTION
    

Problem conclusion

  • The APAR will be fixed in 93FP3 and 94FP1
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV93337

  • Reported component name

    TIV WKLD SCHDL

  • Reported component ID

    5698WKB93

  • Reported release

    9Z3

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-02-15

  • Closed date

    2017-04-14

  • Last modified date

    2017-05-26

  • 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":"9Z3","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
12 September 2023