List of Contributions

khaled Bentebal

Contact Details

My Content

1 to 20 of 34 total
Posted By khaled Bentebal Wed April 24, 2024 12:07 PM
Found In Egroup: Informix
\ view thread
The best is to mirror everything of course. If you want to mirror some dbspaces, you should at least mirror the main dbspaces that include systems information : rootdbs, logsdbs, physdbs. If any of these 3 dbspaces have problems, without mirroring, the instance goes down; with mirroring you are saved. ...
Posted By khaled Bentebal Mon April 15, 2024 11:05 AM
Found In Egroup: Informix
\ view thread
Art, That is not completely true. You still had to do it up to version 14.10.xC6. Deprecated from 14.10.xC7 on The evolution was easy to do since they only initialized the page in the reserved pages that contains the mirror chunks information (onchek -pr will shwo yhou that or a dump in hex of the ...
Posted By khaled Bentebal Mon April 15, 2024 07:45 AM
Found In Egroup: Informix
\ view thread
Hi Henry, The following are some of the solutions possible. A) On the same server, from easier and less dowtime to more complicated and more dowtime 1/ Mirroring - no downtime; if you already have mirroring in place for some of the chunks, you need to reset each individual mirrored chunk first ...
Posted By khaled Bentebal Mon April 08, 2024 11:56 AM
Found In Egroup: Informix
\ view thread
Hi, Yes Informix SE ( standard engine) is still sold and works just fine the way it is supposed to work. It has not evolved for some time now, but still very reliable and you can use Informix 4gl with of course. Of course nothing to compare to informix IDS. Khaled Bentebal de mon portable
Posted By khaled Bentebal Fri March 15, 2024 10:00 AM
Found In Egroup: Informix
\ view thread
Hi Indika, Here is an official link for all of IBM products and releases: https://www.ibm.com/support/pages/lifecycle/ Just type in informix and you will get all of the information regarding the Product Lifecycle for any IBM Informix product. Here is an example for Informix V12.10.x http ...
Posted By khaled Bentebal Tue March 12, 2024 09:36 AM
Found In Egroup: Informix
\ view thread
Hi Amit, All of the IBM products have a Product Lifecycle and have a policy type (Standard, Enhanced, etc). Each poilicy has its own rules. Enhanced:??Lifecycle policy Enhanced provides defect and non-defect product technical support for a minimum of five years from the date the product release was ...
Posted By khaled Bentebal Thu February 22, 2024 08:48 AM
Found In Egroup: Informix
\ view thread
Art, It seems that you are also promoting Querix in your email. My answer is direct does SOAP and not REST does not scale monothreaded does not handle a large load and not geared towards real life web intensive environment An ex manager at IBM Informix even told me not to use it since ...
Posted By khaled Bentebal Thu February 22, 2024 08:16 AM
Found In Library: Informix
Posted By khaled Bentebal Thu February 22, 2024 08:16 AM
Found In Egroup: Informix
\ view thread
Hi, Informix Web services solution has been in the Informix 4GL product for some time. However, it has not evolved for at least 15 years . does SOAP and not REST does not scale monothreaded does not handle a large load and not geared towards real life web intensive environment We at ...
Posted By khaled Bentebal Mon February 12, 2024 10:46 AM
Found In Egroup: Informix
\ view thread
Hi Ondrej, The UPTIME at the informix instance level is the elapsed time from when you started your engine (instance). If you bring the engine down and restart, the UPTIME starts from 0 again. It is not based on the system time. As long as the instance is up, the UPTIME increases; the longer the better ...
Posted By khaled Bentebal Thu October 12, 2023 12:54 PM
Found In Egroup: Informix
\ view thread
HI, Informix 4GL (both the compiled version Informix 4GL Compiled as well as the p-code version being Informix 4GL RDS and its debugger Informix 4GL RDS Interactive debugger) definitely works on Linux ( different distributions available). The actual version is 7.51.FC3. Very stable and a ...
Posted By khaled Bentebal Wed July 26, 2023 10:11 AM
Found In Egroup: Informix
\ view thread
Hello all, IBM will allow you to sell Informix or any other product from their portfolio. Now, whether you can sell in your country or other countries depends on your geography and the rules might be different from one geography to another. IBM is happy to sell Informix or any other product as a matter ...
Posted By khaled Bentebal Tue March 07, 2023 09:28 AM
Found In Egroup: Informix
\ view thread
Jared, ER works at the SQL level not the physical level. You can migrate using ER from any system ( Aix, HP UX, Linux, ...) to any another system and no matter what Informix version. You can migrate from 11.5 to 14.10 for example and also going from 14.10 to 11.5 if you want. Very much different from ...
Posted By khaled Bentebal Wed March 01, 2023 07:35 PM
Found In Egroup: Informix
\ view thread
David, Jared, I will try to answer point 2 regarding the structure of the index. David, your assertion on the page splitting and the levels of an index or what I call the depth of the index tree is not correct (all of the leaves are ate the sale level). Let me explain in more details but not ...
Posted By khaled Bentebal Mon February 20, 2023 08:02 AM
Found In Egroup: Informix
\ view thread
Hello Sebastien, A quick answer is that the behavior is NORMAL fllowing the 6 statements that you used. Let me go explain in mode detail what is happening. DECLARE c1 CURSOR FOR SELECT * FROM tab1 FOR UPDATE in statement 1 This statement declares?? a structure at the front ...
Posted By khaled Bentebal Thu December 22, 2022 09:50 AM
Found In Egroup: Informix
\ view thread
Hi Gustavo, TAPEBLK was used in the past to define the block size that allows you to write to tape. It used to be small since it was based on the value that was accepted by the TAPE device itself. After moving backups to disk, we use a value much bigger to speed up the backups (2048 for example ...
Posted By khaled Bentebal Mon November 28, 2022 12:26 PM
Found In Egroup: Informix
\ view thread
Hello Stephane, We have a couple of customers that use ESQL/Cobol. We also tried to download ESQL/COBOL last week and it is not available for download any longer. I advise you to contact the IBM product manager or the IBM offering manager. -- Cordialement, Regards, Khaled Bentebal ...
Posted By khaled Bentebal Sun November 06, 2022 04:55 AM
Found In Egroup: Informix
\ view thread
David, Buffer pool size does do affect the optimizer. The optimizer works based on the statistics existing at the time of finding the best path and the selectivity factors of each clause in the query( =, matches, or, and, etc) and whether you have indexes or not ( the uniqueness of indexes is taken ...
Posted By khaled Bentebal Thu October 27, 2022 10:29 AM
Found In Egroup: Informix
\ view thread
Hi Tereso, Your reports run slower. Are you using ORDER BYs or GROUP BYs in your reports that are slower. If that is the case, you can try changing the DS_NONPDQ_QUERY_MEM to a higher value and run the reports again. Do noy make this too big since it applies to all of the sessions. You ...
Posted By khaled Bentebal Wed October 19, 2022 02:24 PM
Found In Egroup: Informix
\ view thread
You can of course have updatable secondaries. There is a parameter in the onconfig that needs to be turned on.The updates get rerouted through the primary and reapplied to the secondary.It is very slow depending on what you want to do. If it is for an update here and there, ok. However if you want to ...