List of Contributions

Cesar Martins

Contact Details

My Content

1 to 20 of 32 total

RE: Nasty Redhat issue ..

Posted By Cesar Martins Thu July 13, 2023 01:20 PM
Found In Egroup: Informix \ view thread
Ok, thank you for the update. I was hopeful because the RH article has the status: SOLUTION IN PROGRESS This solution is in progress and will be completed soon for Red Hat customers. ------------------------------ Cesar Martins ------------------------------

RE: Nasty Redhat issue ..

Posted By Cesar Martins Thu July 13, 2023 09:55 AM
Found In Egroup: Informix \ view thread
Hi Paul, Did you have any update from RHEL about this issue? Here we also hit this bug for the last 12 months, where our database freeze a few times and two times only this week. Now I'm planning to migrate to another FS, probably XFS... however, if we can have any hope to keep the EXT4, ...

RE: shmget: [ENOSPC][28]: key 525f4802: The server could not allocate shared memory because an operating system limit was reached

Posted By Cesar Martins Wed November 30, 2022 09:06 AM
Found In Egroup: Informix \ view thread
Hi Kate, A few weeks ago, our main engine became to get into the same problem here , IFX 12.15FC15 / RH 7.4. Here, at least three times the instance crashed with AF and memory dump because they aren't able to allocate more memory. However, our configuration is set the same for years and never ...

RE: Tales about end of life

Posted By Cesar Martins Mon September 12, 2022 10:33 AM
Found In Egroup: Informix \ view thread
Hi Art, Yes, I did something like that. I forward the link of the roadmap from the IIUG to them. However, I'm just a customer, this work should be done by IBM+HCL , not me!!! I already spend my time trying to help, improve Informix here in Brazil, We see nothing from IBM/HCL giving any advertising ...

Tales about end of life

Posted By Cesar Martins Mon September 12, 2022 07:35 AM
Found In Egroup: Informix \ view thread
Hi , To HCL, It's very sad, after 21 years after IBM bought Informix, I still hear (read) from other IT companies this: "We've also been hearing that Informix might reach end-of-life soon, which would be something we'd have to consider as we think about a native integration." I'm researching ...

RE: IBM data studio and SPL debug

Posted By Cesar Martins Thu September 08, 2022 10:53 AM
Found In Egroup: Informix \ view thread
Hi Art, Thank you! I will test it!

RE: IBM data studio and SPL debug

Posted By Cesar Martins Thu September 08, 2022 08:13 AM
Found In Egroup: Informix \ view thread
Hi , Does anyone use Optim Development Studio to debug SPL ? I'm looking where to download it or a trial and appears they don't exist anymore on IBM site or the name of the product changed .... I really want to test any tool to debug SPL on Informix. Everything appears to be an old solution that ...

RE: PDF documentation is available!!!

Posted By Cesar Martins Wed October 27, 2021 07:17 AM
Found In Egroup: Informix \ view thread
Hi Paul, Go thru the library main link, then you will see :

RE: PDF documentation is available!!!

Posted By Cesar Martins Wed October 27, 2021 07:11 AM
Found In Egroup: Informix \ view thread
Awesome!!!Thank you!!!

RE: temp table performance issue on IDS 14.10FC3 EE

Posted By Cesar Martins Wed September 22, 2021 01:48 PM
Found In Egroup: Informix \ view thread
plus: since 12.10.FC14 : Enhanced TEMP DBspace Resiliency Whenever you start the database server, all chunks in temporary dbspaces are recreated from scratch. These chunks can therefore be located on RAM drives if desired. This means, if your Linux has considerable ram memory free, you can ...

RE: PDF documentation

Posted By Cesar Martins Mon September 13, 2021 02:43 PM
Found In Egroup: Informix \ view thread
Hi Art, RFE?? really? ouch! In this case what means? Request Feature Expired ??? :DRFE I always considered for things that don't exist, not what exists and was abandoned... :,( Anyway, I look for and found only this: https://ibm-data-and-ai.ideas.ibm.com/ideas/ISP-I-105 Who still consider PDF versions ...

PDF documentation

Posted By Cesar Martins Mon September 13, 2021 02:16 PM
Found In Egroup: Informix \ view thread
Hi, Does anyone know about PDF version of the manual? If there is any intention from IBM/HCL to release or we will be forced to stay online to check the Informix documentation? I miss a lot the old and good PDFs library, mainly know were I focused to prepare our production to migrade from 12.10 ...

RE: 4GL application performance over TCP / IP connections

Posted By Cesar Martins Thu August 26, 2021 07:42 AM
Found In Egroup: Informix \ view thread
Hi !I already experienced exactly the same situation years ago.My considerations: You will never achieve the same performance for applications with a high volume of embedded SQL in 4gl (where the network communication became the bottleneck). You are able to see this executing a tcpdump between 4gl ...

RE: SSL Listener not getting started in Solaris 10 and Informix 11.5 Combination.

Posted By Cesar Martins Thu June 24, 2021 01:45 PM
Found In Egroup: Informix \ view thread
Hi, I use SSL since version 11.50 on AIX and Linux without major issues. Have you set the basics? You can found all these commands and references on the Informix manual. a) Have you the IBM GSKIT installed? if not, install, it's mandatory. b) Have created the SSL stash / "database" for ...

RE: 14.10.FC4W1 - update + from

Posted By Cesar Martins Fri January 15, 2021 09:57 AM
Found In Egroup: Informix \ view thread
Hi Andreas, Hmmm, no, what I would like to know is if the syntax below is safe and supported, perhaps not documented, I want to stop using updates+subselects and merge as a workaround. Waiting for this resource for a loooooooong time. If you ran my little script on 14.10 you will see they work. ...

14.10.FC4W1 - update + from

Posted By Cesar Martins Fri January 15, 2021 07:49 AM
Found In Egroup: Informix \ view thread
Hi, Does anyone know if its safe to use the update + from syntax on version 14.10? There is no documentation and no mention in "what news", however the syntax below works! create temp table tp1 ( cod int , nome char(10)) with no log ; create temp table tp2 ( cod int , nome char(10)) ...

RE: Informix Enterprise Gateway Manager Error

Posted By Cesar Martins Fri September 11, 2020 09:11 AM
Found In Egroup: Informix \ view thread
if you can, test using version 12.10 .. all works fine with it.

RE: Informix Enterprise Gateway Manager Error

Posted By Cesar Martins Fri September 11, 2020 08:44 AM
Found In Egroup: Informix \ view thread
correction:I have an SB were solved this and the problem is on version 14.10.FC4W1

RE: Informix Enterprise Gateway Manager Error

Posted By Cesar Martins Fri September 11, 2020 08:28 AM
Found In Egroup: Informix \ view thread
ouch, I just remember; you probably get into a defect. I just remember that I got an issue like this. I have an SB were solved this and the problem is on version 14.10.FC3W1 My SB is 14.10.FC4W1X3 Maybe you need to wait for the FC4W2 , FC5 os ask for an SB to your environment. The defect : APAR ...

RE: Informix Enterprise Gateway Manager Error

Posted By Cesar Martins Fri September 11, 2020 08:22 AM
Found In Egroup: Informix \ view thread
One correction, here we access sqlserver 2017 too, without any issues. What you can do to try to identify what happens is uncomment at informix.rc the line GWDEBUG 121,122,123 Don't need to restart the EGM. Just rerun your sqlThen you will see a file at /tmp/egmt.* Take a look, maybe you able to ...