Groups > DB2 > DB2 UDB > Re: Storage group




Re: Storage group

Re: Storage group
Tue, 14 Aug 2007 11:53:15 EDT
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,
Post Reply
Re: Storage group
Tue, 14 Aug 2007 13:22:32 EDT
thank you for your attention.

Post Reply
about | contact