SQL20169W The buffer pool is not started

26 March,2013 by Jack Vamvas

The DB2 message  SQL20169W  The buffer pool is not started  appeared in response to a ALTER BUFFERPOOL statement

 

db2 ALTER BUFFERPOOL ITMBUF8K IMMEDIATE size 250000

---SQL20169W  The buffer pool is not started.  SQLSTATE=01654

 

To overcome this problem , disconnect all the applications connected to the database, and activate the database.

There are a number of methods to disconnect all the applications , such as DB2 deactivate database

Read More

Database will come up with hidden buffer pools - DBA DB2

Querying Bufferpools DB2 - DBA DB2

DB2 SORTHEAP and pinned pages - DBA DB2

 

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 SQL20169W The buffer pool is not started

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