I was trying to alter the bufferpool from BP0 to BP32K2. I got the below error
ALTER TABLESPACE DBNAME.TSNAME BUFFERPOOL BP32K2 ;
SQLERROR ON ALTER COMMAND, EXECUTE FUNCTION
RESULT OF SQL STATEMENT:
DSNT408I SQLCODE = -671, ERROR: THE BUFFERPOOL ATTRIBUTE OF THE TABLE SPACE CANNOT BE ALTERED AS SPECIFIED BECAUSE IT
WOULD CHANGE THE PAGE SIZE OF THE TABLE SPACE
DSNT418I SQLSTATE = 53040 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXIATS SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 120 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000078' X'00000000' X'00000000' X'FFFFFFFF' X'000
Looks like we cannot change the bufferpool to a different page size. Is there any alternative way to do this apart from dropping and re-creating it.
My problem is we created Tables which had LOB columns, so LOB tablespaces have been created in default BP0 bufferpool. We want them to move to 32K bufferpool.
meditate on the relation between page size and controlinterval size
and how for the defaults the two values coincide
( and buffer pools naturally )
The VARY DS CONTROL INTERVAL parameter on installation panel DSNTIP7 allows you to control whether DB2-managed data sets have variable VSAM control intervals:
A value of YES indicates that a DB2-managed data set is created with a VSAM control interval that corresponds to the size of the buffer pool that is used for the table space. This is the default value.