High Page Latch Wait time on Temp tables
January 22, 2018 12:30 AM
(in response to Andy Smith)
Thanks Andy and sorry for the late reply. We had also added
tablespaces to the work file database but that did not help.
In our case we found that CPU constraints at particular times was
the high page latch wait times.
High page latch wait time usually indicates a systemic problem but
lack of tools like RMF I was not able to proceed. Got the
performance guys involved and they helped with the analysis.
On Wed, Jan 17, 2018 at 8:11 PM, Andy Smith
<[login to unmask email]> wrote:
> We had a very similar problem a few years ago - we didn't have
> work file tablespaces defined and so we were seeing Page Latch
> these when we had "too many" concurrent threads in Db2. We
> more tablespaces in the work file database. If you go down
> then have a read up on installation parameter WFDBSEP first -
it might help
> you to decide which kind of tablespaces to define.
> -----End Original Message-----