dbTalk Databases Forums  

Automatic Update Statistics

comp.databases.informix comp.databases.informix


Discuss Automatic Update Statistics in the comp.databases.informix forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Fernandez Garcia, Domingo
 
Posts: n/a

Default Automatic Update Statistics - 08-09-2011 , 04:04 AM






Good morning,

We have installed IDS 11.70.FC1GE on Red Hat Enterprise Linux Server release 5.7 (Tikanga).
Every day we see the next message in online.log:
01:00:17 SCHAPI: [Auto Update Statistics Evaluation 29-xx] Error -1284
Value will not fit in a BIGINT or an INT8.
We don't have any idea about what variable generate the problem.
Aus_cmd_list, aus_cmd_comp and aus_command tables in sysadmin are empty.
Any idea?
Thanks in advance,

______________________________________
Jefe del Área de Sistemas
Servicio de Informática
Universida de Cantabria
Tfno. 942201084
e-mail : domingo.fernandez (AT) gestion (DOT) unican.es

Reply With Quote
  #2  
Old   
Alexandre Marini
 
Posts: n/a

Default Re: Automatic Update Statistics - 08-09-2011 , 08:06 AM






Hello,
This topic was already discussed on IIUG forum, look for the old posts,
and you´ll find the solution, ok?

Best regards.

Em 09/08/2011 05:04, Fernandez Garcia, Domingo escreveu:
Quote:
Error -1284

--

Alexandre Marini

Tecnologia da Informação - DBA

msn: alexandre_marini (AT) hotmail (DOT) com

SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix

<Cert-Info-Mgmt_color.jpg>

IBM Certified System Administrator - Informix Dynamic Server V10 / V11 /
V11.70

IBM Information Management Informix Technical Professional v3

Reply With Quote
  #3  
Old   
Fernandez Garcia, Domingo
 
Posts: n/a

Default RE: Automatic Update Statistics - 08-10-2011 , 03:44 AM



Thanks, I've seen there was a bug in sysmaster in 11.70.FC1GE.

Best regards

De: Alexandre Marini [mailto:amarini (AT) fazenda (DOT) ms.gov.br]
Enviado el: martes, 09 de agosto de 2011 15:06
Para: Fernandez Garcia, Domingo
CC: informix-list (AT) iiug (DOT) org
Asunto: Re: Automatic Update Statistics

Hello,
This topic was already discussed on IIUG forum, look for the old posts, andyou´ll find the solution, ok?

Best regards.

Em 09/08/2011 05:04, Fernandez Garcia, Domingo escreveu:
Error -1284

--

Alexandre Marini

Tecnologia da Informação - DBA

msn: alexandre_marini (AT) hotmail (DOT) ...mail (DOT) com>

SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix

[cid:image001.jpg (AT) 01CC574A (DOT) 67BC6CA0]<Cert-Info-Mgmt_color.jpg>
IBM Certified System Administrator - Informix Dynamic Server V10 / V11 / V11.70
IBM Information Management Informix Technical Professional v3

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.