Kelly Schlamb
2007-08-14 15:53:15 UTC
Hi,
This feature is not available on DB2 for LUW, it is only available on DB2 for z/OS. That is why you are getting the syntax error.
What exactly are you trying to do with this statement on Windows? In LUW, storage has traditionally been defined at the individual table space level. For instance:
db2 "create tablespace ts1 managed by database using (file 'D:\TS1' 2000)"
Starting in V8.2.2 (FP 9) the concept of Automatic Storage was introduced. This allows you to associate storage paths (directories) with the database and then automatic storage containers will automatically be assigned from those paths. For example:
db2 "create database db1 on d:\path1, e:\path2"
db2 "connect to db1"
db2 "create tablespace ts1"
db2 "connect reset"
For more information on this, please search the manuals for the terms "create tablespace" and "automatic storage".
Regards,
Kelly
This feature is not available on DB2 for LUW, it is only available on DB2 for z/OS. That is why you are getting the syntax error.
What exactly are you trying to do with this statement on Windows? In LUW, storage has traditionally been defined at the individual table space level. For instance:
db2 "create tablespace ts1 managed by database using (file 'D:\TS1' 2000)"
Starting in V8.2.2 (FP 9) the concept of Automatic Storage was introduced. This allows you to associate storage paths (directories) with the database and then automatic storage containers will automatically be assigned from those paths. For example:
db2 "create database db1 on d:\path1, e:\path2"
db2 "connect to db1"
db2 "create tablespace ts1"
db2 "connect reset"
For more information on this, please search the manuals for the terms "create tablespace" and "automatic storage".
Regards,
Kelly