IDS Forum

Advice sought

Posted By: Malcolm Garbett
Date: Friday, 17 January 2003, at 6:08 a.m.

Hi all,

I have a database on our system (called archdb) that is currently empty.

We are going to begin populating this with data. (Moving "old" data from
our live dB to archdb)

I ran some basic tests on archdb, and discovered a bad index on one table.
As the dB is empty I dropped and recreated the table, and cured the problem.

However...

We have rootdbs and dbs1. As I thought one never puts anything other than
system stuff in rootdbs I created the table in dbs1. On further checking I
discovered that the people who set up the our system put "live" and some
other dBs in dbs1, but for some reason they put archdb in rootdbs.

So...I now have archdb in rootdbs, apart from one table, and that's in dbs1.

My options, as I see them are these.

1. Leave everything as it is now.
2. Drop and recreate the one table, putting it in rootdbs.
3. Drop the database archdb and recreate it in dbs1

Suggestions/comments as to the best option to choose, and any dire
consequences inherent in any of the above options gratefully received.

Here's the output from onstat -d

Informix Dynamic Server 2000 Version 9.21.UC2 -- On-Line -- Up 36 days
17:52:11 -- 688128 Kbytes

Dbspaces
address number flags fchunk nchunks flags owner name
9c5187d0 1 0x1 1 1 N informix rootdbs
9c5575f0 2 0x1 2 2 N informix dbs1
2 active, 2047 maximum

Chunks
address chk/dbs offset size free bpages flags pathname
9c518918 1 1 0 125000 81641 PO- /dev/infdisk1
9c557320 2 2 125000 875000 32610 PO- /dev/infdisk1
9c557488 3 2 0 1000000 999997 PO- /dev/infdisk2
3 active, 2047 maximum

Regards,
Malcolm Garbett
IT Manager

"This e-mail and any files transmitted with it is confidential. If you are
not the intended recipient, you should not use, copy or disclose its
contents, but should immediately notify the sender and delete the e-mail.
The statements and opinions expressed here may not represent those of the
company. Whilst we run anti-virus software on all e -mails we are not
liable for any loss or damage and the recipient is advised to run their own
anti-virus software".
Newall Measurement Systems Ltd.

Messages In This Thread

• Advice sought
  Malcolm Garbett -- Friday, 17 January 2003, at 6:08 a.m.
  • Re: Advice sought
    Martin Fuerderer -- Friday, 17 January 2003, at 9:29 a.m.
  • Re: Advice sought
    ART KAGEL, BLOOMBERG/ 65E 55TH -- Friday, 17 January 2003, at 12:28 p.m.
  • Re: Advice sought
    MALCOLM WEALLANS -- Monday, 20 January 2003, at 5:32 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.