Re: RE: Error -1215 Value exceeds limit of INT....
The fix alters IBM's internal sysadmin.mon_users monitoring table (ALTER TABLE MODIFY on multiple columns) plus a blanket UPDATE of every row to force materialization; doing this on the wrong version, without matching the exact APAR, or without a backup first could break the built-in scheduler/monitoring subsystem.
ALTER TABLE mon_users MODIFY (...) UPDATE mon_users SET upf_rqlock = upf_rqlock WHERE 1=1
Advisory only — not a substitute for testing in a non-production environment first.
Sounds like some admin task is storing a value in a DECIMAL type in its stored procedure then trying to save it to an INT type column in one of the tables in sysadmin but its value is greater then 2^31 or less than -(2^31). Likely IBM has run into this one already and can tell you which table and column to alter to a BIGINT. Open a support case. Art Art S. Kagel, Principal Consultant ASK Database Management 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 Thu, Jan 23, 2014 at 6:05 PM, O KHAN <theultimateboy@hotmail.com> wrote: > No, I have not performed any upgrade on my server. > > I am using IDS 11.70 FC7 and it installed it 4 months back without any > problem/warnings. > > Thanks. > > Regards, > Khan > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e0122aefed3c9aa04f0ab5a1e
La informaci?n y archivos anexos contenidos en este mensaje pueden ser confidenciales y/o contener informaci?n legalmente privilegiada. Si usted no es destinatario del mismo: queda formalmente notificado que (i)cualquier divulgaci?n, distribuci?n, reproducci?n o copiado de esta comunicaci?n est? estrictamente prohibido y (ii) que no deber? tomar ninguna acci?n basada en este correo electr?nico o cualquier otra informaci?n incluida en ?l. Favor de notificar al remitente de inmediato mediante el reenv?o de este correo electr?nico y borrar a continuaci?n el mismo y sus anexos. Si ?ste mensaje est? dirigido a uno de los clientes de CIATEQ, A.C., cualquier opini?n o punto de vista contenidos en este correo electr?nico, est?n sujetos a los t?rminos y condiciones expresados en los correspondientes contratos firmados con CIATEQ, A.C."
You have run into issue IC89509 which is fixed in 11.70.FC8
While the fix is very simple
As user informix in the syadmin database
ALTER TABLE mon_users MODIFY (upf_rqlock bigint, upf_wtlock bigint,
upf_deadlk bigint, upf_lktouts bigint, upf_lgrecs bigint,
upf_isread bigint, upf_iswrite bigint, upf_isrwrite bigint,
upf_isdelete bigint, upf_iscommit bigint, upf_isrollback
bigint,
upf_longtxs bigint, upf_bufreads bigint, upf_bufwrites bigint,
upf_logspuse bigint, upf_logspmax bigint, upf_seqscans bigint,
upf_totsorts bigint, upf_dsksorts bigint, upf_srtspmax bigint);
UPDATE mon_users set upf_rqlock = upf_rqlock WHERE 1=1;
John F. Miller III
STSM, Lead Architect
miller3@us.ibm.com
503-747-1366
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 01/23/2014 03:11:06 PM:
> From: "Art Kagel" <art.kagel@gmail.com>
> To: ids@iiug.org,
> Date: 01/23/2014 03:11 PM
> Subject: Re: RE: Error -1215 Value exceeds limit of INT.... [32313]
> Sent by: ids-bounces@iiug.org
>
> Sounds like some admin task is storing a value in a DECIMAL type in its
> stored procedure then trying to save it to an INT type column in one of
the
> tables in sysadmin but its value is greater then 2^31 or less than
-(2^31).
> Likely IBM has run into this one already and can tell you which table and
> column to alter to a BIGINT. Open a support case.
>
> Art
>
> Art S. Kagel, Principal Consultant
> ASK Database Management
>
> 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 Thu, Jan 23, 2014 at 6:05 PM, O KHAN <theultimateboy@hotmail.com>
wrote:
>
> > No, I have not performed any upgrade on my server.
> >
> > I am using IDS 11.70 FC7 and it installed it 4 months back without any
> > problem/warnings.
> >
> > Thanks.
> >
> > Regards,
> > Khan
> >
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --089e0122aefed3c9aa04f0ab5a1e
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>