Threads from 2025
Browse by month: Jan · Feb · Mar · Apr · May · Jun · Jul · Aug · Sep · Oct · Nov · Dec
Rootdbs initially in a large chunk
Hi again Family. I want to create a totally new instance and start the rootdbs at 20GB, rather than the old (pre IDS-10) default max chunk size of 2GB. I don't have the new machine yet so I can't try it myself. Is this doable or will that first oninit -i barf at that large first…
Update to myexport
I have just uploaded an update to the myexport package that includes a new option, -g <table list> which implements the equivalent of the dbexport option -no-data-tables=<table list> to specify tables that are to be exported as DDL only by no data unload. As usual, you can downlo…
What is the load on an individual listener or sqlexec thread?
(Deep breath ;-) Greetings, Family. I can see if a specific thread is getting used lot: Just run onstat -g cpu: Thread CPU Info: tid name vp Last Run CPU Time #scheds status 2 lio vp 0 3lio* 12/30 03:36:02 0.0000 …
REMOTE_SERVER_CFG issue/question
All, I tried posting this via the web, but every time I click on the "Post" link, I get a pop-up stating: Access Denied You don't have permission to access "http://community.ibm.com/higherlogic/ui/mvc/contributedcontent/contributedcontent/createQuestion" on this server. Reference…
How can I reconstruct foreign key constraints from system catalogs?
Hi again, Family. At least 10 years ago I posted a question about retrieving information of foreign key constraints. Of course, we have a method to get this in dbaccess: dbaccess <database> -> Query-language -> Info -> (Select table) -> cOnstraints (Press letter O) -> Reference…
Table with no primary key has many referencers via foreign keys
Greetings, Family. I was asked to create a table, say child_tab, with a FK constraint referencing daddy_tab. No problem, says I: alter table child_tab add constraint foreign key(some_code) references daddy_tab constraint fk_child_daddy; 297: Cannot find unique constraint or prima…
How to alter a table become a read only one?
Hi, The develop DBA want to change some tables to read only , include the DBA himself can't update/insert/delete those record also. Do anyone have experience how to implement it in informix? The document told me "You cannot revoke privileges from yourself." Any suggestion are we…
IIUG & WAIUG TechTalk December 11
IIUG And WAIUG Tech Day – Dec 11th 2025 December 11 @ 9:30 am - 1:00 pm EST Free Join the WAIUG (Washington Area Informix User Group) in partnership with the IIUG for a free half day technical webinar from some of the best talks at IBM TechXchange with some additional information…
Which VPN is a listener thread attached to?
Hi again, folks. I can run onstat -g ntd and get something like: Client Type Calls Accepted Rejected Read Write sqlexec yes 239551 150184 161200133 161090285 srvinfx yes 0 0 0 0 onspace y…
What would cause a port to freeze up and ignore connection requests?
Greetings, Y'all! We just had an interesting situation, which is not a good thing in this business. All applications that connect through s certain port number (as determined by $INFORMIXSERVER) were hanging. When I connected through a different server alias - which maps to a di…
Need help for Usage of "UTL_FILE_GET_LINE"
Hello, When I use UTL_FILE_GET_LINE I always get the error: (EXC04) - Message cannot be found. Version 15.0.0.2 on Ubuntu. Trace shows, that the file is open: execute function informix.utl_file_is_open[procid=613] ( arg[0] = 0 ) expression: (select (<procedure> utl_file_is_open, …
ESQL/C DESCRIBE OUTPUT after OPEN (with DECLARE CURSOR name) fails with -410
Hello, With ESQL/C 4.50.FC10 (Linux Debian 12): I am trying to use the DESCRIBE OUTPUT instruction to get column information of a SELECT, after the PREPARE / DECLARE CURSOR / OPEN sequence. The idea here is to postpone the DESCRIBE OUTPUT after the OPEN, to potentially use the IF…
bson_update with special characters crashes session
Hi all! Following bson_update leads to a failure: # dbaccess charly - Database selected. > create table z_bson_test (b bson); Table created. > insert into z_bson_test values ('{"field1":"Nom","field2":"Chatelain"}'::json::bson); 1 row(s) inserted. > select b::JSON from z_bson_tes…
Checkpoints in the days of SSD drives
I'm wondering about recommendations for checkpoints in today's era of SSD drives. Online (as opposed to sqlturbo) dates back to when was it? '93? '94? And I'm assuming that's when the whole cache started and checkpoints. Disk I/O with a traditional HDD was very costly. You had t…
Python ODBC connection via ODBX to Informix SE C-ISAM Databases
I've installed the ibm.csdk.4.50.12.Linux.64.x86_64 on my Rhel 9 system together with unixODBC and I connect with success via bash shell to my Informix SE C-ISAM Databases. When I try to connect using Python with PyOdbc module, using the same DSN configured and working in shell, …
Checkpoints rarely occurring
We have clients still on Informix 11.70 on Windows. All of them were installed with the default settings regarding checkpoints. In fact the only changes to onconfig were to set the TAPEDEV to NUL. These 2 checkpoint values remain as shown. Installed by the install program as th…
Attaching a detached partition
Dear All, I'm trying to attach a detached partition back to the table , for which I took backup of detached partition. But I'm getting syntax error. I'm testing on my personal laptop. OS : Redhat 7.9 , IDS 14.10 but when I change the process as below, it works. could some please …
InformixHQ: In Performance/Sessions section: filter by "NOT informix"
In the aforementioned section of InformixHQ I can look for sessions owned by user "joe". I can do the same with onstat -g ses | grep joe . But in that same grep command I can also say: onstat -g ses | grep -v informix if I want to see all but informix sessions. What is the syntax…
Informix 15.0.0.2: Aggregate function group_concat now built-in created but the underlying functions are not.
Hi, we are currently testing Informix Server 15.0.0.2. On a fresh initialized DB (with oninit -i...) the group_concat() aggregate function is now built in. Which would be great. Additional info: In Informix 14 we had our own implementation of group_concat() based on community/doc…
Corrupted 4DB installation files on Fixcentral for AIX
Hello, It seem that these binaries are corrupted, as signature verification fails: Verfication of ISQL is oK openssl dgst -sha256 -verify informix.pem.pub.key -signature ibm.sql.7.51.FC4.AIX.64.ppc64.tar.cosign.sig ibm.sql.7.51.FC4.AIX.64.ppc64.tar Verified OK But verification of…
Edition installer doesn't seem to do anything.
My predecessor installed IDS 14.10.FC3 and never converted it to a another edition. Problem is, the database has reached it's 8gb storage limit. The previoius developer versions he used didn't have those limits, so he stuck with developer (DE) and now we've hit the limit. My fir…
DEFAULT value for NOT NULL column
Informix 14.10.FC11W1 Assume the following table definition: create table regional_users ( employee_num SERIAL, region CHAR(3), lastname VARCHAR(30), firstname VARCHAR(30), email VARCHAR(80), user_type CHAR(1) DEFAULT 'X' NOT NULL, ); If we try the following INSERT: INSERT INTO r…
DBD::Informix - Cannot unset AutoCommit for unlogged databases
Hi, Trying to use DBD::Informix. Oracle Linux Server 8.10 Perl v5.26.3 DBI 1.641-4 DBD::Informix 2018.1031 CSDK 4.50.FC5 Informix Dynamic Server 11.70.FC5XE When I execute $dbh_bl->{AutoCommit} = 0; Perl aborts with the above message, DBD::Informix - Cannot unset AutoCommit for u…
Informix version 15.0.0.2 is out!
Hi, Informix version 15.0.0.2 is out! https://www.ibm.com/docs/en/informix-servers/15.0.0?topic=overview-whats-new-in-informix Looks like the only change is adding support for "AlmaLinux release 8.10 (Cerulean Leopard) on aarch64 compatible processors (ARMv8)". https://www.ibm.co…
Compatibility inquiry – Informix Client SDK on Windows Server 2025
We are planning to deploy IBM Informix Client SDK on a Microsoft Windows Server 2025 (x64) environment, and would like to confirm the following: Is the current latest officially released version of Informix Client SDK 4.50.xC12 or 15.0.0.1? Has this version been officially tested…
Informix Systmaster presentation at the IBM TechXchange 2025
Folks, I will be presenting my latest Informix Systmaster presentation at the IBM TechXchange 2025 IBM TechXchange 2025: Managing and Optimizing the IBM Informix Server using the Sysmaster Database by Lester Knutsen Session ID 1325, Date: Tuesday, October 7, 2025 Description: Les…
External backups/restores and logical restoring of logs passed last Level-0 backup
Hi, We are considering doing disk snap-shots with external backups which are very fast, and still continue doing daily onbar level-0 and, of course, keep doing onbar logical log backups. One doubt we had, and could not find clear doc about this, is if it is possible to restore an…
Purge informix log file
Hi Experts, Our informix log file (which outputs from onstat -m or MSGPATH parameter in onconfig) isn't purged since years &7 has grown in size. Please help how to purge this file & does this requires shutdown. Any risk to DB if done in improper way? Thanks in advance Syed H ---…
PuTTY SSH and Telnet - Automation
The Summer 2025 version of PuttyDriver is available for anyone who uses the popular PuTTY SSH and Telnet client and is interested in applying automation or robotics to Legacy Applications (e.g. Informix 4GL) and Legacy Systems Administration. Files can be found on GitHub at https…
UUID
Is there an Informix function, either built-in or easily implemented, that will create a new UUID value? Ideally, something that could be used in an INSERT statement, for instance. Something like: INSERT INTO table_xyz ( uuid, name, rank, serial_nbr) VALUES (make_uuid(), "John …
Informix <..> DataDog Integration
If you or your client have Datadog in their monitoring portfolio and would like Informix included in their database monitoring portfolio, please considering upvoting it the integration request https://ibm-data-and-ai.ideas.ibm.com/ideas/INFX-I-681 . Also let your client contacts …
fix_ipa problem
Hello everyone, I am having problems running fix_ipa with partnums: fix_ipa -d xxx -t xx_t -P 5247109 Error: -217(0) on prepare of slot cursor. sqlerrm: st. sqlerrd[4] = 544. sqlerrp: . SQL: SELECT tv.dbsname, tv.tabname, tv.partnum, ss.pagenum::BIGINT AS pag…
Databases schema management tools for Informix
Hi! I would like to ask some suggestion about a database CI/CD and schema migration change tool for Informix (14.10). Our operation is using a lot of SP-s. Maybe somebody is using a similar tools (Liquibase, Flyway). Our problem is when the deployment want to compile the SP in a …
Getting current transaction ID
We are trying to debug an issue with transaction handling in Hibernate and JBoss. We want to see if a new transaction has been created in certain scenarios. So I did some research if it was possible to get the current transaction ID in SQL, but found nothing. But I did find the m…
HDR secondary server extends bufferpool to maximum on memory=auto
Hello, I have a strange(to me) case with a pair of HDR servers (14.10.FC11W1) on linux. The setup of BUFFERPOOL 2k is only memory=auto without other parameters. The other bufferpools are set the same way, but there is no such activity. The database has a number of CLOB columns wh…
Conversion halted because logs are not backed up
Hi again. My heels have not cooled since my last problem and I go another one. This keeps happening! Before trying the upgrade we meticulously run onmode -c and onmode -l and, as I watch the online log, I see a log backup start and finish. The we shut down the server and try th…
C UDR using mi_trigger_get_old_row() and mi_trigger_get_new_row()
I suspect you are getting a NULL rather that a valid row ptr, I believe it will be NULL cos you are in a SPL An MI_ROW pointer A pointer to the old row. NULL The function was one of the following: not successful. not in the trigger action. not in the FOR EACH row trigger. n…
LOG_STAGE_DIR: Insecure permissions and engine won't start up
This has got to be one of the weirder errors I've recently encountered. I've had weirder but not recently. ;-) We are trying to start up a new installation of release IDS-14.10 on a host and have set up the onconfig similar to onconfig files where it has been successful. One er…
Any concern if use JDBC 15 to connect with IDS 14.10.FC10W2?
Could I ask for advice if any concern to use JDBC version 15 with IDS 14.10.FC10W2? Would there be any back-compatiblity concern? Could we hit some performance issue if use this higher version of JDBC driver? Where could we get information from, regarding the difference between J…
Link to New features of InformixHQ 3.1.0 Webcast on Aug 21
Hello, can anybody send me link to today's Webcast? Registration link is not working currently - giving error -404. Thank a lot ------------------------------ Milan ------------------------------…
Need advice on preparation work before upgrading to IDS 15.0.0.1
Hi community, May I ask for your opinion and advice on preparations before upgrading IDS from 14.10 to 15.0.0.1? Thank you! So far, I've noted the followings are to be done prior to the upgrade: Check for outstanding IPA tables and settle them Arrage a full DB backup, in case req…
Ontape restore with differenct Db Chunk spaces
Hi all, hopefully this is an easy one for you all, but getting a straight answer at our end is eluding us. Periodically, we do a Live to Test restore of a level 0 backup. We are using ontape for the backup and restore. We've recently had a situation where the DB chunk names and s…
What does onstat header look like if there is blocking checkpoint in progress
This is a companion question to "how long has a transaction been running?" I have not encountered a blocking checkpoint indication in an onstat header in many years. If I run an onstat command every second in a script, piping to grep, what the header line look like so that I can…
How long has a transaction or query been running?
Hi Family. I've been quiet for too long so I'll make for that with two threads. How to tell if there is blocking transaction at the moment. This will be the subject of my next thread. How long has a transaction been running? And how long as a current query been running? That is…
oncheck warning,What impact will it have on the future?
Hi, expert: The customer restore the instance into another machine ,and run oncheck on the whole database, it report below errors . but I can't see those errors in the production environment. TBLspace data check for gapsdb:gaps.beps_fft_qydjb WARNING: data page 0xb240 in tablespa…
Informix CDC API - Is there a way to pull the change record using .NET?
Hi, I'm trying to work with the Informix CDC API using the Informix .NET provider, but I haven't been able to find any sample code, and the documentation has been difficult to follow. I've put together the following code sample, but it doesn't seem to be retrieving any change rec…
InformixHQ 3
You may have seen this: www.ibm.com/support/pages/node/7240777 Security Bulletin: Informix HQ is vulnerable to HTML injection and does not lock out users after multiple incorrect password attempts 28 Jul 2025 The latest version 3.1.0 is described here: www.ibm.com/docs/en/informi…
Getting Perl module DBD::Informix off the ground
I will likely post this on the mailing list dbi-users@perl.org but at this time I don't know if that list still being supported. So I post here first, for that rarified special group of DBD::Informix users. I got my management to allow me to download DBD::Informix on one of our h…
Informix update
Hello I've been out of Informix for a long time it is a productive environment I have to update "Informix Enterprise Edition 14.10.FC8" to "14.10.FC11" Am I right that I am in the PassportAdvantage under "IBM Informix Enterprise Edition 14.10.FC11 Multiplatform English eAssembly …
LOG FILES
Hello everyone. Previously, I checked that in some cases the log files were filling up, and this was causing errors at some point. So we decided to increase the number of log files as well as their size. Today we had a problem because they filled up, and the log manager remained …
InformixHQ - Sensor and Alert for "Backups per dbspace"
Hi, In HQ, I have an alert set for the "backups per dbspace" sensor. Does anyone know what metric this sensor returns exactly? I'd like to create an alert with these conditions: Backups per dbspace - Last Level 0 Backup - is greater then: 24 (hours) The last value this alert retu…
InformixHQ - Sensor and Alert for "Backups per dbspace"
Hi, In HQ, I have an alert set for the "backups per dbspace" sensor. Does anyone know what metric this sensor returns exactly? I'd like to create an alert with these conditions: Backups per dbspace - Last Level 0 Backup - is greater then: 24 (hours) The last value this alert retu…
InformixHQ - MemorySegments Sensor
I'd like to monitor the virtual memory segment (V class). But I can't understand these sensor metrics. ------------------------------ Leandro Kohler ------------------------------…
Next IIUG TechTalk
IIUG Tech Talk July 17, 1 PM EST 2025 By Paul Watson July 17 @ 1:00 pm EDT Paul Watson has been using Informix for 35 years, moving to consultancy after 5 years. Along with three other consults formed Oninit (UK), and eventually Oninit (US) in 2006. Paul travels globally special…
Experience with IDS 15
Hello, is there someone to share practical experience of migration of IDS 12.10 or IDS 14.10 to IDS 15? The path we are now interested in is: in place migration of existing large databases without upgrading CSDK/JDBC/4GL, ie. possibly with switch to native mode, but without using…
Informix Client SDK availability on Windows ARM64
Hello, We are developing a database interface module for PowerBuilder on Windows ARM64 platform. In order to support Informix database connectivity, we need to compile the module using the Informix Client SDK. Could you please confirm whether IBM provides a version of Informix Cl…
How to recover InformixHQ corrupted h2 database?
Hello, today we got this message in IHQ server log 2025-07-02 08:41:30 [qtp-1564579997-597072] ERROR c.i.h.s.r.a.GenericExceptionMapper - Except ion in REST API : File corrupted while reading record: "/exp/ihq/h2db.mv.db". Possible solution: use the rec overy tool [90030-224] sin…
dbexport - schema issue when using logical_char
Hello, I currently migrated one Informix 14 database with sql_logical_char=OFF into a new database with SQL_LOGICAL_CHAR=2 Informix successfully doubled my expressions, so it created a char(72) field, when i wrote a add column myColumn char(36) CLIENT/DBLOCAL = en_us.UTF8 But now…
Assert failed,Is it a new defect on 11.50FC9W3? Error in rsidxinfo
| view attached Hi, experts: The instance crashed, below are the messages in online.log, I checked the defect list and defect description in version11.50, and compare the stack trace, it likes a new defect.Do anyone meet those errors? =================================== 04:00:11 …
C4GL 7.51.FC4 ships *15a .so libraries and non-15a .so libraries that are in fact identical
Hello, After installing Informix 4GL 7.51.FC4, I see several (older) *.so libs that have the same content then new *15a.so libs. $ md5sum DEV-7.51.FC4/lib/esql/libifsql*so 5e08b67a797bfd6faed87320a360714b DEV-7.51.FC4/lib/esql/libifsql15a.so 5e08b67a797bfd6faed87320a360714b DEV…
Informix 43258 error onbar logical restore
Hello All. I ran onbar -r -p to restore the database which rab successfully. But after running onbar -r -l (Logical Restore) I got 43258 and 43168 error. Please let me know how to overcome from this issue and run the restore successfully. current Informix and OS version: Online.l…
IBM Licensing issue
Hi y'all. I have a customer who for some reason bought Advanced Workgroup Edition. (He has never used the Warehouse Engine.) He is still using version 12. Now, IBM insists (as AWE was discontinued when V. 14. was released) that the customer must re-purchase the licenses to upgrad…
Interesting discoveries in sysprocedures
Hi Family. I was asked by a user to locate a trigger that accesses a certain table. On the way to finding out, I also needed a query that looks for stored procedures that access a certain table. Here's the query I came up with. (I'm likely re-inventing a wheel already develope…
WARNING: Buffer pool size is too small for read ahead operation
When I am loading millions of records into a database and I occasionally see a warning message about the buffer pool size being "too small for read ahead operation", should my reaction be: (a) ignore the warning because it only occurs with unusually large loads of data, or (b) in…
UNLOAD to a pipe instead of to a file
Since my previous thread ended to quickly and painlessly, I decided to try my luck again. Gain without the pain. :-) I have this memory from ages ago that I was able to to an UNLOAD command in dbaccess but instead of to a file, I unloaded to a pipeline to another program. The sy…
Complete time stamp of when the server started
Hi family. I SOOO want this one to be a quickie question & answer. Bottom line: How do I get the complete date/time of when the current server instance started up? Currently, the best I can do is: grep 'IBM Informix Dynamic Server Started' < message log > | tail -1|awk '{print $1…
where can i download Informix edition installer
I need to install a new version of Informix Server and ask where can I download the current version or for 14.10.FC11 of the "Informix edition installer". ------------------------------ Martin ------------------------------…
where can i download Informix edition installer
I need to install a new version of Informix Server and ask where can I download the current version or for 14.10.FC11 of the "Informix edition installer". ------------------------------ Martin Albat ------------------------------…
where is IBM 14.10.xC11W2 ?
HCL released Informix 14.10.xC11W2 mid may 2025, but there is still no Version on IBM Fixcentral... Can someone at IBM please fasten this process... Cheers, Markus ------------------------------ Markus Holzbauer ------------------------------…
Extending chunk capacity
Hi, in a 24x7 Informix v14.10, x86 SuSE linux instance with 2KB and 16K dbspaces and smart-blobspaces, with +250 chunks, we neede to grow the disk capacity and we are considering the option of extend chunk capacity instead of adding new chunks. We have successfully tested the fol…
Python ODBC and 11005
Playing with python ODBC for the first time, the fact isql (unixODBC) connects seems to imply the ODBC layer is correct, but it fails under python connect with -11005 Invalid connection string attribute. Gotta be something dumb ...... cat odbc_test.py import pyodbc print(pyodbc.…
Oninit engine won't start: log staging directory is not secure
Hi Y'all. Interesting (i.e.. frustrating as all blazes) problem I have trying to start up on a bug-fix copy of oninit. I start up oninit and it dies right away with the error message: Secondary Delay or Stop Apply: The log staging directory (/usr/informix/< subdir >log_staging_di…
Informix users
Hello everyone, I'm currently managing an Informix 14.10 database running on AlmaLinux 9.6, and I have around 70 active users. I'd like to know what best practices or recommended tools are for better control and management of these users. Some of my specific questions are: How ca…
Selecting rows where tuple in condition
Hi, Using Informix v14.10, we want to select rows from a table using syntax similar to what other sql engines can do: SELECT * FROM mytable WHERE (group_id, group_type) IN ( ('1234-567', 2), ('4321-765', 3), ('1111-222', 5) ); SELECT * FROM mytable WHERE (group_id, group_type) IN…
Is Informix dependant on password cypher algorithm?
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE AIX 7.1.3.5 While using a default pwd_algorithm (crypt) in /etc/security/login.cfg we have no problem connecting to Informix via network. To strengthen security I set pwd_algorithm to ssha512. After that users that renewed their…
Cast a datetime to character in default clause
Hi Y'all. (English REALLY needs a plural "you"!) I have a situation where a commercial software package goes bananas with datetime data types. But it is happy to work with a time stamp if it is character data type. I have been tasked with adding a few columns to a table. I am tr…
Stelo software as a replacement for Enterprise Replication
My organization wants to migrate databases with many hundreds of millions of records and hundreds of tables from an Informix database on an AIX machine to an Informix database on a Red Hat Linux machine. I've become familiar with Enterprise Replication, and I've done a lot of exp…
BSON with Informix 15.0
Hi, I'm testing BSON on Informix 15. I have the following table: create table brev ( seq serial not null , data "informix".bson ) PUT data in ( sbspace1 ) extent size 10000 next size 10000 lock mode row ; This is an example of one row: rseq 824 rdata {"_id":ObjectId("683f199109fe…
Informix with Hibernate 6.X anyone?
Since Hibernate 6, the InformixDialect class file has been moved out of Hibernate core to the community provided content. Are there anyone with experience in the combination of Hibernate and Informix here? Have you modified or adapted the InformixDialect class? We are having some…
Query using temp table is much faster then join/subquery
I have problem with query (duration 40s), when I use temp table is much faster (<2s). Can I do anything to improve query? Using temporary tables is cumbersome. Here is sqexplain, first for regular query, second with temp table: QUERY: (OPTIMIZATION TIMESTAMP: 05-30-2025 09:38:28)…
is there a rowsize function in SQL similar to rowid?
This should be a quickie: Yes or no. And I'd classify it as low priority. We can always select rowid for an individual row. I was curious, though I could not easily find it with google: Can I do this in SQL? select rowsize, rowid, < some real columns > from <table> In a table wi…
What triggers a blocking checkpoint?
Hi Y'all family. In the system under my purvey, checkpoints occur very often, almost always duration is on the order of 1/10 of a second. However (Bet'cha I telegraphed that coming :-), a couple of times a day, there is a blocking checkpoint that temporarily blocks all applicati…
Informix 14.10xc8 crash
Hello, Anybody has facing this situation ? 20:14:49 20:14:49 IBM Informix Dynamic Server Version 14.10.FC8AEE 20:14:49 Assert Failed: VARLEN SORT - compressed row len 32754 > srt_rowsize 3870 20:14:49 Who: Session(******************, 1336024, 0x4c0a6b28) Thread(673511, sqlexe…
Silly dbaccess question
I'm not sure if this will work, as this is my first attempt to post a new thread via email. The community web page keeps giving me errors when I try to create this as a new thread. It keeps telling me that I don't have access to save to draft in this community or something sim…
IBM.Data.DB.Provider - The owner has unlisted this package
Hi, I'm using the IBM.Data.DB.Provider nuget package in some of my .Net Framework (not core) projects. Recently is faced some restore issue and find out that the package is marked as unlisted in nuget : IBM.Data.DB.Provider But official documentation does not seems up to date as …
Which users have been granted which roles?
Now this oughta be straightforward. (Famous last words?) Which system catalog(s) can I query to see which users have granted a specific role? In catalog sysusers I see a group (sysusers where usertype = "G") named "managers". (Fake name, of course). What query can I run to see w…
Blog: IBM Informix a proven database with a bold roadmap
IBM Informix remains a core asset for organizations demanding performance, reliability, and innovation. This blog highlights its legacy, ongoing roadmap, and forward-looking features-from containerization to AI-readiness-as it moves confidently into versions beyond v15. Rest assu…
utils2_ak
11.70 FC4 gcc version 4.8.5 20150623 I think I must be doing something stupid Downloaded latest utils2 make The only error is INFORMIXC=gcc esql -O -DHAVE_GNU_GETOPT=1 -DHAVE_GETOPT_H=1 -o dbmove dbmove.ec getopt.c esqlc: "dbmove.ec", line 419: Error -33051: Syntax error o…
Extended Support
Hello Experts, Now that IBM has announced EOS for IDS 12.10, does the 1st year extended support requires additional payment in case any P1 ticket is opened? or does the support come under normal annual support maintenance without additional payment. Thanks in advance Syed H -----…
raw disk support deprecated in RHEL 9.x
I have been informed by my RH sysadm that support for raw disk has been deprecated in RHEL 9.x (specifically RH 9.5). He says that they have gone so far as to remove all information from the man pages. As we currently have our Informix instances on raw disks, I wanted to see whe…
Informix Language Supplement" (ILS) 3.50.MC7
Hello, I am new to informix community. I installed Informix 12.10 and 14.10 on a few machines. Working it out slowly. I hit a problem on Linux(both Ubuntu 22.04 and RedHat 7.9), Informix 12.10. I am trying to get support for bg_bg.8859-5. On Windows 2016 all works like charm and…
Column ti_flags in systabinfo
Man! This guy just keeps going!! <grin> About 9 years ago I wrote a perl module (FragmentList.pm) to consolidate information about data and index partitions. I may even have posted it as part of a contribution to the IIUG Software Repository. That aside: In that module I have t…
SDK CLIENT UBUNTU
Hi everyone I'm having trouble configuring the SDK client on Ubuntu. My client is running version 14.10.FC11WE and I have the client: Informix.4.50.FC11 I've already configured /etc/odbcinst.ini as: [Informix] Description=IBM Informix ODBC Driver Driver=/opt/IBM/Informix.4.50.FC1…
Informix V15 in Production
Hello all, Has anybody migrated to or has Informix V15 in production ? Thanks -- Cordialement, Regards, Khaled Bentebal Directeur Général - ConsultiX Tél: 33 (0) 1 39 12 18 00 Mobile: 33 (0) 6 07 78 41 97 Email: khaled.bentebal@consult-ix.fr Site Web: www.consult-ix.fr…
Cannot connect to Informix database via Python
I am trying to modify an existing Python script that has run in a customer environment, but fails to connect in any of my local environments: Windows, Ubuntu or CentOS. They all return essentially the same error using packages SQLAlchemy, ibm_db of IfxPy: Exception: [IBM][CLI Dri…
NEW IBM Express Learning courses - 75% off!
IBM Training has just rolled out IBM Express Learning, a new way to quickly boost your skills in data All of the courses can be accessed when you need them and taken at your own pace! Check this one out: Introduction to Informix Terminology and Data Types (v12.10). Take advantage…
future support of UTF-8 character handling
Hello Informix community, the fact that the current implementation of UTF-8 in the Informix database is not optimal and difficult to handle is probably known to everyone who has ever dealt with this topic. Before I submit an RFE, I would like to know the opinions of other members…
Table dual is not in the database
I may be going mad here: This worked yesterday (unless I dreamed it): select current year to month as this_month, current year to month - interval(1) month to month as last_month from dual; As it happens, I was in a sysmaster database but that's hardly important. Today I get thi…
Onlog columns documentation
(Since my previous 2 posts on the serial columns failed to post, I wonder about this one.) Hi Family. Is there any coherent and correct documentation on the columns in the output of onlog? The HCL pages I've found have on OK start for the 6-column record header but seem to be wr…
Announcing the passing of Stuart Litel
Stuart. J. Litel passed away on April 19, 2025 at his home in Waban, Massachusetts. Stu was the beloved son of the late Joseph and Barbara E. (Sulkin) Litel of Newton, Massachusetts. Robin Chapman was his loving domestic partner for 20 years in Waban. He was a dear nephew to Barr…
Informix 11.50.FC9W3 assert failed question
Hi, I use Informix 11.50.FC9W3 , it's the newest version on 11.50 . today the RSS SERVER is abnormal terminated. blow are some information from online.log and af file. 1) online.log 00:06:51 Maximum server connections 65 00:06:51 Checkpoint Statistics - Avg. Txn Block Time 0.00…
#Instalador Informix 4GL
Buen día. Recién estoy aprendiendo a programar en Informix 4GL. Logré instalar Informix Developer Edition para el servidor de base de datos, pero no he podido probar código en 4GL porque no encuentro un instalador. Alguien me podría ayudar por favor?. Gracias de antemano --------…
Quickie question on serial and bigserial data types
Hi y'all. This is a quick question. I have determined that for a serial column, the coltype in syscolumns is an integer: 262. We have not loaded ak_utils here so I can't check the code to see what the coltype value is for bigserial column. At this time we are not yet using bigse…
onbar is rejecting my date for point-in-time restore
Hi Family. I'm having enough frustration getting cross-system restore to work. But this is SO frustrating: With my entire environment set up by a script that has been working for years, I made the modification: /usr/informix/bin/onbar_d -r -p -w -t "2023-11-30 05:00:00" And it's …
informix 15 esql in conjunction with latest AIX compiler generation
Dear community! In the Machine Notes for my Installation is noted that: 1. This product was built on AIX 7.2 Technology using the following compilers: IBM XL C/C++ for AIX, V16.1.0 (5725-C72, 5765-J12) XL C/C++ Runtime 16.1.0.10 That is quite ok for me, but when it comes t…
Problem installing gskit for 14.10.10FC11W1 on AIX
Hello, during installing gskit on AIX I got an error message: Couldn't determine supported encryption library current gskit version is 8.0.55.14 In install log is this: Execute Command: /informix/ifxserver.14.10.FC11W1X2/gskit/installgskit Status: SUCCESSFUL Status: FATA…
Error: INFORMIXDIR /home/informix is not owned by group
Hi, OS: NAME="SLES" VERSION="15-SP5" VERSION_ID="15.5" PRETTY_NAME="SUSE Linux Enterprise Server 15 SP5" ID="sles" ID_LIKE="suse" ANSI_COLOR="0;32" CPE_NAME="cpe:/o:suse:sles:15:sp5" Informix: ibm.server.15.0.0.1.Linux.64.x86_64.tar Issue: Where we run any command [oninit, onclea…
Informix V15 and watsonx.ai
Hello all, Has anybody used Informix v15.0 with watsonx.ai or is planning to use it in a real project -- Cordialement, Regards, Khaled Bentebal Directeur Général - ConsultiX Tél: 33 (0) 1 39 12 18 00 Mobile: 33 (0) 6 07 78 41 97 Email: khaled.bentebal@consult-ix.fr Site Web: www…
Automated Update Statistics and FORCE
Hi everyone. AUS seems to append FORCE to all UPDATE STATISTICS statements saved in sysadmin:aus_command.aus_cmd_exe on some systems and not others. Why is that so, and how can it be enabled or disabled? We have a site where an exceptional table is excluded by altering STATCHANGE…
Perl-like string manipulation in SPL?
Hi again, Family. I am rereading up on SPL (which I have not touched in nearly 30 years - and the times, they are a-changin'!) because I found a user request for an interesting constraint on a column in a table. It must look like an email address i.e. yodel@spaceballs.org . (or m…
ROWID 8 BYTES
Hello everyone Recently, as you may know, version 15 of IDS was released. I was running some tests, and among the issues that arose was the use of the ROWID by clients, especially from C# and/or ODBC. It turns out that when I include the line in the SELECT statement, it doesn't s…
Feature Request – Adjusting Edition Limits
Hi to all, as discussed at Techday in Munich, we started a new feature request to adjust the edition limits - hope you are in favour with this?! Feature Request – Adjusting Edition Limits With the introduction of IDS 15, storage options within an instance have become virtually un…
Munich Tech Day, Informix Roadmap and Informix Newsletter
Hi, Any update on the slides from the Munich Tech Days? Is there an updated roadmap for Informix now that V15 is out? When if the first fixpack for V15 due? Is there an English version of these ? https://iug.de/informix-newsletter/ Regards, David. ------------------------------ D…
Columns in ixbar file
As threatened er, promised in another thread, I am reviving a question posed in 2013 or so on comp.databases.informix: Does anyone know a query on sysutils that would recreate the ixbar file ? Sadly, only 2 people responded and neither had an answer. I did find a page that purp…
Data or date-time columns in oncfg_(servername).(servernum)
Hi Family. Working toward my better knowledge of onbar, I'm writing a Perl script to sort the DBspaces and logs sections of the oncfg file in more sensible ways. (I have yet to determine if my new employer will permit me to post it where y'all can get it.) My source of informat…
IIUG Survey
The IIUG is excited to be participating at IBM TechXchange 2025, October 6-9, 2025, in Orlando, FL, USA. We would appreciate it if you could find some time to complete this very short survey by March 31, 2025. Your input will help us provide content specific for the Informix Com…
Informix instance performance issue
Hello, I hope this message finds you well. I wanted to bring to your attention that we have recently observed a significant decline in the performance of all processes executed within the database. This slowdown is impacting our overall efficiency and productivity. Below, I have …
CDC on Workgroup Edition?
Is it possible to use CDC on Workgroup Edition or is it an Enterprise feature? Thanks in advance, -Snorri ------------------------------ Snorri Bergmann ------------------------------…
New Informix RFE
Please vote for the new RFE I entered. INFX-I-663 Add a session setting to make an index invisible just for the current session and one to reverse that setting. ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdb…
Onbar: Failed to determine archive's encryption mode. Error code 2
My thanks to the group, especially Mike Walker, for your help in getting that blessed onbar restore going successfully. Now I have a variation on that issue but it calls for a new thread. I have it working NOW but I'm just hoping for an explanation of a screwy rabbit error in a f…
Informix and Dynatrace
We are being forced to use Dynatrace to monitor our Informix databases. We have a Informix Dynatrace module loaded and working. And it comes with 13 graphs out of the box. But how do we add new things? Like how do we monitor if there has been a level 0 archive within 50 hours in …
security features
What are the latest security features in IBM Informix, and how can organizations better secure their Informix instances?" ------------------------------ Janelle mclaughlin ------------------------------…
How to verify all the requirements for an onbar restore
Hi Family. I've been mostly quiet on this group because my gigs of late have been Perl with little to no Informix. That has now changed. (YAY!) I have little to no experience with onbar. I performed some backups by rote and used archecker to get back a table my client had inadve…
Chinese characters
I have been asked a question regarding inserting Chinese characters int a database table. I have never done this before, so I wanted to ask if anyone has ever done this type of activity and, if so, what steps did you take to ensure that the procedure was done properly? Please…
Verify my login to IIUG Community via text to mobile phone
Hi Family. This question is not specifically about Informix though I have a doozy of a question to compose at work. Here's the problem: I can log in to the Informix community http://www.iiug.org/community with my email address. As it is set up, it sends a verification code to t…
Old Informix manual
Does anybody know the name of an old IBM Informix reference manual from the 80s/90s that had little text-based diagrams that illustrated SQL joins? It was a wonderful visual explainer as to exactly how outer and inner joins worked, and I have never seen joins explained so well si…
Migration from Informix 9 to Informix 15, JDBC Problem with float in prepared statements
Why I don't know but does select 2.0::FLOAT * ? from dsfco select (2.0::FLOAT * ? )::FLOAT from dsfco work as expexted…
How to restrict SPL and tiggers source code from odbc/jdbc request ?
I have to give readonly ODBC/JDBC access to some users (select only on some tables). I don't want them to have access to SPL and triggers sources. If I revoke execute permissions on each procedures they can still see the source of them. I tried to create another database with vie…
How to restrict specific ODBC/JDBC users from accessing the source code of SPL routines and triggers
I need to grant access to Informix IDS 14.10 to some users but I don't want them to have access to the SPL and triggers sources codes. I try creating a new database with views that point to the production db. But I need to grant connect to the prod db to the users so they can acc…
Informix 14.10.FC11 and IBM PowerHA SystemMirror(HACMP)
Hi, We successfully done migration from version 11.70.FC4 to 14.10.FC11. Everything is fine on the "active" machine. We are using "Active/Passive" configuration with: IBM PowerHA(HACMP). The "mount" directory between two nodes is /informix. The installation was made on the "activ…
Help with Informix 14.10 configuration
Hello Informix family, Iam migrating Informix from Solaris 11 to Redhat 8 and at the same time from Informix 12.10 to 14.10.FC11 1. On current Solaris we run on a virtual solaris zone with 56 cpu threads and we have good performance he new cpu on Redhat physical machine have the …
Changing the owner of a database
What is the quickest way to change the owner of an Informix database to a different user? I tried searching on the internet for the answer to this question, and I didn't find one. ------------------------------ John Dargan ------------------------------…
Informix Technology Days 2025 in Munich on March 12 and 13
The Informix Technology Days in Munich will be taking place again this year . You can find details below, including the link to register. You are also welcome to forward this invitation to anyone interested in this event.. I would be delighted if we could welcome you there this y…
Why would sysptprof have 0 entries for all counters?
I have looked at a client's sysptprof in search of some sequential scan information and found all entries in the table to be 0. The profile stats show over 200,000 sequential scans since the last profile reset. Then I ran a Select MAX() against every column in sysptprof. They …
Informix 4GL to Aubit4gl migration
Hi, We have a huge Informix 4GL-based project, RDS on SPARC Solaris. Our goal is to migrate it to x86 Linux. A problem with Aubit4gl is that it does not have same scripts as I4GL that we use. Does anybody have an experience of porting a large I4GL project to Aubit4gl? -----------…
Slow operations from a remote network
I have an application that when running on the same network as my instance takes an average of 5 minutes to perform operations, however from an external network it is impossible to generate. I have waited up to 1 hour. Is this due to Informix configuration or a connectivity issue…
Art's myschema/myexport utilities on the AIX platform
I would like to ask if there is anyone who is actively using Art's myschema/myexport utilities https://www.askdbmgt.com/my-utilities.html on the AIX platform? ------------------------------ Antonin Rozehnal ------------------------------…
Informix 12.10 vs Informix 14.10 Performance Differences
Our company has (finally) begun an upgrade from Informix 12 to Informix 14, the version that we are trying to certify for our ERP software. We managed to migrate the 12.10FC14 instance to 14.10FC11 on an AIX 7.3 O/S platform. All went well and we have the instance up and running.…
Training course pricing
We are in South Africa and are interested to get our team skilled up in Informix. We have interest in Informix Admin course but cannot find the cost anywhere. I am looking for the price of a course called IBM Informix Administrator for Database Professionals. Thank you ---------…
RFE to Server Studio
Hi, That query captured while opening a DB Objects tab at a DBSpace properties, SELECT a.tabname, a.dbsname, a.owner, ti_nextns, ti_nptotal, ti_npused, ti_nptotal/26214400*100 percinspace, ti_nptotal * ti_pagesize, ti_npused * ti_pagesize, CASE WHEN(((ti_nkeys >0 AND ti_nrows > 0…
German special Umlaut in UTF-8 DB
Hi all, since 2017 the committee of German spelling has accepted a definition of a new character , which is a uppercase variant of ß (sharp s). We recently ran into an issue to store this special character in a database (DB_LOCALE=de_de.UTF8). Firstly, we had the suspicion that …
An accurate timestamp in a stored procedure
Hi All, the background to this challenge is a repetitively used stored procedure that usually take no longer than 5 seconds each execution. Unfortunately, it is run thousands of times and so every millisecond I can drop off the SP execution time will help. So the plan of attack w…
Can we get the same output as onstat -g spa from SQL queries against sysmaster
Hello community, does anybody tried to get the same or similar output as an SQL query from sysmaster? Thanks a lot Milan Rafaj Unless stated otherwise above: Kyndryl Česká republika, spol. s r. o. Sídlo: V Parku 2308/8, Chodov, 148 00 Praha 4, IČ: 096 28 886 Zapsaná v obchodním r…
GSKit Changes With 14.10FC10W1 - FC11
As a note that I don't think was well documented, when going to the newer versions of Informix with the newer releases of GSKit (8.0.55 or 8.0.60) the old -type cms keystores no longer work for servers. If you set one up using -type cms you can bring the engine online, however if…
Best approach for migrating 2.5 billion rows
In my organization we have a production AIX machine with multiple Informix databases, 1,934 tables and over 2.5 billion records. We want to copy all of this data to Informix databases on a new Linux machine. I am currently planning to use Enterprise Replication for most of the ta…
Who needs a HOME?
Just saying ... OpenSuse ... letting the 14.10.FC11W1 installer create the user informix ... and no $HOME is directory is created. ------------------------------ Jon Ritson ------------------------------…
HTML Email in AIX 2.7 environment
Hi - We have Informix 4GL running in AIX 2.7 environment. We wanted to sending an HTML email from this environment so that proper tables and styles are be opted for user experience. Can you please advise on this? ------------------------------ Hasarin Fareeth Noor Mohamed -------…
Resync RSS server
Hello I need to re-initiate synchronization between a primary server and the RSS. They re currently connected, active prim :/prod/dbown>onstat -g cluster ... Server ACKed Log Applied Log Supports Status (log, page) (log, page) Updates ids_tlv_rss 0,0 0,0 No ASYNC(RSS), Connected,…
Lost a day's worth of data - anyone have any clues?
I know, it's old, but we're using Informix 11.70 for a client. A couple weeks ago, the VM they were on had a memory card that was, I'm told, not seated properly and we had memory errors. Not sure how long. But back on the 9th, we just seemed to lose everything that happened that…
Obituary notification for Carlton Doe
Dear Informix Community: It is with great sadness that we are informing you of the death of long time Informix advocate and dear friend Carlton Doe after a long battle with cancer. Carlton passed on January 16, 2025, in Dallas, Texas at the age of 65. He was one of the original f…
HTML Email in AIX2.7 environment
Hi - We have a AIX 2.7 environment in which we wanted to send HTML emails so that the emails can have tables and styles as per customer needs. We are using SendMail tool to send the email which is working for a plan text email. Can anyone advice if HTML formatting is possible wit…
fix_ipa Issues
I'm testing out the excellent fix_ipa utility from Art Kagel but I'm running into a few problems. fix_ipa: Features Version 1.0, Source Revision: 1.13 !…
RSS slowing down
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Today we have a RSS replication slowed down. I mean not froze but just applying logs slower than the primary filling them. That has not happened ever in working hours. Filling pace was not any unusual for the time. After restart…
Roll log forward Error
| view attached Hello All, I've installed IDS 14.10 on RHEL 7.9 . IDS on my personal laptop using Oracle Virtual box. was running find, but yesterday got Roll Log forward issue, and tried as per some Google tips, but not able to solve. I've attached the online.log and onlog comma…
IBM is ending support for Informix?
I'm hoping for any clarification that the group can provide for the link shown below (does this mean what it seems to mean?): Continuing Support for IBM Informix ends on 30 April 2025 In the quote below I have highlighted certain words with a bold font: "...IBM is announcing the …
Debezium
Hi y'all. Has anyone here used Debezium with Informix? Best regards, -Snorri Debezium connector for Informix ------------------------------ Snorri Bergmann ------------------------------…
ESQL/C ifx_var_init() purpose and usage
Hello, When are using ESQL/C ifx_var_*() functions to fetch LVARCHAR data dynamically in our Informix driver for Genero BDL. For now we do following to initialize the opaque structure used by this API: void *lvarchar = NULL; ifx_var_flag(&lvarchar, 1); There is this ifx_var_init(…
Segfault since CSDK 4.50.FC10 with LVARCHAR and CLIENT_LOCALE different from DB_LOCALE
Hello! Starting with CSDK 4.50.FC10 (we cannot reproduce with 4.50.FC9W1), With DB_LOCALE=en_us.8859-15 and CLIENT_LOCALE=en_us.utf8, LC_ALL=en_US.utf8, Fetching an LVARCHAR with auto-allocation API using ifx_var_flag(ptr,1), we get a segfault when fetching. THE PROBLEM DOES NOT …
Setting up enterprise replication for a test
I am trying to set up enterprise replication between a source machine named ezri and a destination machine named tpol. When I run the "cdr list server" command tpol, this is what I see: SERVER ID STATE STATUS QUEUE CONNECTION CHANGED ------------------------------ g_ezri 1 Activ…
What are possible reasons for RSS replication freezing?
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Every night we suspend applying logs at RSS with DELAY_APPLY=7H to load consistent data onto data warehouse. At 5:30 we resume replication with DELAY_APPLY=0. Sometimes the replica fails to resume, and restarting the IDS is the …
Informix enterprise replication
Hello, Happy New Year to all I have a client who is going to migrate his system from AIX 5.3 to Linux Red Hat 7.8 In this process he is going to migrate his databases from Informix 11.7 to Informix 12.10 My question is about what is the process to migrate databases that use Enter…
Simplest way to connect from remote computer to Informix 15 server
Hello! Happy new year to all! What is the easiest solution to allow a remote connection to Informix 15, without having to specify a password for the (OS) current user? My client machine hostname is ida with domain strasbourg.4js.com I have tried INFORMIXDIR/etc/host.equiv with: …
Hyperswap and Flashcopy
Hello, i have two FS5200 configured in Hyperswap. Now the first FS5200 (FS5200A) is temporarely out of service do to a fire in the sita A. Each hyperswap volume was also flash copied regularly to target volumes residing in a pool of FS5200A To fix that , a have configured new tar…
Informix Client download
Happy New to All. Please let me know how can I download Informix clients (4GL, 4DS, SQL etc) for Non licensed version. I wantto download these clients for IDS 12.10 and IDS 14.10 for my own use. I can't find in Fix central. Kindly help. Thanks Amit Patel -------------------------…
Recently appended logged partitions
Hello all and wish you happy new year. Is it possible to list tables/partitions for which (fake) level0 backup must be run to allow writing to it? There is a flag with value 32768 in sysptnhdr but this flag is on even after L0 backup is finished. Thank you Milan Rafaj Senior Lead…
Informix cURL call does not refects the OS settings - trusted CA certificates
Hello. Some time ago I was trying to configure the S3 without encryption for Informix backup https://community.ibm.com/community/user/datamanagement/discussion/informix-and-minio-backup-without-encryption I configured MinIO to provide the requested encryption on the server/bucket…
Simple way to run Informix 14 and 15 in parallel
Hello, For development I have both IDS 14.10 and Informix 15 installed on my Linux Debian 12. So far, I have to switch between both versions to do tests. I know it's possible to have more than one instance running on the same computer. I would appreciate if someone points me to t…
Informix 15 CSDK compatibility indicator
Hello, Since Informix 15 CSDK introduced changes for example in the sqlca definition, I was wondering if there is some way to distinguish at compile time when an ESQL/C compiler V15 or V4.50 is used, so we can maintain the same .ec source code for different versions of ESQL/C. I …
Informix 15 server / CSDK compatibility matrix
Hello, Simple questions: Can I use a CSDK 4.50.* to connect to an Informix 15 server? Can I use a CSDK 15 to connect to an Informix 14 server? Is there some compatibility matrix available? I have just face the following: 1) With CSDK 15 connected to Informix 15 server: CREATE TAB…
Limit in Informix 15.0.0.0 - "LO_hdr_partn"
Hi, Does the limitation of 16777215 pages in sbspace LO_hdr_partn still exist in Informix 15? Regarding presentations and other information: Some instance objects remain unchanged regardless of the infrastructure version such as ... Internal SLOB space partitions .... And output …
V15 installer could not determine supported encryption library
Hello, I am installing IBM Informix 15.0.0.0 Developer Edition on my Linux Debian 12. I have selected OpenSSL as encryption library, and I have: informix@toro:/opt3/dbs/ifx/IDS-15.0.0.0$ openssl version OpenSSL 3.0.15 3 Sep 2024 (Library: OpenSSL 3.0.15 3 Sep 2024) And I got this…
Where to report bugs for Informix 15
Hello, Sorry it's unclear to me where I should report bugs... (we found one with HCL Informix 15 CSDK) On https://support.hcl-software.com , I can't find "HCL Informix" in the product list... only OneDB ... We detected a defect in the ESQL/C libs when using a CONNECT TO with USER…
Informix JDBC driver cleanup bug - memory leak
I have a problem when hot deploying our Java service to Tomcat, when the app is restarted getting the following WARNING: 07-Jun-2024 14:18:12.815 WARNING [Catalina-utility-1] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [dashboard] a…
Vote now for : Multi Vector database functionality as Database Extend to Informix ( INFX-I-612 )
We discuss during the leolo Mastermind Conference that will be an exceptional feature if Informix 15 has a Multi-Vector Database functionality (like Milvus). May an additional functionality like time-series or as datablade like geospatial and text-search or as part of the core ma…
Informix Client SDK 4.10.TC16 Windows 64 only installing as 32 bit
I downloaded Informix Client SDK 4.10.TC16 Windows 64 from the IBM downloads site. I am trying to run this driver with an application that runs on 64 bit. It is installing as a 32 bit, and I cannot figure out what I am doing wrong. I download the file then run the clientsdk insta…
ESQL/C conversion error with CLVCHARPTRTYPE
Hello, Once I reported an issue with ESQL/C charset conversion when using the CLVCHARPTRTYPE type: https://ibm-data-and-ai.ideas.ibm.com/ideas/INFX-I-400 Sorry but I have no bug or feature ID, I am totally confused with HCL/Actian/IBM forums and support channels, so I don't know …