List of Contributions

Celso Freitas de Andrade

Contact Details

My Content

1 to 14 of 14 total

-157 ISAM error: Interrupted ISAM call

Posted By Celso Freitas de Andrade Mon May 10, 2021 01:24 PM
Found In Egroup: Informix \ view thread
Hello everyone, In a scheduling process done by one of the applications that connect to our Informix instance, we had many errors with the following message: "ERROR [IX000] [IBM][IDS/UNIX64] Statement interrupted by user. (-157 ISAM error: Interrupted ISAM call) -157 ISAM error: Interrupted ISAM ...

Checkpoint duration and TXNS Blocked

Posted By Celso Freitas de Andrade Wed March 31, 2021 09:29 AM
Found In Egroup: Informix \ view thread
​Hello everyone, We are having problems with one of our servers. For a few days now, checkpoints that generally lasted 0 seconds are repeatedly taking 1 second, sometimes 2 seconds, and some transactions are being blocked. "21:11:18 Checkpoint Completed: duration was 1 seconds. 21:11:18 Tue Mar ...

RE: Size of blob column

Posted By Celso Freitas de Andrade Mon March 22, 2021 01:08 PM
Found In Egroup: Informix \ view thread
Thanks Paul, Andreas and Art! Regards​ ------------------------------ Celso Freitas ------------------------------

Size of blob column

Posted By Celso Freitas de Andrade Thu March 18, 2021 11:13 AM
Found In Egroup: Informix \ view thread
Hello all, I need to know the space allocated by a table that has a byte column in a blobspace. When I look at the size of the table, I don't see the portion of it that is stored in the blobspace. Is there a way to get this information? Thanks! ------------------------------ Celso Freitas ...

RE: Primary and RSS versions

Posted By Celso Freitas de Andrade Thu March 11, 2021 10:49 AM
Found In Egroup: Informix \ view thread
Just found the Administrator's guide documentation with the answer :) Database server version https://www.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.admin.doc/ids_admin_0922.htm ------------------------------ Celso Freitas ------------------------------

Primary and RSS versions

Posted By Celso Freitas de Andrade Thu March 11, 2021 10:33 AM
Found In Egroup: Informix \ view thread
Hello All, I have a primary server with an RSS Secondary, both using version 11.70.FC8. As far as I know, these servers must be identical (including version - minor and major release). But I would like to confirm: Is it possible to upgrade the primary to version 12.10 and the RSS secondary ...

RE: Innovator-C Edition on Virtual Machine

Posted By Celso Freitas de Andrade Wed March 03, 2021 04:16 PM
Found In Egroup: Informix \ view thread
Thank you Art! ------------------------------ Celso Freitas ------------------------------

Innovator-C Edition on Virtual Machine

Posted By Celso Freitas de Andrade Wed March 03, 2021 03:52 PM
Found In Egroup: Informix \ view thread
Hello all, Earlier today I posted a question about Innovator-C edition, and was provided a very useful link with informations about the Informix Editions, here is the link: https://www.iiug.org/en/2019/10/08/compare-informix/ So, here is my doubt: in that link there is an excerpt that says: ...

RE: Informix free versions - production site

Posted By Celso Freitas de Andrade Wed March 03, 2021 12:13 PM
Found In Egroup: Informix \ view thread
Thanks a lot, Alexandre! Regards, ------------------------------ Celso Freitas ------------------------------

Informix free versions - production site

Posted By Celso Freitas de Andrade Wed March 03, 2021 11:20 AM
Found In Egroup: Informix \ view thread
Hello all, I would like to know what editions of IDS I can use for free in a production site. From what I heard, for that purpose I cannot use a Developer Edition, and the best option would be an Innovator Edition. So I would like to confirm that and also know more about these editions limitations. ...

RE: OS upgrade and Informix Server

Posted By Celso Freitas de Andrade Thu January 21, 2021 03:23 PM
Found In Egroup: Informix \ view thread
Thanks for the tip, David! Regards ------------------------------ Celso Freitas ------------------------------

RE: OS upgrade and Informix Server

Posted By Celso Freitas de Andrade Tue January 19, 2021 03:53 PM
Found In Egroup: Informix \ view thread
Thank you, Art! ------------------------------ Celso Freitas de Andrade ------------------------------

OS upgrade and Informix Server

Posted By Celso Freitas de Andrade Tue January 19, 2021 02:33 PM
Found In Egroup: Informix \ view thread
Hi everyone! I have an Informix Server version 12.10.FC10WE running in a RHEL 6.5 machine, and we are planning to upgrade the OS version to RHEL 7.0. So, in order to do this OS upgrade, what would be the best option? Should I move the Informix Server to another machine and then upgrade the OS, ...

Informix DNS Warning

Posted By Celso Freitas de Andrade Fri March 06, 2020 02:02 PM
Found In Egroup: Informix \ view thread
Hello everybody, I have an Informix 12.10.FC13 server running and lately I have been seeing the following message on my online.log: "02/24/20 13:31:02 WARNING: Detected slow or failing DNS service response 1 time(s)." Does anyone know what is this message about? Thanks, Regards ----- ...