List of Contributions

Fernando Nunes

Contact Details

My Content

1 to 20 of 40 total

RE: Light Append Buffers

Posted By Fernando Nunes Thu December 03, 2020 06:04 PM
Found In Egroup: Informix \ view thread
Depending on the version you're using, loopback ER seems a very nice way to reorg tables.... if you can spare the space. No real life experience with is at this moment... Regards. ------------------------------ FERNANDO NUNES ------------------------------

RE: Control of CLIENT_LOCALE and DB_LOCALE at connection (doc issue?)

Posted By Fernando Nunes Thu October 29, 2020 03:37 PM
Found In Egroup: Informix \ view thread
Until some 9.40 fixpack (TC9?) the verification was permissive. This led to many customers having a nasty situation: Database locale set to 8859-1 (default on Unix/Linux) and Windows client not having the DB_LOCALE set, assumed CLIENT_LOCALE and DB_LOCALE set to 1252 (windows codeset). This effectively ...

RE: Strange message in online.log

Posted By Fernando Nunes Wed May 20, 2020 06:31 AM
Found In Egroup: Informix \ view thread
Seems to be a cosmetic bug: https://www.ibm.com/support/pages/apar/IT30689 Open a support ticket to be sure. Regards ------------------------------ FERNANDO NUNES ------------------------------

RE: joins using unique index with some null values

Posted By Fernando Nunes Thu March 19, 2020 04:18 PM
Found In Egroup: Informix \ view thread
You have to explicitly call out the nulls: where (a=b or (a is null and b is null)) and ...... Jack Parker, Thu March 19, 2020 03:02 PM Correct. And if there are no restrictions that make this a light nested loop (or in other words if you're joining large sets of both tables), then you're probably ...

RE: IIUG Insider February 2020 and Informix roadmap

Posted By Fernando Nunes Thu March 05, 2020 05:27 PM
Found In Egroup: Informix \ view thread
I can't really "undress" my IBM clothes, but my answer is not an official answer. First, let me ask... Can anyone point me to 3 competitor products for which a roadmap is available publicly? I keep getting this question from customers (not only for Informix), and I always ask the question above... ...

RE: Last day in the family?

Posted By Fernando Nunes Wed February 19, 2020 06:18 PM
Found In Egroup: Informix \ view thread
Wow... I almost miss this thread. Best wishes and make sure you keep your stats up to date! :) Regards ------------------------------ FERNANDO NUNES ------------------------------

RE: ODBC Authentication Setup

Posted By Fernando Nunes Wed February 19, 2020 05:59 PM
Found In Egroup: Informix \ view thread
Hi, Returned from Whatsapp... I read the post several times, and each time I get the same feeling: I'm confused. And it's not really your fault, except in one point: You don't mention your needs. Just want you tried, or intend to try. And you have several concepts in your post, and then there are ...

RE: How to find & fix corrupted Index

Posted By Fernando Nunes Fri January 17, 2020 01:52 PM
Found In Egroup: Informix \ view thread
What is the column datatype (the column with the WHERE condition)? What is the isolation level that you are using? You should run the "wrong" query with a directive to avoid INDEX SKIP SCAN... I would have to look it up... I see 3 possible issues conditioning this, but sounds like a bug...: ...

RE: index exclusivity

Posted By Fernando Nunes Fri January 17, 2020 01:44 PM
Found In Egroup: Informix \ view thread
Sérgio, Latest versions have information in "onstat -pT": Maximum row size 134 [...] Partition partnum 8389067 Partition lockid 8389066 Last Lookup/Scan Tue Jan 8 11:22:53 2019 This information was supposed to be in sysmaster, but I couldn't find it. This tells you ...

RE: integer to serial conversion

Posted By Fernando Nunes Mon December 30, 2019 10:48 AM
Found In Egroup: Informix \ view thread
Art, I believe it's not documented anywhere (knowledge center). It's on a presentation for this year's IIUG conf (*SQL Features*). Another incredible case of good things being trashed by lack of documentation... I've tried to fight that war several times... Probably only a handful of customers know ...

