Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2009
    Posts
    2

    Unanswered: Getting Expected tokens may include: "<space>".

    I am trying following statements in DB2 -

    Create bufferpool COGBUF immediate size 1000 pagesize 32K;

    Create SYSTEM TEMPORARY TABLESPACE COGTABSYS pagesize 32 K MANAGED BY AUTOMATIC STORAGE bufferpool COGBUF;

    Create user temporary tablespace COGUSERTAB pagesize 4096 bufferpool COGBUF;

    Create REGULAR TABLESPACE COGREG pagesize 4096 MANAGED BY AUTOMATIC STORAGE bufferpool COGBUF;


    But except first statement no one is getting executed successfully. Getting below messages -

    Create bufferpool COGBUF immediate size 1000 pagesize 32K
    DB20000I The SQL command completed successfully.

    Create SYSTEM TEMPORARY TABLESPACE COGTABSYS pagesize 32 K MANAGED BY AUTOMATIC STORAGE bufferpool COGBUF
    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 STORAGE bufferpool COGBUF" was found
    following "size 32 K MANAGED BY". Expected tokens may include: "<space>".
    SQLSTATE=42601

    Create user temporary tablespace COGUSERTAB pagesize 4096 bufferpool COGBUF
    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 "bufferpool COGBUF" was found following "SERTAB
    pagesize 4096". Expected tokens may include: "<space>". SQLSTATE=42601

    Create REGULAR TABLESPACE COGREG pagesize 4096 MANAGED BY AUTOMATIC STORAGE bufferpool COGBUF
    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 STORAGE bufferpool COGBUF" was found
    following "size 4096 MANAGED BY". Expected tokens may include: "<space>".
    SQLSTATE=42601


    Can somebody tell me whats issue in above statements. I am quite new to DB2 :-(

  2. #2
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    Which version of DB2?
    Is your database created with automatic storage enabeled?

  3. #3
    Join Date
    Sep 2009
    Posts
    2
    I am using DB2 version 8.2 on Linux environment.
    How to check whether the Auto storage is available or not?

  4. #4
    Join Date
    May 2009
    Posts
    508
    Provided Answers: 1
    s@kh!, Automatic storage is not available in V8.2. You could check infocenter, look up the commands and see that there is not an automatic storage parameter for them.

Posting Permissions

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