Error -225 when configuring RSS
Jose Luis Cabrera Sacco got error -225/ISAM -21527 creating the sysha database on 11.70.FC4 when running onmode -d add RSS. Art Kagel said it points to a dbspace problem such as root dbspace space, AUTOLOCATE, or an offline or full dbspace. Jose found the real cause: the secondary should use onmode -d RSS without add, and the secondary was in Fast Recovery.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Trying to configure an RSS server and when executing "onmode -d add RSS
<primary server>" on the secondary server, the following error appears:
04/07/15 16:06:59 Building 'sysha' database ...
04/07/15 16:06:59 ERROR on the following statement SQLCODE:-225 ISAM:-21527
create database sysha with log04/07/15 16:06:59 Error building 'sysha' database.
OS version is "SUSE Linux Enterprise Server 11 SP3 (x86_64)" , Kernel version
3.0.76-0.11-default
Informix version: IBM Informix Dynamic Server Version 11.70.FC4GE
Any idea on how to solve the problem?
Regards
Im sorry, I found the problem.
The comand is for the primary server. On the secondary server the command is:
onmode -d RSS <primary server>
(without "add")
Regards !
Jose:
The error codes indicate that one of the system catalog tables (probably
systables) could not be created because of a problem with the dbspace it
was being created in. Check to see that the root dbspace has sufficient
space to hold the sysha database if you do not have AUTOLOCATE set to a
positive value. If AUTOLOCATE is set to a positive value, then it may be
that one of the other dbspaces is marked offline or has run out of free
space.
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 Tue, Apr 7, 2015 at 3:36 PM, JOSé LUIS CABRERA SACCO <
jcabrera@anda.com.uy> wrote:
> Trying to configure an RSS server and when executing "onmode -d add RSS
> <primary server>" on the secondary server, the following error appears:
>
> 04/07/15 16:06:59 Building 'sysha' database ...
> 04/07/15 16:06:59 ERROR on the following statement SQLCODE:-225 ISAM:-21527
> create database sysha with log> 04/07/15 16:06:59 Error building 'sysha' database.
>
> OS version is "SUSE Linux Enterprise Server 11 SP3 (x86_64)" , Kernel
> version
> 3.0.76-0.11-default
> Informix version: IBM Informix Dynamic Server Version 11.70.FC4GE
>
> Any idea on how to solve the problem?
>
> Regards
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a1140e70287ae1e051328022d
Thanks Art.
I found the problem.
On the secondary server the command is:
onmode -d RSS <primary server>
(without "add")
and I was typing
onmode -d add RSS <primary server>The command failed because the secondary server is in "Fast Recovery" mode !!!!
Regards !