Re: Database Catalog

There is no "recreate" command, that's a placeholder for manual operations. Simplest way? 1. dbexport the database with -ss (so objects not currently in the default dbspace are recreated in the correct place) 2. rename the database 3. dbimport the database using the -d option to specify a new home for the catalog and tables not otherwise located. (Don't forget to set the desired logging mode with -l) 4. drop the original database once everything checks out. You could drop the database in step 2 if you want, but like all good DBAs I'm more than a little paranoid 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 12:01 PM, André Luiz Rufino <andre_rufino@msn.com>wrote: > 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. > > --089e0112c7c8e501d104da7c9b59

Or the totally unsupported way is to create copies of each catalog table, take the engine offline and switch the partnums Cheers Paul -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel Sent: Tuesday, April 16, 2013 11:11 AM To: ids@iiug.org Subject: Re: Database Catalog [30066] There is no "recreate" command, that's a placeholder for manual operations. Simplest way? 1. dbexport the database with -ss (so objects not currently in the default dbspace are recreated in the correct place) 2. rename the database 3. dbimport the database using the -d option to specify a new home for the catalog and tables not otherwise located. (Don't forget to set the desired logging mode with -l) 4. drop the original database once everything checks out. You could drop the database in step 2 if you want, but like all good DBAs I'm more than a little paranoid 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 12:01 PM, André Luiz Rufino <andre_rufino@msn.com>wrote: > 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. > > --089e0112c7c8e501d104da7c9b59 **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.