SBSPACE
Amit Patel asked whether adding an sbspace in a Primary/Secondary/RSS 14.10 cluster needs a bounce or config changes on every node. Mike Walker said SBSPACENAME can be changed dynamically with onmode -wf and no restart. Andreas Legner said config changes do not replicate and must be made per server, including for failover. ke chen noted sbspaces need logging enabled to replicate.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hello All,
Need one suggestion, we are having Informix cluster environment with Primary, Secondary and RSS nodes on
IDS14.10
.
We have to create a new SBSPACE, as I know we need to make change in ONCONFIG file by adding SBSPACE parameter for new SBSPACE name.
So can we do it by using "onmode -wf SBSPACENAME=sbsname" command OR do we need to bounce the instance?
And do we need to modify the Confirm file only on Primary Server and will it replicate to other servers OR do we need to make changes manually on Secondary and RSS node?
After altering via "onmode -wf" command, do we also need to restart all the DB instance?
Kindly suggest.
Thanks
Amit
------------------------------
AMIT PATEL
------------------------------
I remember sbspace has non-logging by default, thus if you want objects to be replicated across to secondaries, you should enable logging on sbspace. ------------------------------ ke chen ------------------------------
The SBSPACENAME parameter can be changed dynamically with "onmode -wf SBSPACENAME=<name>" and no restart is required. Use SBSPACENAME to specify the
default
sbspace - you can have multiple sbspaces.
------------------------------
Mike Walker
xDB Systems, Inc
www.xdbsystems.com
------------------------------
Thanks for your reply. So will it work in cluster environment?
And do we need to run "onmode -wf SBSPACE...." command in all three nodes ? Secondary and RSS? Or only in Primary.
Thanks
Amit
------------------------------
AMIT PATEL
------------------------------
AFAIR -wf should just work On 6/2/2026 6:37 AM, AMIT PATEL via IBM Community wrote: 0100019e881fddf2-a6d96f3a-1d8e-4302-8bcf-78c1e1826e0f-000000@email.amazonses.com"> Hello All, Need one suggestion, we are having Informix cluster environment with Primary, Secondary and RSS nodes on IDS14.10. ... -posted to the "Informix" group
Dear Paul,
Yoi mean to say, "onmode -wf
SBSPACENAME=<sbspacename>" will work without making any changes on other nodes apart from Primary?
Regards
Amit Patel
------------------------------
AMIT PATEL
------------------------------
Config changes do not replicate. Configuration strictly is per server, so need to changed per server too. On the other hand, what would the secondaries need SBSPACENAME for? Are they updatable? And of course in case of fail-over you want your new primary to be already configured properly. ------------------------------ Andreas Legner Informix Dev HCL Software ------------------------------