Skip to Content
0
Former Member
Aug 04, 2008 at 12:55 PM

SQL0204N when trying to use a newly created bufferpool

85 Views

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