What is wrong in this statement?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Guru - 10 Feb 2005 05:38 GMT

Hi All

db2 => create regular tablespace tablespace2 pagesize 4k managed by
system using ('D:\') extentsize
DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it
returned:
SQL0298N Bad container path. SQLSTATE=428B2

Warm Regards
Guru

Reply to this Message

Thiru - 10 Feb 2005 07:19 GMT

Try with
create regular tablespace tablespace2 pagesize 4k managed by system
using ('D:\<Directory which is not existing>') ....

Chears,
Thiru.
WantedToBeDBA.

Reply to this Message

JoKlassen@email.com - 10 Feb 2005 08:09 GMT

> Hi All
>
[quoted text clipped - 8 lines]
> Warm Regards
> Guru

Maybe a permission problem. Does the user under which the db2instance
is started have appropriate rights for D:\ ?

Joachim

BTW: IIRC i had a similar problem when the disk partition was not
indexed

Reply to this Message

wanchan - 10 Feb 2005 11:46 GMT

One of the possibility is that D:\ is not empty.
The directory to be used for SMS should contain no other files nor be used
by other containers...

irwan

Reply to this Message