relocating sysutils database
Peter Logan asked whether the sysutils database, created in the root dbspace and growing large from onbar backup data, could be created in another dbspace. Jean Sagi said it is fine and recommended, and Richard Snoke said it is no problem: the DDL is in sysutils.sql under etc, so export, drop and import it, or just recreate it if its content is not needed.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
I have a system where we are doing onbars ... and keeping an insane amount of backup data ... Since sysutils gets created in the root dbsspace in the default script ... sysutils.sql located in $INFORMIXDIR/etc..... my root is becoming quite large ... The question is ... any issues with creating this database in a different dbspace ... Thanks for any and all help ... Peter Peter Logan Senior Database Administrator Phone: 616/878-8309
Not at all, it is recomended procedure. There is an SQL API to do that... just forget the document but I think is on developer works... J. 2008/11/19 Peter_Logan@spartanstores.com <Peter_Logan@spartanstores.com> > I have a system where we are doing onbars ... and keeping an insane amount > of backup data ... Since sysutils gets created in the root dbsspace in > the default script ... sysutils.sql located in $INFORMIXDIR/etc..... my > root is becoming quite large ... > > The question is ... any issues with creating this database in a different > dbspace ... > > Thanks for any and all help ... > > Peter > > Peter Logan > Senior Database Administrator > Phone: 616/878-8309 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >
I know of none. Art On Wed, Nov 19, 2008 at 8:03 AM, Peter_Logan@spartanstores.com < Peter_Logan@spartanstores.com> wrote: > I have a system where we are doing onbars ... and keeping an insane amount > of backup data ... Since sysutils gets created in the root dbsspace in > the default script ... sysutils.sql located in $INFORMIXDIR/etc..... my > root is becoming quite large ... > > The question is ... any issues with creating this database in a different > dbspace ... > > Thanks for any and all help ... > > Peter > > Peter Logan > Senior Database Administrator > Phone: 616/878-8309 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.
Shouldn't be a problem. The DDL to create the database is in $INFORMIXDIR/etc/sysutils.sql, if that matters. Just export/drop/import to put it where you want it. If you don't need to keep the content, its even simpler. Cheers, Dick Snoke IBM Data Management - ChannelWorks dsnoke@us.ibm.com (404) 487-1595 From: "Peter_Logan@spartanstores.com" <Peter_Logan@spartanstores.com> To: ids@iiug.org Date: 11/19/2008 08:05 AM Subject: relocating sysutils database [14039] I have a system where we are doing onbars ... and keeping an insane amount of backup data ... Since sysutils gets created in the root dbsspace in the default script ... sysutils.sql located in $INFORMIXDIR/etc..... my root is becoming quite large ... The question is ... any issues with creating this database in a different dbspace ... Thanks for any and all help ... Peter Peter Logan Senior Database Administrator Phone: 616/878-8309 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.