DB2 SORTHEAP and pinned pages

27 February,2012 by Jack Vamvas

This post discusses SORTHEAP DB2 and pinned pages Information message in db2diag.log

 

 

FUNCTION: DB2 UDB, buffer pool services, sqlbKeepPagesPinned, probe:20
MESSAGE
: ADM6071I  The maximum number of pinned pages allowed concurrently was
          reached in buffer pool "MYBUF8K" (ID "2").  As a result performance
          may not be optimal. Increasing the SORTHEAP database configuration
          parameter may reduce the chances of this condition occurring in the
          future.

 

Notes

 

1)  The message refers to the  sqlbKeepPagesPinned  function.

 

2)  The message indicates the specified buffer pool is too small for current activity.

 

3)   This also points to high CPU usage

 

4) Recommend index analysis focusing on indexes using the sort heap.Including hash join buffers, in memory tables, dynamic bitmaps

 

5) If  SORTHEAP isn’t set at AUTOMATIC , increase the level if large sorts are used.

 

 

 

See Also

DBA Interview Questions and Answers – DB2 Server Operations  

 

Author: Jack Vamvas(http://www.dba-db2.com)

Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on DB2 SORTHEAP and pinned pages

Comments are moderated, and will not appear until the author has approved them.


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright