I would make a trip to the migration guide in the online docs, but yea,
onsmsync basically finds out what your storage manager expired, and
deletes entries related to those. It's safe to run, I run it on all my
instances once a month.
The onbar ( bar ) tables and structures are located in the sysutils
database, which is part of the rootdbs. That's normal.
----- Original Message -----
Subject: Re: Root DBS Contents
Date: Tue, April 29, 2008 23:27
From: CrispieCritter@[EMAIL PROTECTED]
Apr 24, 12:11 pm, "Art S. Kagel (Oninit)" <a...@[EMAIL PROTECTED]
> wrote:
> > CrispieCrit...@[EMAIL PROTECTED]
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...@[EMAIL PROTECTED]
> > >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
> _______________________________________________
> Informix-list mailing list
> Informix-list@[EMAIL PROTECTED]
> http://www.iiug.org/mailman/listinfo/informix-list
>
>
|