RE: integer to serial conversion

Posted By Fernando Nunes Mon December 30, 2019 08:16 AM
Found In Egroup: Informix \ view thread
Sérgio, The feature Paul is referring to (I think) is implemented in 12.10.xC12W1+ To be clear, you don't need to do the alter on the child table. The SERIAL will generate a new value when you INSERT (with a 0) on the parent table. When you INSERT on the child table you just use the parent's table ...

RE: onpladm help please!

Posted By Fernando Nunes Fri December 27, 2019 02:10 PM
Found In Egroup: Informix \ view thread
Sérgio, onpladm is an utility to create jobs for HPL (High Performance Load). This works on a table level and not on a database level. Besides that, HPL is somehow deprecated as you can have similar functionality (and performance) with external tables. I believe that Art's tools (myexport?) allow ...

RE: 9700: Routine (plus) ambiguous - more than one routine resolves to given signature.

Posted By Fernando Nunes Tue December 17, 2019 07:01 PM
Found In Egroup: Informix \ view thread
Aha! Now you have the most useful query ever working! :) ------------------------------ FERNANDO NUNES ------------------------------

New RFE for your consideration

Posted By Fernando Nunes Tue December 17, 2019 06:59 PM
Found In Egroup: Informix \ view thread
The following RFE comes from a real need of an European customer but I think it could be useful to a lot more customers. Currently old client versions, OleDB (not sure about .NET) and some 3rd party drivers can't connect to PAM enabled listeners. This doesn't really make sense if the PAM listener ...

RE: Are there many customers using Informix version 14.10?

Posted By Fernando Nunes Thu December 12, 2019 04:48 PM
Found In Egroup: Informix \ view thread
The "edition", or whatever it's called this week :) is a property of the INFORMIXDIR... Not the instance. So, whenever you install one fixpack you need the "key" in the same installation folder. Did you uncompress the FC3 "key" to the installation folder, prior to installing FC3? If not, it ...

RE: Are there many customers using Informix version 14.10?

Posted By Fernando Nunes Thu December 12, 2019 09:52 AM
Found In Egroup: Informix \ view thread
This is one of the most annoying discussions we can have :) I believe I already stated my perspective here (or other forums before), but here goes again... First, let me state I fully understand your situation, and even customers concerns, but I do believe it misses some points which are important. ...

RE: Table partition, ONLINE detach/attach issues.

Posted By Fernando Nunes Fri December 06, 2019 01:11 PM
Found In Egroup: Informix \ view thread
César, Some short notes: 1- The documentation is misleading. Never use ATTACHED indexes. Whoever wrote this was thinking on having one index partition per index per table fragment 2- Your CREATE INDEX is wrong because it explicit a fragmentation strategy. Although you use the same, that's not ...

RE: Table partition, ONLINE detach/attach issues.

Posted By Fernando Nunes Wed December 04, 2019 08:21 AM
Found In Egroup: Informix \ view thread
Hello César, You're making a confusion between attached indexes ("in table") and indexes that follow the same strategy as the table. The attached indexes are, as you correctly state, deprecated and should not be used. What the feature requires is indexes that follow the same strategy as ...

RE: Reviving of an old RFE that should have more votes: 16 millions data pages limitation

Posted By Fernando Nunes Fri November 08, 2019 10:17 AM
Found In Egroup: Informix \ view thread
When you reach the 16M "used pages" you may still work because not all the pages are full and the engine may found some slots to INSERT new rows. But the best practice would be to trigger the alarm long before you reach the 16M used pages... If you want to be conservative you can set it to ...

RE: Reviving of an old RFE that should have more votes: 16 millions data pages limitation

Posted By Fernando Nunes Thu November 07, 2019 06:23 PM
Found In Egroup: Informix \ view thread
Regarding the timely warning, in the following link you can find a "framework" for scheduler tasks. One of them is just for that (monit_check_numpages.sql): https://github.com/domusonline/InformixScripts/tree/master/monit Regards. ------------------------------ FERNANDO NUNES - ...