SQL0204N when trying to use a newly created bufferpool

[Former Member]

I'm running into the problem described in note 1099936 (SQL0670N The row length of a table exceeds 4005 bytes) and I'm trying to use the described workaround-

However, after having created a new bufferpool I can't use it:

db2foo> db2 create bufferpool ZBUFFER32 size 5000 pagesize 32k
DB20000I  The SQL command completed successfully.

db2foo> db2 create tablespace "FOO#POOLD" in ZBUFFER32 pagesize 32K  extentsize 2 prefetchsize automatic   dropped table recovery off;
DB21034E  The command was processed as an SQL statement because it was not a 
valid Command Line Processor command.  During SQL processing it returned:
SQL0204N  "ZBUFFER32" is an undefined name.  SQLSTATE=42704

db2foo> db2 select bpname,pagesize from syscat.bufferpools

BPNAME                                                                                
PAGESIZE   
----------------------------------------------------------------------------------------------------------
---------------------- -----------
IBMDEFAULTBP                                                                                
16384
ZBUFFER32                                                                                
32768

db2foo> db2level
DB21085I  Instance "db2foo" uses "64" bits and DB2 code release "SQL09014" with 
level identifier "01050107".
Informational tokens are "DB2 v9.1.0.4", "special_19276", "U811795_19276", and 
Fix Pack "4".
Product is installed at "/opt/IBM/db2/V9.1".

Am I missing something?

Markus

[Thomas_Matthä · Accepted solution]

Hi,

when you look at the structure of the create tablespace statement in the DB2 doku, you see, that the

"IN"-Clause specifies the Database-Partitiongroup. You have to use the BUFFERPOOL clause, then

it should work. Replace In wuth BUFFERPOOL.

kind regards

Thomas

[markus_doehr2 · Accepted solution]

thanx! I really oversaw this - was fiddling with the syntax too long!

Markus