In this post, you’ll learn about the error message -647 bufferpool bp name cannot be specified because it has not been activated in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-647 bufferpool bp name cannot be specified because it has not been activated
Reason for the Error
The buffer pool specified in a CREATE or ALTER statement for a table space or index (index space) is not activated (that is, the buffer pool was not activated during the start up of DB2). Table spaces and indexes (index spaces) can only be assigned (or reassigned) to buffer pools that are currently activated.
Solution
Verify that the proper buffer pool was specified in the CREATE or ALTER statement.� If so, ensure that the buffer pool is activated before resubmitting the statement for execution.