IV31942: DELETE JOB ON A TABLE MDL.JSF_JS_INST_FORECAST CAUSES EWAS HANG

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

APAR status

  • Closed as program error.

Error description

  • System: Linux dbsm0000 6 2 s390x
    
    Number of nodes in db2nodes.cfg is: 1
          0 dbsm0000 0
    
    
    The issue is, as noted above, that the application runs a delete
    job on
    a table called MDL.JSF_JS_INST_FORECAST. The application appears
    to hang
    on this delete job.
    
    
    We verified that we can optimize the TWS code in order to
    perform
    the delete forecast operation.
    

Local fix

Problem summary

  • This apar is applicable only to TWS 8.6 FP1 release that
    introduced the feature to remove the zombie forecast instances
    during the startup.
    When a forecast plan is created a temporary preproduction plan
    is generated and it is removed when the forecast is completed.
    If during the creation of the forecast, the customer kill the
    eWAS, some zombie forecast instances remain in the preproduction
    tables of the forecast.
    The eWAS startup clean these tables but using
    a single transaction. This apar implements the mechanism to
    delete the zombie forecast instabces during the startup of
    the eWAS with a block mechanismt.
    

Problem conclusion

  • This apar will be fixed into 8.6.0-TIV-TWS-FP0002.
    

Temporary fix

  • Run the following command:
    delete * from MDL.JSF_JS_INST_FORECAST
    

Comments

APAR Information

  • APAR number

    IV31942

  • Reported component name

    TIV WKLD SCHDL

  • Reported component ID

    5698WKB85

  • Reported release

    860

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-11-13

  • Closed date

    2012-11-21

  • Last modified date

    2012-11-21

  • 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

    5698WKB86

Applicable component levels

  • R8A6 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Tivoli Workload Scheduler

Software version:

860

Reference #:

IV31942

Modified date:

2012-11-21

Translate my page

Machine Translation

Content navigation