RSS sync problem 3 pages left in rootdbs
Posted in 2017
Dear All,
Running a production db IDS11.7FC4 on AIX 7.1
Have 2 RSS servers one of them real time the other with 1/2h delay
Today I had a problem, I ended up on the production site with 3 free pages on
the production server.
The RSS sync that has no delay was stopped.
I did repack shrink on one of the sysadmin database and it all went well on
the production(freed up some 9000pages).
However these changes can not be propagated on the rss servers
Now the master has different view from the servers that are actually applying
the logs:
idspbrsssoc Active Connected 2995841,1216 Y
idsrssesbsoc Active Connected 2996100,464 N
The second one has a progress of both log ids and pages ...
However if i go to the servers:
onstat -g rss
IBM Informix Dynamic Server Version 11.70.FC4 -- Read-Only (RSS) -- Up
00:26:43 -- 1303664 Kbytes
Local server type: RSS
Server Status : Active
Source server name: idsescmnsoc
Connection status: Connected
Last log page received(log id,page): 2995841,191
onstat -g rss
IBM Informix Dynamic Server Version 11.70.FC4 -- Updatable (RSS) -- Up
00:53:22 -- 7123472 Kbytes
Local server type: RSS
Server Status : Active
Source server name: idsescmnsoc
Connection status: Connected
Last log page received(log id,page): 2995841,191
Both of them stacked on the same Log and page.
So my question is, is there any way to propagete these changes on the rss or I
should do a restore back and reinitialize the rss instances ???
> onstat -d | grep rootdbs
Primary:
7000010285651d0 1 1 25 50000 9559 PO-B-- /usr/informix/dbs/rootdbs
RSS1:
7000000408481d0 1 1 25 50000 3 PI-B-- /usr/informix/dbs/rootdbs
RSS2:
7000001608481d0 1 1 25 50000 3 PI-B-- /usr/informix/dbs/rootdbs
This is quite of urgent because I have EOD procedure in few hours so the logs
will cycle in few hours anyway... so any answer is appreciated .
Thank you,
Aleksandar
3 free pages in ROOTDBS sorry.