List of Contributions

Eric Vercelletto

Contact Details

My Content

1 to 20 of 50+ total

RE: Standard Engine 4GL still available or not?

Posted By Eric Vercelletto Mon April 08, 2024 12:20 PM
Found In Egroup: Informix \ view thread
As Everett said, You'd better use IDS Developer Edition which is a free edition. Standard Engine is still sold, but it is not cheap at all As per the 4GL language, you should definitely take a look at Querix Lycia! It is 100% based on the 4GL language you love, but mounted on a modern architecture, ...

Anyone using Informix 4GL Web Services ?

Posted By Eric Vercelletto Wed February 21, 2024 05:01 AM
Found In Egroup: Informix \ view thread
Hi community, evaluating functionality for a customer, I was just wondering whether Informix 4GL Web Services has ever been used anywhere in a production system / real life. Any comments and recommandations about it? Thanks Eric ------------------------------ [eric] [Vercelletto] [] [Founder] ...

Enterprise Replication: not sure which options for cdr define replicate

Posted By Eric Vercelletto Tue January 09, 2024 11:07 AM
Found In Egroup: Informix \ view thread
Hi Folks, first of all, a Happy New year to all the ones I didn't say personnally in our beautiful community. Back to business: here is my case I am in charge of a migration from an old 11.50 Windows 32 bit instance which is a nightmare of performance and stability etc., to a linux ...

RE: Informix processing "freezes"

Posted By Eric Vercelletto Tue November 21, 2023 06:07 AM
Found In Egroup: Informix \ view thread
And sorry if too much trivial, but did you check about logical log full (also long checkpoint don't seem to be an evidence of that, but there can be more than one issue involved...) Eric Vercelletto Data Management Architect and Owner / Begooden IT Consulting KandooERP Founder and CTO IBM ...

RE: Informix processing "freezes"

Posted By Eric Vercelletto Tue November 21, 2023 06:03 AM
Found In Egroup: Informix \ view thread
Just to check: Haven you seen any warning message in the Informix log file stating that for performance purpose, the physical log should be amplified ? this kind of behaviour often happens when at a given time the physical log is too small I know, simple idea, but relevant in many cases �� ...

Trying to recover a 11/50 TC3 32 bits instance

Posted By Eric Vercelletto Wed September 06, 2023 12:06 PM
Found In Egroup: Informix \ view thread
Hi folks Still struggling with the attempts to recover that customer's full instance ( see my last message about archecker issues) Making it short, big disaster with my customer's storage. After a few days we remain with 2 possible directions to recover something They could retrieve ontape ...

RE: archecker on IDS 11.50 TC3 (windows 32 bits) : tapesize seems forced to 2 Gb

Posted By Eric Vercelletto Thu August 24, 2023 01:13 PM
Found In Egroup: Informix \ view thread
Thanks Art, Will try Tomorrow. But look at my answer to Andreas Cheers Eric Envoyé à partir de Courrier pour Windows

RE: archecker on IDS 11.50 TC3 (windows 32 bits) : tapesize seems forced to 2 Gb

Posted By Eric Vercelletto Thu August 24, 2023 12:52 PM
Found In Egroup: Informix \ view thread
Because we have to restore it on another server which has much smaller storage, and better proceed table by table :-) this is preferrably. Original onconfig file said TAPESIZE 0 and archecker says TAPESIZE the exact value of max integer value ( 2,147...767) which is definately not what ...

archecker on IDS 11.50 TC3 (windows 32 bits) : tapesize seems forced to 2 Gb

Posted By Eric Vercelletto Thu August 24, 2023 10:00 AM
Found In Egroup: Informix \ view thread
Hi community, I am helping a customer on rescue operation in this environment (I know, not the best, migration to linux/current version planned within weeks). Basically extremely severe damage on their storage, IDS server totally exploded, same for their backup media, but they could finally ...

RE: Autenthication on IDS 11.50 server on WINDOWS

