Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2007
    Posts
    265

    Unanswered: create bufferpool query error

    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

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Quote Originally Posted by db2user24 View Post
    is AUTOMATIC not supported in versions < 9?
    Doesn't exist in v8

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •