RE: dbexport on RSS client

Hi everybody!!!! I tried to do a dbexport with the following: dbexport basedato -o /path I followed the path Paul sent, but I got the following in the RSS node: ""The operation cannot be performed on this RS secondary server because no temporary dbspace exists. Set the DBSPACETEMP configuration parameter to a valid temporary dbspace, then rerun this command.""" Obviously, the message looks like clear... but I have setted DBSPACETEMP to dbstemp1 and dbstemp2 I reinitialized the RSS instance but the result is the same.. any suggestions will be really appreciated. NOTES: HP-UX 11.11 IDS 11.50.FC7 STOP_APPLY 1 LOG_STAGING_DIR /some_path (770 permissions) > To: ids@iiug.org > From: paul@oninit.com > Subject: RE: RE: dbexport on RSS client [19668] > Date: Tue, 13 Apr 2010 11:26:21 -0400 > > Yep - works perfectly unless you are on V7, 9 or 10 :) > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Madison Pruet > Sent: Tuesday, April 13, 2010 10:22 AM > To: ids@iiug.org > Subject: RE: RE: dbexport on RSS client [19667] > > Paul, > > Let me suggest the following technique. > > 1) demote the HDR secondary to an RSS node --- This can be done online > 2) set stop apply on the RSS node -- This can also be done online. Whi= > le > in this mode, we will stage the logs and can recover from them in the c= > ase > of a primary failure... > 3) perform dbexport > 4) turn off stop apply on the RSS node so it can replay the staged logs= > > 5) once the secondary is fairly caught up - promote the RSS node back t= > o an > HDR secondary > > All of these steps can be performed online and since we are staging the= > > logs rather than blocking the log transfer, we are still protected from= > a > primary failure. > > The dbexport will be using last committed read isolation - and thus wil= > l be > consistent. This technique will allow the export to be performed witho= > ut > impacting the primary and also will result in a consistent export. > > M.P. > > = > > From: "Paul Watson" <paul@oninit.com> = > > = > > To: ids@iiug.org = > > = > > Date: 04/13/2010 09:42 AM = > > = > > Subject: RE: RE: dbexport on RSS client [19665] = > > = > > Sent by: ids-bounces@iiug.org = > > = > > Jacques > > I'm aware of the limitations - it's just an easy way to get an export > without taking the production system offline. > > Cheers > Paul > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > JACQUES RENAUT > Sent: Tuesday, April 13, 2010 9:37 AM > To: ids@iiug.org > Subject: Re: RE: dbexport on RSS client [19664] > > Paul Watson wrote: > Works on a HDR secondary so it should - run on HDR secondary is a neat = > way > to get an export with needing any locks. > > Response: > There is a reason dbexport wants locks, and on HDR secondaries you can'= > t > enforce locks because of the interaction with recovery threads. So shou= > ld > you > dbexport a database on a secondary, you should be aware that the tables= > you > > are exporting are very likely being modified out from under the export.= > So > any > referential constraints in your database could potential be invalid whe= > n > you > go to import it because the tables were changing while the export was > occurring (ie you could be missing values in parent tables on foreign k= > eys > etc..). Just putting this out as a warning that dbexporting on a HDR > secondary > may not get you entirely what you expect, and so it could probably be > argued > that it should not be allowed to used dbexport on a secondary. > > Jacques Renaut > IBM Informix Advanced Support > APD Team > > ***********************************************************************= > ***** > > *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > _____ > > avast! Antivirus <http://www.avast.com>; : Outbound message clean. > > Virus Database (VPS): 100413-0, 04/13/2010 > Tested on: 4/13/2010 9:41:12 AM > avast! - copyright (c) 1988-2010 ALWIL Software. > > ***********************************************************************= > ******** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > = > > **************************************************************************** > *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > _____ > > avast! Antivirus <http://www.avast.com>; : Outbound message clean. > > Virus Database (VPS): 100413-0, 04/13/2010 > Tested on: 4/13/2010 10:26:18 AM > avast! - copyright (c) 1988-2010 ALWIL Software. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > _________________________________________________________________ Prefiero un día sin coche que sin Messenger www.vivirmessenger.com