Hi,

I'm using DB2 version 8.2 UDB on Linux.. this create bufferpool statement is failing.. is AUTOMATIC not supported in versions < 9? Or is something else wrong with my query? Thanks!!


db2 "CREATE BUFFERPOOL USERTMP_BP IMMEDIATE DATABASE PARTITION GROUP USERGROUP SIZE 6000 AUTOMATIC"

DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "AUTOMATIC" was found following "USERGROUP SIZE
6000". Expected tokens may include: "END-OF-STATEMENT". SQLSTATE=42601

Doesn't exist in v8