List of Contributions

Eric Vercelletto

Contact Details

My Content

1 to 20 of 50+ total

RE: IDS 14.10.FC5 on Ubuntu 20.04 - can't start shm listener

Posted By Eric Vercelletto Feb 27, 2021 10:27 AM
Found In Egroup: Informix \ view thread
Ask Art K �� Eric Vercelletto Data Management Architect and Owner / Begooden IT Consulting KandooERP Founder and CTO IBM Champion 2013,2014,2015,2016,2017,2018,2019,2020 Tel: +33(0) 298 51 3210 Mob : +33(0)626 52 50 68 skype: begooden-it Google Hangout: eric.vercelletto@begooden-it.com Email: ...

RE: backup tables

Posted By Eric Vercelletto Feb 19, 2021 4:11 AM
Found In Egroup: Informix \ view thread
Hi again Amit, Best it you look at the doc and these examples which are very good for what you want to do. https://www.ibm.com/support/knowledgecenter/SSGU8G_14.1.0/com.ibm.sqls.doc/ids_sqs_2068.htm Cheers Eric Eric Vercelletto Data Management Architect and Owner / Begooden IT Consulting KandooERP ...

RE: backup tables

Posted By Eric Vercelletto Feb 19, 2021 3:15 AM
Found In Egroup: Informix \ view thread
Hi Amit, I would prefer inserting the existing tables contents into external tables which are the image of the existing tables. Unload is slow or HPL but much more complex to activate ------------------------------ [eric] [Vercelletto] [] [Founder] [kandooerp.org] [Pont l'Abbé] [France] [+33 626 52 ...

RE: Validate backup : archecker –tdsv and CommVault

Posted By Eric Vercelletto Feb 11, 2021 5:59 AM
Found In Egroup: Informix \ view thread
I have a customer at which we tested Commvault direct to onbar, but at the end it remained very slow even playing with onbar onconfig parameters. At the end we decided to use PSM, then comvault takes the PSM files as normal file systems. => backup is done much quicker and you depend less on Commvault ...

RE: How can I see in sysmaster if my instance is 'currently running a checkpoint'

Posted By Eric Vercelletto Jan 27, 2021 2:18 AM
Found In Egroup: Informix \ view thread
Works like a charm! Thanks bunches my friend! Eric Vercelletto Data Management Architect and Owner / Begooden IT Consulting KandooERP Founder and Community Manager IBM Champion 2013,2014,2015,2016,2017,2018,2019,2020 Tel: +33(0) 298 51 3210 Mob : +33(0)626 52 50 68 skype: begooden-it Google Hangout: ...

How can I see in sysmaster if my instance is 'currently running a checkpoint'

Posted By Eric Vercelletto Jan 26, 2021 6:01 AM
Found In Egroup: Informix \ view thread
Hi Folks, I have tried looking into the sysmaster.sql file which is pretty well documented, but apparently my personal search engine is not efficient enough. I want to detect the 'Checkpoint In Progress' engine status with a query ( I know how to do it with onstat �� ) I have found something like the ...

RE: moving to virtual servers, have questions

Posted By Eric Vercelletto Jan 25, 2021 12:04 PM
Found In Egroup: Informix \ view thread
Brad, Not original answer but I go Art's way about the trust on IFMX replication. Deadly simple to setup and admin, never fails, and more flexible in terms of functionality. With HDR + RSS you can ensure both High Availability and DRP scenarios in the lapse of a few seconds. I have a customer who ...

RE: syssqltrace time fields

Posted By Eric Vercelletto Jan 14, 2021 9:16 AM
Found In Egroup: Informix \ view thread
dSergio, depending on which columns you are talking about, but AFAIK these columns are expressed in seconds.xxxxx (5 digits after decimal point) Some other columns are expressed in UTC, but they are not durations, the are timestamps. Use the dbinfo(utc_to_datetime, value) to convert to a timestamp ...

RE: Centos EOL

Posted By Eric Vercelletto Jan 14, 2021 9:13 AM
Found In Egroup: Informix \ view thread
Sergio Our religion forbids to use anything called OracleXXX �� I heard different things about Centos (Which I use and like a lot). Apparently community support will continue, and I also heard that Red hat was no more directly involved in the project for some time already. So what is the future? ...

RE: Informix + PAM + AD + CentOS Samba Update Issue

Posted By Eric Vercelletto Dec 18, 2020 11:27 AM
Found In Egroup: Informix \ view thread
Thanks for the warming Tom! Also nice to hear that Red Hat will stop supporting CentOS ....

RE: Informix OLTP benchmark

Posted By Eric Vercelletto Dec 17, 2020 6:27 AM
Found In Egroup: Informix \ view thread
It's all the source code You can find it there https://sourceforge.net/projects/iiug-software-repository/files/ESQL/tpc-c-ifmx/ Eric Eric Vercelletto Data Management Architect and Owner / Begooden IT Consulting KandooERP Founder and Community Manager IBM Champion 2013,2014,2015,2016,2017,2018,2019,2020 ...

RE: Informix OLTP benchmark

Posted By Eric Vercelletto Dec 17, 2020 4:42 AM
Found In Egroup: Informix \ view thread
Hi Josef, I never tested on Windows, but since ESQL/C can work on windows, theory says it should work. Best would be to install a gcc compiler on windows, that would probably avoid library issues. Regards Eric

RE: Informix OLTP benchmark

Posted By Eric Vercelletto Dec 17, 2020 2:56 AM
Found In Egroup: Informix \ view thread
Hi Josef, I have put a 'simili-tpc-c benchmark available in the IIUG Repository on sourceforge. It is exactly done for that purpose You need IDS and CSDK and gcc, because the bench is written in ESQL/C Please private me if interested Eric

RE: Foreign Data Wrapper(s)

Posted By Eric Vercelletto Dec 10, 2020 2:45 AM
Found In Egroup: Informix \ view thread
Since this forum is used for third party product advertising, I cannot help myself to mention Querix Lycia which also has the capacity to address multi DBMS vendor from the same program. Effectively addressing your issue using a language that can address multiple dbms can be one solution for a specific ...

RE: How to stop Defragmenter cleaner thread on startup ?

Posted By Eric Vercelletto Dec 4, 2020 1:06 PM
Found In Egroup: Informix \ view thread
Sorry to disturb in that case Eric Vercelletto Data Management Architect and Owner / Begooden IT Consulting Board of Directors, International Informix Users group IBM Champion 2013,2014,2015,2016,2017,2018,2019,2020 Tel: +33(0) 298 51 3210 Mob : +33(0)626 52 50 68 skype: begooden-it Google Hangout: ...

RE: How to stop Defragmenter cleaner thread on startup ?

Posted By Eric Vercelletto Dec 4, 2020 10:02 AM
Found In Egroup: Informix \ view thread
Ok, just checking �� Why don't you try Art Kagel Do Stats ? It is smarter than AUS, better implemented and free Art will give you where you can find it Eric

RE: How to stop Defragmenter cleaner thread on startup ?

Posted By Eric Vercelletto Dec 4, 2020 9:21 AM
Found In Egroup: Informix \ view thread
Ivan, Not sure that running update statistics "on demand" is the best practice. Statistics are critical to have the optimizer do its job the best way. If you ever forget to have them up to date, your best queries may run slow. Also disabling all the tasks may not be so good. Just my 0.002 cent ...

New folder in the IIUG Software repository for functions/stored procs

Posted By Eric Vercelletto Nov 25, 2020 5:37 AM
Found In Egroup: Informix \ view thread
Hi All, after some discussion in another forum, I came to the following conclusion: Many of us are requesting to have a number of very handy SQL functions or Stored procedures that are included in other popular DBMS. THis might be the right time to gather requirements for future versions, but also ...

RE: Space free , sysmaster and onstat_d output are different !!!!!

Posted By Eric Vercelletto Nov 23, 2020 6:00 AM
Found In Egroup: Informix \ view thread
« The good teacher is the teacher that pushes the pupil to ask himself the good questions and triggers the little thing that makes him start the right reasoning, then answer by himself �� "

RE: Table Extent Size calculation

Posted By Eric Vercelletto Nov 18, 2020 10:40 AM
Found In Egroup: Informix \ view thread
And I would add: NEVER count on storage pool to get rid of this calculation (which is fun and a first-do exercise thing for IDS beginners). If you let the Storage Pool manage the growth of your table, you will probably end your first load with TONS of extents. This happened to one of my customer who ...