PH15545: BIGSQL RECEIVES OUT OF RESOURCE ERROR ON ONE PARTICULAR WORKER NODE.

APAR status

• Closed as fixed if next.

Error description

• Customer may encounter performance issue or an outage with one
  particular node running out of resources even when there is
  enough memory avilable on the other nodes.
  The below error message is seem on a particular node.
   "There are not enough system resources to process the request.
  The request cannot be processed. SQLSTATE=57011 SQLCODE=-10003"
  
  The db2pd -dbptnmem output will show excessive memory usage in
  the FMP_RESOURCES pool on that particular node. Also the
  bigsql-sched-recurring-diag-info.log shows significantly more
  splits for that worker.
  This is because customer is running lots of small scans which
  get assigned to one worker node only. This APAR will fix this
  issue and distribute the smaller splits.
  

Local fix

• Customer should avoid running smaller scans simultaneously.
  

Problem summary

• Please see the problem description.
  

Problem conclusion

Temporary fix

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

Applicable component levels