In this post, you’ll learn about the error message -677 insufficient virtual storage for bufferpool expansion in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-677 insufficient virtual storage for bufferpool expansion
Reason for the Error
An attempt to either open (create) or expand a buffer pool has failed because insufficient virtual storage was available.This error may occur under either of two circumstances: *�� An attempt to create a buffer pool while opening a table space or index(space), or� *�� An attempt to expand a buffer pool from its current size to its maximum size.
Solution
If this error should occur during interactive execution of an SQL statement or execution of an application program,��� installation administration should be notified. Installation Action: It may be necessary to reexamine the buffer pool storage strategy. One of the following messages has also been sent to the MVS console: DSNB601I, DSNB603I, or DSNB605I.
