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

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 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