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 :-(

Which version of DB2?
Is your database created with automatic storage enabeled?

I am using DB2 version 8.2 on Linux environment.
How to check whether the Auto storage is available or not?

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.