RSS server is not active / Can not establish RSS -
User configured RSS (Replicated Server for Standby) on IDS 11.50.FC9 but couldn't establish RSS connection to backup server. Error message: "Can not establish RSS - not logging index pages". Suggested solution: set LOG_INDEX_BUILDS to '1' in secondary ONCONFIG file. User reported this was already set. Thread continues with Art asking clarification about secondary setup method but no final resolution recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hello all,
I followed and have completed all the steps for setting "back", an RSS
server with IDS 11.50.FC9 on AIX 6.1.
When I issue onmode -d RSS ol_live (Primary) on the backup server,
instance log shows :
"
13:04:09 DR: Secondary to Secondary
13:04:09 DR: new type = RSS
13:04:09 Can not establish RSS - not logging index pages
"
On the other hand, onstat -g rss verbose on primay server shows :
"
Local server type: Primary
Index page logging status: Enabled
Index page logging was enabled at: 2015/09/06 12:07:08
Number of RSS servers: 1
RSS Server information:
RSS Server control block: 0x0
RSS server name: ol_back
RSS server status: Defined
RSS connection status: Defined
"
So, RSS server ol_back is not active.
Can you please, tell me what could be wrong in this issue and help me
solve the problem ?
Thanks in advance !
Best regards,
H. MOUKOURI
In the ONCONFIG file on the secondary set LOG_INDEX_BUILDS to '1' and try
again.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.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 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 Mon, Sep 7, 2015 at 7:51 AM, Moukouri Henri <h.moukouri@moukouri.net>
wrote:
> Hello all,
>
> I followed and have completed all the steps for setting "back", an RSS
> server with IDS 11.50.FC9 on AIX 6.1.
>
> When I issue onmode -d RSS ol_live (Primary) on the backup server,
> instance log shows :
> "
> 13:04:09 DR: Secondary to Secondary
> 13:04:09 DR: new type = RSS
> 13:04:09 Can not establish RSS - not logging index pages
> "
>
> On the other hand, onstat -g rss verbose on primay server shows :
> "
> Local server type: Primary
> Index page logging status: Enabled
> Index page logging was enabled at: 2015/09/06 12:07:08
> Number of RSS servers: 1
>
> RSS Server information:
>
> RSS Server control block: 0x0
> RSS server name: ol_back
> RSS server status: Defined
> RSS connection status: Defined
> "
>
> So, RSS server ol_back is not active.
> Can you please, tell me what could be wrong in this issue and help me
> solve the problem ?
>
> Thanks in advance !
>
> Best regards,
> H. MOUKOURI
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a1141bd88a38ed0051f27c0fd
Hi Art,
I also thought it could be the problem. LOG_INDEX_BUILDS was already set
to 1 and did not solve the issue.
Any other hints ?
Thanks in advance !
Best regards,
H. MOUKOURI
Le 07/09/2015 14:54, Art Kagel a écrit :
> In the ONCONFIG file on the secondary set LOG_INDEX_BUILDS to '1' and try
> again.
>
> Art
>
> Art S. Kagel, President and Principal Consultant
> ASK Database Management
> www.askdbmgt.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 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 Mon, Sep 7, 2015 at 7:51 AM, Moukouri Henri <h.moukouri@moukouri.net>
> wrote:
>
>> Hello all,
>>
>> I followed and have completed all the steps for setting "back", an RSS
>> server with IDS 11.50.FC9 on AIX 6.1.
>>
>> When I issue onmode -d RSS ol_live (Primary) on the backup server,
>> instance log shows :
>> "
>> 13:04:09 DR: Secondary to Secondary
>> 13:04:09 DR: new type = RSS
>> 13:04:09 Can not establish RSS - not logging index pages
>> "
>>
>> On the other hand, onstat -g rss verbose on primay server shows :
>> "
>> Local server type: Primary
>> Index page logging status: Enabled
>> Index page logging was enabled at: 2015/09/06 12:07:08
>> Number of RSS servers: 1
>>
>> RSS Server information:
>>
>> RSS Server control block: 0x0
>> RSS server name: ol_back
>> RSS server status: Defined
>> RSS connection status: Defined
>> "
>>
>> So, RSS server ol_back is not active.
>> Can you please, tell me what could be wrong in this issue and help me
>> solve the problem ?
>>
>> Thanks in advance !
>>
>> Best regards,
>> H. MOUKOURI
>>
>>
>>
>>
>
*******************************************************************************
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>>
> --001a1141bd88a38ed0051f27c0fd
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
Just an odd but important question: Did you create the secondary from
restoring an archive from the primary or using ifxclone?
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.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 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 Mon, Sep 7, 2015 at 9:52 AM, Moukouri Henri <h.moukouri@moukouri.net>
wrote:
> Hi Art,
>
> I also thought it could be the problem. LOG_INDEX_BUILDS was already set
> to 1 and did not solve the issue.
>
> Any other hints ?
>
> Thanks in advance !
>
> Best regards,
> H. MOUKOURI
>
> Le 07/09/2015 14:54, Art Kagel a écrit :
> > In the ONCONFIG file on the secondary set LOG_INDEX_BUILDS to '1' and try
> > again.
> >
> > Art
> >
> > Art S. Kagel, President and Principal Consultant
> > ASK Database Management
> > www.askdbmgt.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 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 Mon, Sep 7, 2015 at 7:51 AM, Moukouri Henri <h.moukouri@moukouri.net>
> > wrote:
> >
> >> Hello all,
> >>
> >> I followed and have completed all the steps for setting "back", an RSS
> >> server with IDS 11.50.FC9 on AIX 6.1.
> >>
> >> When I issue onmode -d RSS ol_live (Primary) on the backup server,
> >> instance log shows :
> >> "
> >> 13:04:09 DR: Secondary to Secondary
> >> 13:04:09 DR: new type = RSS
> >> 13:04:09 Can not establish RSS - not logging index pages
> >> "
> >>
> >> On the other hand, onstat -g rss verbose on primay server shows :
> >> "
> >> Local server type: Primary
> >> Index page logging status: Enabled
> >> Index page logging was enabled at: 2015/09/06 12:07:08
> >> Number of RSS servers: 1
> >>
> >> RSS Server information:
> >>
> >> RSS Server control block: 0x0
> >> RSS server name: ol_back
> >> RSS server status: Defined
> >> RSS connection status: Defined
> >> "
> >>
> >> So, RSS server ol_back is not active.
> >> Can you please, tell me what could be wrong in this issue and help me
> >> solve the problem ?
> >>
> >> Thanks in advance !
> >>
> >> Best regards,
> >> H. MOUKOURI
> >>
> >>
> >>
> >>
> >
>
>
*******************************************************************************
> >> Forum Note: Use "Reply" to post a response in the discussion forum.
> >>
> >>
> > --001a1141bd88a38ed0051f27c0fd
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--089e01176cad755ef3051f28feca
Hi Art,
I restored from an archive, but not the correct one. :-[
In fact, I was checking to see what went wrong with the procedure to find
that I did not use my last L0 archive taken after LOG_INDEX_BUILDS was
set on the primary server.
Sorry for that, and many thanks for your help !
Best regards,
H. MOUKOURI
Le 07/09/2015 16:23, Art Kagel a écrit :
> Just an odd but important question: Did you create the secondary from
> restoring an archive from the primary or using ifxclone?
>
> Art
>
> Art S. Kagel, President and Principal Consultant
> ASK Database Management
> www.askdbmgt.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 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 Mon, Sep 7, 2015 at 9:52 AM, Moukouri Henri <h.moukouri@moukouri.net>
> wrote:
>
>> Hi Art,
>>
>> I also thought it could be the problem. LOG_INDEX_BUILDS was already set
>> to 1 and did not solve the issue.
>>
>> Any other hints ?
>>
>> Thanks in advance !
>>
>> Best regards,
>> H. MOUKOURI
>>
>> Le 07/09/2015 14:54, Art Kagel a écrit :
>>> In the ONCONFIG file on the secondary set LOG_INDEX_BUILDS to '1' and try
>>> again.
>>>
>>> Art
>>>
>>> Art S. Kagel, President and Principal Consultant
>>> ASK Database Management
>>> www.askdbmgt.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 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 Mon, Sep 7, 2015 at 7:51 AM, Moukouri Henri <h.moukouri@moukouri.net>
>>> wrote:
>>>
>>>> Hello all,
>>>>
>>>> I followed and have completed all the steps for setting "back", an RSS
>>>> server with IDS 11.50.FC9 on AIX 6.1.
>>>>
>>>> When I issue onmode -d RSS ol_live (Primary) on the backup server,
>>>> instance log shows :
>>>> "
>>>> 13:04:09 DR: Secondary to Secondary
>>>> 13:04:09 DR: new type = RSS
>>>> 13:04:09 Can not establish RSS - not logging index pages
>>>> "
>>>>
>>>> On the other hand, onstat -g rss verbose on primay server shows :
>>>> "
>>>> Local server type: Primary
>>>> Index page logging status: Enabled
>>>> Index page logging was enabled at: 2015/09/06 12:07:08
>>>> Number of RSS servers: 1
>>>>
>>>> RSS Server information:
>>>>
>>>> RSS Server control block: 0x0
>>>> RSS server name: ol_back
>>>> RSS server status: Defined
>>>> RSS connection status: Defined
>>>> "
>>>>
>>>> So, RSS server ol_back is not active.
>>>> Can you please, tell me what could be wrong in this issue and help me
>>>> solve the problem ?
>>>>
>>>> Thanks in advance !
>>>>
>>>> Best regards,
>>>> H. MOUKOURI
>>>>
>>>>
>>>>
>>>>
>>
>
*******************************************************************************
>>>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>>>
>>>>
>>> --001a1141bd88a38ed0051f27c0fd
>>>
>>>
>>>
>>
>
*******************************************************************************
>>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>>
>>>
>>>
>>
>>
>>
>
*******************************************************************************
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>>
> --089e01176cad755ef3051f28feca
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
Opps - you have to take the backup after index page logging has been turned on.
Related threads
- Posting from the Informix-list
- Migrating from IDS 9.40.UC6 to 11.50.UC3
- Ip for a network session
- questions onstat -g