-647   BUFFERPOOL bp-name FOR IMPLICIT OR EXPLICIT TABLESPACE OR INDEXSPACE name HAS NOT BEEN ACTIVATED

Explanation

The buffer pool specified in a CREATE or ALTER statement for a table space or index (index space) is not activated. Alternatively, on a CREATE TABLE statement without an IN clause, the buffer pool, which is chosen by DB2® implicitly according to the actual record size, is not activated.

Table spaces and indexes (index spaces) can only be assigned or reassigned to buffer pools that are currently activated.

System action

The statement cannot be processed. The specified table space or index space was not created or altered.

Programmer response

Verify that the proper buffer pool was specified in the CREATE or ALTER statement and the buffer pool is chosen by DB2. Use the -DISPLAY BUFFERPOOL command to display the attributes of the buffer pool and determine if the buffer pool is activated. If the buffer pool is not activated, use the -ALTER BUFFERPOOL command to change the VPSIZE from 0 to the appropriate size.

SQLSTATE

57003