DB2 SQL-Error: -647
SQLState: 57003
Short Description: BUFFERPOOL CANNOT BE SPECIFIED BECAUSE IT HAS NOT BEEN ACTIVATED
The buffer pool specified in a CREATE or ALTER statement for a table space or index (index space) 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 executed. 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. 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 desired size.