Re: Did I create a DBSpace correctly?
Posted in 1997
In article <648394$953$1@nntp1.ba.best.com>, lclee@shell5.ba.best.com
writes
>Richard Fremmerlid <lsbcoop2@hq.marh.gov.bc.ca> wrote:
>> I don't know much about Informix, I am on a student work term
>> trying to work through it without any help from our information
>> systems people. They installed the database but they don't know
>> anything about it, so be merciful with my lack of knowledge.
>
>> Previously I have been creating all of our databases in the default
>> rootdbs, and since I heard that wasnt' the recommended practice, I attempted
>> to create a new workspace. I did the following:
>
>> 1. cat /dev/null > raw_dbs *This in same dir as rootdbs
>> 2. chmod 660 raw_dbs
>> 3. onspaces -c -d dbdemo -p /app/informix/dbspace/raw_dbs -o 5000 -s 10000
>Since you're using cooked files, why is offset needed ?? I've mostly
>used raw devices before .. so am I missing something?
>
No - you can use an offset of 0 i.e. no offset since this is a cooked
file.
>-Lin
>
>> 4. dbaccessdemo dbdemo3 -dbspace dbdemo
>> 5. Then I added a new table to dbdemo3 from the dbadmin in LiveWire, and
>> it seemed to work.
>
>> I am wondering if you can tell me if I missed something, and did some
>> damage to our system. I am new to all of this.
>
--
David Williams