|
View previous topic :: View next topic
|
| Author |
Message |
gylbharat
Active Member
.jpg)
Joined: 31 Jul 2009
Posts: 565
Location: Bangalore
|
|
|
|
Hi,
I was trying to alter the bufferpool from BP0 to BP32K2. I got the below error
| Code: |
***INPUT STATEMENT:
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
INFORMATION
|
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.
Please let me know how this can be done? |
|
| Back to top |
|
 |
sushanth bobby
Senior Member
Joined: 29 Jul 2008
Posts: 1020
Location: India
|
|
|
|
Not possible, i think without dropping & re-creating the tablespace. Since the data needs to put into bigger page.
regards,
sushanth |
|
| Back to top |
|
|
gylbharat
Active Member
Joined: 31 Jul 2009
Posts: 565
Location: Bangalore
|
|
|
|
Yes... But ideally Stop database --> ALTER --> START Database --> REORG should work.
I mean IBM should give this feature  |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10903
Location: italy
|
|
|
|
| Quote: |
| I mean IBM should give this feature |
meditate on the relation between page size and controlinterval size
and how for the defaults the two values coincide
( and buffer pools naturally )
| Quote: |
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.
|
|
|
| Back to top |
|
|
gylbharat
Active Member
Joined: 31 Jul 2009
Posts: 565
Location: Bangalore
|
|
|
|
| Thanks for the explanation.... Really helpful |
|
| Back to top |
|
|
|
|
