dba-db2.com - db2 performance tuning, DB2 tuning,db2 performance,sql tuning db2, DBA in DB2, DBA Scripts,DB2,DB2 consulting,DB2 consultant,DB2 architecture,DB2 training

SQL20169W The buffer pool is not started

26 March,2013 by Tom Collins

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: Rambler(http://www.dba-db2.com)

Share:

Posted by Tom Collins at 6:28 AM in Buffer Pools, Performance | Permalink | Comments (0) | TrackBack (0)

Searches: , ,

Verify your Comment

Previewing your Comment

Posted by: |

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