Posted By Eric Vercelletto Tue July 25, 2023 04:11 AM
Found In Egroup: Informix \ view thread
Hi Andreas, Thanks for enhancing my security culture, I need that LOL! The question is that we are talking about IDS 11.50, and iMO REMOVER_SERVER_CFG has been introduced in 12.10 XXN ( or even 14.10, not sure). I will apply the hosts.equiv as you said. Thanks and have a great day! ERic ...

Autenthication on IDS 11.50 server on WINDOWS

Posted By Eric Vercelletto Mon July 24, 2023 11:51 AM
Found In Egroup: Informix \ view thread
Hi Folks I hope everybody is doing good I have a stupid question regarding security on windows for a user to be authenticated on a xNIX IDS server, you need either to declare the client hosts in /etc/hosts.equiv file + declare a ~/.rhost file is the user's directory on the IFMX server OR starting ...

onsmsync used to recycle backups : how effective is it?

Posted By Eric Vercelletto Tue June 20, 2023 12:55 PM
Found In Egroup: Informix \ view thread
Hi Folks, I have been installing PSM at my customers and deployed SPL controlled by the IFMX scheduler. I have been testing onsmsync with different options to clear the backup objects. The options I use are -t "datetime"-I number of days-g generations number to retain I am doing fine ...

RE: Licensing question

Posted By Eric Vercelletto Mon April 24, 2023 10:14 AM
Found In Egroup: Informix \ view thread
Snori My understanding is that if no user nor client process connects to the RSS Secondary , this is Cold If one of them connects (even for readonly), this is warm. But effectively, IBM writes their contracts so that they can SAY something and write another thing about the same topic, maintaining ...

RE: how to cap sessions memory limit for STORED PROCEDURES/FUNCTION

Posted By Eric Vercelletto Mon April 24, 2023 06:03 AM
Found In Egroup: Informix \ view thread
Hi Andreas Interesting info. The question is that we just moved from FC5 to FC9, because customer doesn't like installing the very last fixpack in general. So I will proceed this way: Check who runs the UDR, if Informix or proc set as DBA, I will test with a 'normal' userTest with FC10 Will ...

how to cap sessions memory limit for STORED PROCEDURES/FUNCTION

Posted By Eric Vercelletto Mon April 24, 2023 04:42 AM
Found In Egroup: Informix \ view thread
Hi Friends, colleagues etc my customer is running 14.10 FC9 Workgroup Edition (max 24 Gb of SHMEM in total) (just upgraded for 14.10 FC5) on linux REd hat. He is intensively using stored procedures, and among those, some recursive ones. Fortunately, we identified some procedures that, according ...

RE: Help to understand this sqexplain (now with plain)

Posted By Eric Vercelletto Thu July 21, 2022 01:14 PM
Found In Egroup: Informix \ view thread
Leandro, First question: is this the first time this query is launched / has something changed in the query or IFMX version change ? Then At first glance, here are some ideas to check: Wow ! that 's a piece of query, of course it can take time because it looks very complex to optimizeAre your ...

RE: Help to understand this sqexplain

Posted By Eric Vercelletto Thu July 21, 2022 11:01 AM
Found In Egroup: Informix \ view thread
Leandro, Many people receive those messages thru email and have either no time nor possibility to log into a webpage. So please post the query plan in the message and not as attached document if you want more people look at it �� Thanks Eric

RE: AWS Snapshot and Informix IDS

Posted By Eric Vercelletto Thu June 23, 2022 10:28 AM
Found In Egroup: Informix \ view thread
I would say same as Art: I am not a big fan either of snapshots: the problem is that a snapshot is just a physical image of your chunks, and you have absolutely no control on what happens with your transactions + you'll have to forget about logical logs recovery (meaning if you are unlucky, you may lose ...

RE: Problem with EXTERNAL TABLE

Posted By Eric Vercelletto Thu June 02, 2022 02:51 AM
Found In Egroup: Informix \ view thread
Mark, I can see you create ext table does not feature à reject file that may report you errors at the row level. Did you try this? Obtenir Outlook pour Android

RE: CPU VPs configuration on VMWARE

Posted By Eric Vercelletto Wed May 18, 2022 10:53 AM
Found In Egroup: Informix \ view thread
Henri, If I read what I wrote, it would mean 50 cores, 100 CPUVPs so we seem to be in line ��