DBEXPORT IN RSS NOT WORKS
Posted in 2010
Topics: High Availability & Replication, Storage & Space Management, Server Administration, Migration, Import/Export & Data Conversion, Platform-Specific Issues, Versions, Editions & End-of-Life
HELLO!!!
We have an environment RSS with IDS 11.50.FC7 on HP-UX 11.11. We want to do
our backup method a dbexport on RSS side.. but appears the following message,
after set STOP_APPLY=1, we run dbexport database command:
"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"
We are sured that exists temporal DBSPACES.. because the onstat -d output and
the DBSPACETEMP onconfig... Also we have the entry DBSPACETEMP with onstat -g
env..
we tried to do the following:
export DBSPACETEMP=dbstemp1,dbstemp2 (in the currently session terminal) but
the result is the same... in fact we realized a dbschema on any table and the
message is the same... Do you think if this consider a bug of the version
currently or some issue in the RSS configuration?..
Very thanks for ur time.
IBM Informix Dynamic Server Version 11.50.FC7 -- Read-Only (RSS) -- Up
05:08:33 -- 217852 Kbytes
Dbspaces
address number flags fchunk nchunks pgsize flags owner name
c00000009430aba8 5 0x42001 5 1 2048 N TB informix dbstemp1
c00000009430ad40 6 0x42001 6 1 2048 N TB informix dbstemp2
# DBSPACETEMP - The list of dbspaces used to store temporary
DBSPACETEMP dbstemp1,dbstemp2
Hello, Tatiana. According to the documentation, it could be just right. (Just a guess) how did you set the STOP_APPLY=1 ? Best regards. Em 30/07/2010 11:36, TATIANA FLORES escreveu: > because no > temporary dbspace exists -- Alexandre Marini Tecnologia da Informação - DBA msn: alexandre_marini@hotmail.com SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix Cert-Info-Mgmt_color <Cert-Info-Mgmt_color.jpg> IBM Informix Dynamic Server Certified Professional V10 / V11
Hi Alex...
I put it : onmode -wm STOP_APPLY=1
and the online.log showed me the change. and the logs went to LOG_STAGING_DIR
Thanks
> To: ids@iiug.org
> From: amarini@fazenda.ms.gov.br
> Subject: Re: DBEXPORT IN RSS NOT WORKS [20710]
> Date: Fri, 30 Jul 2010 12:41:38 -0400
>
> Hello, Tatiana.
> According to the documentation, it could be just right.
> (Just a guess) how did you set the STOP_APPLY=1 ?
>
> Best regards.
>
> Em 30/07/2010 11:36, TATIANA FLORES escreveu:
> > because no
> > temporary dbspace exists
>
> --
>
> Alexandre Marini
>
> Tecnologia da Informação - DBA
>
> msn: alexandre_marini@hotmail.com
>
> SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix
>
> Cert-Info-Mgmt_color <Cert-Info-Mgmt_color.jpg>
>
> IBM Informix Dynamic Server Certified Professional V10 / V11
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Ok Tati, that´s the normal behaviour, then.
Please take a look at this old post, maybe could help you....
http://www.iiug.org/forums/ids/index.cgi/read/19649
Best regards!
Em 30/07/2010 12:51, Tatis Flowers escreveu:
> Hi Alex...
>
> I put it : onmode -wm STOP_APPLY=1
>
> and the online.log showed me the change. and the logs went to LOG_STAGING_DIR
>
> Thanks
>
>> To: ids@iiug.org
>> From: amarini@fazenda.ms.gov.br
>> Subject: Re: DBEXPORT IN RSS NOT WORKS [20710]
>> Date: Fri, 30 Jul 2010 12:41:38 -0400
>>
>> Hello, Tatiana.
>> According to the documentation, it could be just right.
>> (Just a guess) how did you set the STOP_APPLY=1 ?
>>
>> Best regards.
>>
>> Em 30/07/2010 11:36, TATIANA FLORES escreveu:
>>> because no
>>> temporary dbspace exists
>> --
>>
>> Alexandre Marini
>>
>> Tecnologia da Informação - DBA
>>
>> msn: alexandre_marini@hotmail.com
>>
>> SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix
>>
>> Cert-Info-Mgmt_color<Cert-Info-Mgmt_color.jpg>
>>
>> IBM Informix Dynamic Server Certified Professional V10 / V11
>>
>>
>>
>
*******************************************************************************
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Alexandre Marini
Tecnologia da Informação - DBA
msn: alexandre_marini@hotmail.com
SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix
Cert-Info-Mgmt_color <Cert-Info-Mgmt_color.jpg>
IBM Informix Dynamic Server Certified Professional V10 / V11
Related threads
- IDS 10 table-level restore
- Informix Development Webinar December 11, 2007
- ontape -p/r with changed ROOTPATH
- Migrate from HP PA-RISC to HP ITANIUM by ontape