Root DBS Contents
Hi All, I am currently running Informix 10 on a solaris box and someone here has done / created something that started filling up the root dbspace. I am the one who now needs to go investigate this and I am leaning toward the idea that someone has created a table or index incorrectly and it is now storing the data in the root dbspace. I think this is the case as this space as pretty much never increased in the 2+ years since the upgrade and now it is increasing daily. So my question is, is there an easy way to get a list of all the tables / index's that reside within a particular dbspace ? I just need to track down what non-system table is in this space so I can get someone to drop it and recreate it properly. Regards, Glenn
CrispieCritter@gmail.com wrote:
> Hi All,
>
Critter:
SELECT dbsname, tabname
FROM sysmaster:systabnames
WHERE dbinfo('dbspace',partnum) = 'rootdbs'
and dbsname not in ('sysmaster','sysadmin','sysutils','sysuser');
Art S. Kagel
Oninit
> I am currently running Informix 10 on a solaris box and someone here
> has done / created something that started filling up the root dbspace.
> I am the one who now needs to go investigate this and I am leaning
> toward the idea that someone has created a table or index incorrectly
> and it is now storing the data in the root dbspace. I think this is
> the case as this space as pretty much never increased in the 2+ years
> since the upgrade and now it is increasing daily.
>
> So my question is, is there an easy way to get a list of all the
> tables / index's that reside within a particular dbspace ? I just need
> to track down what non-system table is in this space so I can get
> someone to drop it and recreate it properly.
>
> Regards,
>
> Glenn
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>
>
>
On Apr 24, 12:11 pm, "Art S. Kagel (Oninit)" <a...@oninit.com> wrote:
> CrispieCrit...@gmail.com wrote:
> > Hi All,
>
> Critter:
>
> SELECT dbsname, tabname
> FROM sysmaster:systabnames
> WHERE dbinfo('dbspace',partnum) = 'rootdbs'
> and dbsname not in ('sysmaster','sysadmin','sysutils','sysuser');>
> Art S. Kagel
> Oninit
>
>
>
> > I am currently running Informix 10 on a solaris box and someone here
> > has done / created something that started filling up the root dbspace.
> > I am the one who now needs to go investigate this and I am leaning
> > toward the idea that someone has created a table or index incorrectly
> > and it is now storing the data in the root dbspace. I think this is
> > the case as this space as pretty much never increased in the 2+ years
> > since the upgrade and now it is increasing daily.
>
> > So my question is, is there an easy way to get a list of all the
> > tables / index's that reside within a particular dbspace ? I just need
> > to track down what non-system table is in this space so I can get
> > someone to drop it and recreate it properly.
>
> > Regards,
>
> > Glenn
> > _______________________________________________
> > Informix-list mailing list
> > Informix-l...@iiug.org
> >http://www.iiug.org/mailman/listinfo/informix-list- Hide quoted text -
>
> - Show quoted text -
So I used the oncheck -pe command and found two "issues". The first
issue is someone created an index in the root dbs some how so we
dumped the table and re-create it to get rid of that. The second issue
is there are a number of onbar items in this area now, like the
following:
sysutils:'informix'.bar_object 13809 128
sysutils:'informix'.bar_obj_idx 13937 224
sysutils:'informix'.bar_instance 14161 128
sysutils:'informix'.bar_object 14289 128
sysutils:'informix'. 103_14 14417 8
sysutils:'informix'.bar_act_idx 14425 8
sysutils:'informix'.bar_obj_idx 14433 224
Now I was reading around on some of the onbar docs to see what this
might be and couldn't really find too much at the moment. However,
what I did notice is the availablity of a utility called onsmsync that
cleans up onbar items. I am 95% sure that this has never been run.
Ever. Now am I right to assume that this should be a scheduled task
of some description ? If so is it safe to run this in it's default
mode to do a cleanup ? We do run a third party backup manager (Veritas
Netbackup) so is there any traps in running it in that sort of
environment ?
Thanks for all the help.
Glenn