Creating DB using device tablespace

[Trey Cain]

I'm having trouble creating a database that uses a database managed user
tablespace, stored on a device. When creating the database, I use the
following command line:

CREATE DATABASE bigtpcw USER TABLESPACE MANAGED BY DATABASE USING ( DEVICE
'/dev/rhdisk16' 2000 )

Unfortunately, this doesn't work. I get the following error:

SQL0298N Bad container path. SQLSTATE=428B2

The device /dev/rhdisk16 is world readable/writable, so having proper
permissions is not the problem. This device definitely exists, so I am not
sure why I'm getting this error about a bad container path. Do I need to
create a container before creating this DB?

If anyone has insight into this problem, I'd appreciate your help. Thank
you.

--Trey

[jerrys01]

I thought that the three default area created (when you create a
database) must be SMS. After the DB is created, you can go and
create your own user space in either SMS or DMS areas. In fact,
DB2 will use your first user created tablespace as a default
area--if no 'in' clause is found in the create table statement,
the table will be placed here.

* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!

[Blair Kenneth Adamache]

All three tablespaces (user, catalog, temp) can be DMS - even raw if you want.
I recommend SMS for the catalog tablespace, and SMS for the temp tablespace on
most platforms, except Solaris. See the CREATE DATABASE syntax in the Command
Reference manual (snippet follows):

>-----+----------------------------------------+---------------->
'-CATALOG TABLESPACE--| tblspace-defn |--'

>-----+-------------------------------------+------------------->
'-USER TABLESPACE--| tblspace-defn |--'

>-----+------------------------------------------+-------------->
'-TEMPORARY TABLESPACE--| tblspace-defn |--'

>-----+-------------------------+-------------------------------|
'-WITH--"comment-string"--'

tblspace-defn

|---MANAGED BY-------------------------------------------------->

.-,--------------------.
V |
>-----+-SYSTEM
USING--(-----'container-string'--+---)-------------------------------------+>
|
.-,-----------------------------------------------------. |
|
V | |
'-DATABASE
USING--(------+-FILE---+---'container-string'---number-of-pages---+---)--'
'-DEVICE-'

[Hasso Brück]

Trey Cain wrote in message ...

>I'm having trouble creating a database that uses a database managed user
>tablespace, stored on a device. When creating the database, I use the
>following command line:
>
>CREATE DATABASE bigtpcw USER TABLESPACE MANAGED BY DATABASE USING ( DEVICE
>'/dev/rhdisk16' 2000 )
>
>Unfortunately, this doesn't work. I get the following error:
>
>SQL0298N Bad container path. SQLSTATE=428B2
>
>The device /dev/rhdisk16 is world readable/writable, so having proper

which OS?
AIX? (aix has devices like hdisk16)
On AIX you have to create logical volume on that hdisk16 (which is physical
volume)
and use this LV for container path. On Solaris & HP-UX you have to use
partitions. Or LV's if you have some Veritas or DiskSuite stuff...
Few months ago i tested and succesfully create test DB (AIX 4.3.3, DB2 v6.1
FixPak3)
with all stuff on raw devices (read:logical volumes). Including logs.

---
Hasso Brück
Technical Manager
Korel SYS Ltd.