RE: Database Catalog
Hello, Andre.
For rebuilding sysmaster, you could look for buildsmi in Information Center.
Hope it helps.
Regards.
Alexandre Marini
IBM Informix Certified Professional v10 / v11.50 / v11.70
IBM Information Management Informix Technical Professional
IBM Infosphere DataStage Technical Professional
Informix Senior DBA - Orizon Brasil
BRIUG website administrator
Informix independent consultant
> To: ids@iiug.org
> From: andre_rufino@msn.com
> Subject: RE: Database Catalog [30063]
> Date: Tue, 16 Apr 2013 12:01:59 -0400
>
> Hum. Do you know how recreate command work ?
>
> > To: ids@iiug.org
> > From: art.kagel@gmail.com
> > Subject: Re: Database Catalog [30061]
> > Date: Tue, 16 Apr 2013 10:32:15 -0400
> >
> > You cannot relocate the database's catalog tables except by recreating the
> > database in a different dbspace. You can do this either by export, drop,
> > recreate, import or by creating an empty database with a different name,
> > creating the tables in the new database, copy the data from the original
> > database to the new one, drop the original database, rename the new
> > database. The latter can be faster than export/import because you save one
> > set of disk write/readback operations.
> >
> > Art
> >
> > Art S. Kagel
> > Advanced DataTools (www.advancedatatools.com)
> > Blog: http://informix-myview.blogspot.com/
> >
> > Disclaimer: Please keep in mind that my own opinions are my own opinions
> > and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
> > other organization with which I am associated either explicitly,
> > implicitly, or by inference. Neither do those opinions reflect those of
> > other individuals affiliated with any entity with which I am affiliated nor
> > those of the entities themselves.
> >
> > On Tue, Apr 16, 2013 at 10:23 AM, André Luiz Rufino
> > <andre_rufino@msn.com>wrote:
> >
> > > Hi, everybody. Does anybody ever tried to move all "sys" database catalog
> > > tables without dbexport/dbimport process?
> > > Best regards,
> > > André Luiz Rufino
> > >
> > >
> > >
> > >
> >
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --089e0117720589a4e204da7b3bb3
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>