Threads from 2026
Browse by month: Jan · Feb · Mar · Apr · May · Jun · Jul · Aug · Sep · Oct · Nov
Informix: SEC_LOGREC_MAXBUFS configuration parameter
Hello community, while reviewing the current onconfig.std, I noticed that in version 15.01.19 the configuration parameter SEC_LOGREC_MAXBUFS was renamed to LOGREC_MAXBUFS. However, the online documentation (https://www.ibm.com/docs/en/informix-servers/15.0.x?topic=parameters-se…
Informix: Restoring with OnBAR from a TSM replica
Hi, We're trying to restore data from a TSM replica. An issue is that TSM assigns new OBJECT_IDs to each object replicated. As OnBAR requests objects by their OBJECT_IDs that are stored in ixbar, 7th & 8th columns, TSM cannot find them. So my question is, is there a script …
RE: Informix: Informix cooked files filesystem layout
Hello, I did the raw disks to cooked files conversion today in UAT environment and i will note the main steps that i followed in case anyone has a similar need: Before the rollout 1) Since i enabled DIRECT_IO in the end of the procedure it means that the Linux OS filesys…
RE: Informix: Informix cooked files filesystem layout
Hi Stavros. We did mean the disk device block size. If that is 512, then you have no problems with chunks defined on LUNs with DIRECT_IO 5 and any Informix page size. Best practice is to create symbolic links to your LUNs and use those links when creating the chunks with "ons…
RE: Informix: Informix cooked files filesystem layout
Hello, @Art@Doug: Regarding the block device page size, are you referring to the page size set when creating the informix chunk or the block size of the lun that is created on storage system? If it is the second, i executed smartctl -a /dev/sde and the logical block size rep…
RE: Informix: Informix cooked files filesystem layout
As Art says, you will need a recent IDS version for DIRECT_IO with 4K block devices (Advanced Format storage): https://www.ibm.com/docs/en/informix-servers/14.10.0?topic=parameters-direct-io-configuration-parameter-unix <https://www.ibm.com/docs/en/informix-servers/14.10.0?topi…
RE: Informix: Informix cooked files filesystem layout
The only problem wilh using block devices with direct_io is if the block device is defined with a [age size that is a 4K. That was not supported until v15 and the later releases of v14,10 but only for dbspaces whose page size is a multiple of 4K. Not sure where it came in in v14.…
RE: Informix: Informix cooked files filesystem layout
We manage many long-standing systems with IDS on Linux using block device logical volumes with DIRECT_IO 5. Running "onstat -d" proves it is using direct IO with the last chunk flag being "D" in all cases. No problems at all. The chunks are better protected not being in file syst…
Informix: Enable IS NOT NULL index fragment elimination in IDS14
Please vote for this! My article on Partial Indexes has been withdrawn meanwhile. https://ideas.ibm.com/ideas/INFX-I-714 <https://ideas.ibm.com/ideas/INFX-I-714> We were advised in TS021736198 "Partial index query plan change" to exclude NULL values from being indexed by havi…
RE: Informix: Informix cooked files filesystem layout
Hmm i think the next step would be to implement something in practice in order some measurable data from my environment. I know that things do not always work the same way in different environments, so for the UAT i will keep the xfs filesystems as i am doing now with the raw d…
RE: Informix: Informix cooked files filesystem layout
Stavros: I STRONGLY disagree with David on using EXT4! Its copy-on-write strategy fragments file systems which can cause performance issues on magnetic drives and accelerate aging of SSD and other flash based drives, and you cannot disable that feature. In addition, EXT4 still …
Informix: Informix cooked files filesystem layout
If you use ext4 you can not turn off journalling, well you can, but its not supported and you can end up deadlocking the entire server https://community.ibm.com/community/user/discussion/nasty-redhat-issue <https://community.ibm.com/community/user/discussion/…
RE: Informix: Informix cooked files filesystem layout
Hello, @Art: I like your idea regarding the filesystem separation. I have another UAT system which is closer to my PROD environment. Of course there are only a handful of users connected but the batch processes that are running on PROD are also executed in UAT and i think i …
RE: Informix: Informix cooked files filesystem layout
Hi, I would start with DIRECT_IO turned on, keep it similar to the existing setup. This is x86_64? Which filesystem type? I have seen issues with XFS and writes to adjacent 2K pages on the same 4K block so I would use ext4. Regards, David. You are subs…
RE: Informix: Informix cooked files filesystem layout
Stavros: Yes, that arrangement looks mostly OK. I would use a PLOG type space for the physical log rather than a "normal" dbspace, but the benefit of doing that is small, so not a big deal. So, on Linux, you no longer have access to RAW devices on most releases, that is true,…
RE: Informix: Informix cooked files filesystem layout
Hello, Thank you both for your answers. @Art: Actually the instance is configured already similarly to the way you described: Dbspaces address number flags fchunk nchunks pgsize flags owner name 4bb61028 1 0x1 1 1 …
RE: Informix: Informix cooked files filesystem layout
Stavros; I would have one dbspace for rootdbs and temp dbsoaces, a PLOG dbspace for the physical log, a separate dbspace for your logical logs, then at least one dbspace for tables and another at a wide pagesize for any non-trivially small indexes. How many filesystems you use …
RE: Informix: Informix cooked files filesystem layout
Hi Stavros, it's more about how the filesystem is configured. I prefer to have one filesystem for the cookfile chunks, but with 8-16 LUNS in a 128K stripe size. Also node to use DIRECT_IO 0x5 and so much BUFFERPOOL in different page sizes you can have on the machine. Best Regar…
Informix: Informix cooked files filesystem layout
Hello, I have informix 14.10.FC8 running on RedHat Enterprise Linux version 8 and i am currently using raw disks for the database instance. I am planning to upgrade the system to RHEL9 and i know that support for raw drives is no longer supported by RedHat in that version and…
Informix: syslcktab.owner and sysrstcb.address
I'm trying to recall the connections between onstat -u and onstat -g ses at the SMI level. I know that in the output of onstat -u, the 3rd column is the session ID (SID) and I can get from there to other stuff a user is doing. However, I need to do this at the SMI level. My a…
Informix: Informix Unittest Framework
Hi, Does anyone know if there exists a unit testing framework (e.g. as DataBlade) for Informix like pgTAP <https://pgtap.org/> exists for PostgreSQL? ------------------------------ Emanuel Reisinger Axians ICT Austria GmbH ------------------------------…
Informix: ESQL/C DESCRIBE OUTPUT much slower than simple DESCRIBE for an UPDATE statement
Hi all, A customer reported a performance issue, when performing a ESQL/C PREPARE + DESCRIBE OUTPUT + EXECUTE in a long loop. Yes, best practice is to do the PREPARE + DESCRIBE outside the loop, but the code cannot be changed (it's static SQL in .4gl code) We have identifie…
RE: Informix: Why does DECODE a json column in view does not work?
FYI: A known issue has been raised by IBM DT504879 - DECODE with a Json column in view does not work BR Emanuel You are subscribed to "Informix" as paul.cdi@oninit.com. To change your subscriptions, go to http://community.ibm.com/community/user/preferences?section=Subs…
RE: Informix: Why does DECODE a json column in view does not work?
Case opened. You are subscribed to "Informix" as paul.cdi@oninit.com. To change your subscriptions, go to http://community.ibm.com/community/user/preferences?section=Subscriptions. To unsubscribe from this community discussion, go to [link removed]…
RE: Informix: Why does DECODE a json column in view does not work?
Good question ... looking like a defect (can you report this in a support case?) There's also this: select id from decode_test where data_json is null; id 1 1 row(s) retrieved. vs. select NVL(data_json, 'NULL') from decode_test; (U0001) - JSON …
RE: Informix: Why does DECODE a json column in view does not work?
Using a case instead of decode in the view works. DECODE(data_json, null, 0, 1) case when data_json is null then 0 else 1 end But why does decode not work? BR You are subscribed to "Informix" as paul.cdi@oninit.com. To change your subscriptions, go to http://community.i…
Informix: Why does DECODE a json column in view does not work?
Hi, Why does not work DECODE on a json column in a view? drop table if exists decode_test; create table decode_test ( id int ,data_json json ,data_vchar varchar(16) ); insert into decode_test (id) values (1); drop view if exists decode_test_view; create view decode_test…
Informix: oncheck -pr in Fast Recovery mode
Here's a cute situation, as in "What a cute little centipede!" In HA replication, the target/replicate server is always running in Fast Recovery mode. On one such server in my environment, I tried to run "oncheck -pr". It gave me the message: $ oncheck -pr Validating IBM …
Informix: Error -43 engine crash
Had engine crashing everyday at 05:00 and 21:00, always with -43. It was pain to track down cos Informix wasn't really at fault, just an innocent bystander. Anyway, this was the solution in my world https://www.oninit.com/reference/semop_eidrm/ -- Cheers Paul Paul Watson O…
Informix: v14/v15 on ubuntu 24(26) debian 12(13)
Hi any chance or sign that v14 and v15 will be certified on ubuntu 24, ubuntu 26, debian 12 od debian 13? We are in 2026 aren't we? Hrvoje ------------------------------ Hrvoje Zokovic Technical Support Director ALFATEC Group Zagreb ------------------------------…
RE: Informix: external optimizer directives not working
Hi, just for your info, we fixed this issue: -. I had used the sql syntax text extracted from onstat -g ses output. It seems this command formats the text and the directive gets created with extra spaces, carriage returns, etc. and when the same SQL gests executed it does not m…
Error "Variable syntax" on shell command within SQL script
Greetings family. I started writing this in order to present a problem I was having. But while articulating my problem I hit on a workaround that mostly works. I am posting it because I think it may solve a similar problem for someone else. I have an SQL script that runs a bunc…
14.10.FC14
Why isn't 14.10.FC14 available for download in PA? ------------------------------ Snorri Bergmann ------------------------------…
Query to display participants in a referential constraint
Hi Folks. Ab out 10 years ago I posted this question: In dbaccess, when I display information about a table, I can get information about constraints from the Info menu. This shows me the name of the constraint, the referencing table and column as well as the referenced (PK) colum…
Is it save to modify field sysadmin:mon_users.progname from varchar(16) to lvarchar(64, 128 or 256)?
Hi, Currently running Informix 14.10.FC4W1. The table sysadmin:mon_users is awesome. But the column progname in the table is varchar(16) which is very short. $INFORMIXDIR/etc/sysmaster.sql has char(256) for progname which is just enough to hold the information a DBeaver session v…
Is that SBspace really empty?
Greetings, Y'all. As part of a minot project, I will want to drop an SBspace and later recreate its chunk file in a different raw device. Of course, as with a DBspace, where the server won't allow me to drop it unless it's empty, the SBspace needs to be empty in order to drop it…
IFX 14.10 FC14 License File
I'm trying to download Informix Enterprise 14.10.FC14 from Passport Advantage. I can see FC13 , but FC14 isn't available on the PA site. I was able to download FC14 from Fix Central, but Fix Central does not provide the license file. How are you guys getting your license file for…
Hierarchical Query/Clause Problem
| view attached I'm having trouble with a hierarchical query. I have a table of 289 records on which I'm running the following query and it ends up being an infinite loop. Does anyone have an idea about what I might be doing wrong? create temp table tmp_sub(item_code char(24), …
Flash Notifications
Hi, I received Flash Notifications for 2 issues, these is nothing on the CVE links, can we get more details? Security Bulletin: IBM Informix Dynamic Server Privilege Escalation Vulnerability in oninit Utility (CVE-2026-13367) Versions 14/15 affected Security Bulletin: IBM Informi…
All sessions with wait "mutex wait lru"
Hi, We have problem, IDS 14.10.FC13W1 was hung up. All sessions (open, activ, new ) were wait status "mutex wait lru" or "mutex wait hash". Do you have any idea what could cause this? What we should monitoring? ------------------------------ G W ------------------------------…
data insertion in multiple sbspaces
Dear All, I'm working on IDS 14.10 using Solaris 5. I've created a table and need to store the data in multiple SBSPACEs, used below syntax: create table "informix".cs_csid_phto_00 ( seqn Integer not null, phto_file clob not null ) PUT phto_file IN (sbs001, sb…
sbspace space monitoring SQL
Dear All, We are working on IDS 14.10 We have added three SBSPACE in our dbspace , and for checking the free space among all dbspace we run below SQL: database sysmaster; select name[1,8] dbspace, -- name truncated to fit on one line sum(chksize) Pages_size, -- sum of al…
Minus operator in IDS Release 12?
Hi Folks. I just discovered a minor data inconsistency in a test database. (I believe I can prevent that in production.) To check it I need to be able to run two queries and check the differenced between them. I tried this: select (yadayada) from <table-a> where (the usual) min…
Dynamically setting environment variables
Greeting y'all, an especially to Jose Manuel, who started the thread " Dynamically setting PDQPRIORITY and OPTCOMPIND for a session within a Procedure". I have run a few SQL scripts and forgotten to set environment variables like PSORT_NPROCS, PSORT_FBTEMP, and DBDATE. I have to…
Dynamically setting PDQPRIORITY and OPTCOMPIND for a session within a Procedure
Hi, we are trying to dynamically setting the PDQPRIORITY and OPTCOMPIND values from a stored procedure (SP) and it works but the values do not persist after the SP finishes. We would need the session to maintain those PDQ/OPT values out of the scope of the SP, and after its execu…
onstat -g seg reveals several virtual segments many show a pool summary of 17184.H.sd
This system is running one 14.10.FC11X8 standard server with two RSS servers. For some time onstat -g seg shows an increasing number of virtual segments - we have an alert for a threshold of 10 or more: IBM Informix Dynamic Server Version 14.10.FC11X8AEE -- On-Line -- Up 5 days 2…
Dostats
Hi, Art, Recently, We found somehow our dostats running could ask Informix to add quite some extra virtual memory segments , 1) Online log. 07/05/2026 22:18:31 Dynamically allocated new virtual shared memory segment (size 8000000KB) 07/05/2026 22:19:47 Dynamically allocated n…
Data restore required from logical log
During activity we have mistakenly drop a partition . Now we want to restore data from logical log partially Kindly guide how we can perform this task. logical log backup is taken at 07:10 (388030) and next backup is take at 07:20 (388031) partition detach and drop time is 07:19 …
Row count by rowid does not add up to actual rows
Hi Folks. As usual, as have an unusual problem. I have an enormous table, over 308 million rows. I need to perform aome operation on that table but all at once won't work here; long transaction. So I wanted to see if I could break it down by rowid's. Yes, I know a rowid (in a …
Informix 15 - Index on a temp table issue.
Hello everyone. We are in the process of migrating a user from 14 to 15.0.1.0. While testing we found a strange issue. A query runs fine on version 14 (returns rows) but does not return anything on 15: DROP TABLE IF EXISTS tmp_srteink; CREATE TEMP TABLE tmp_srteink(val NCHAR(8), …
ASF connection name error during startup
We are migrating an HDR pair to new hosts and have cloned Linux and Informix with HDR running independently between them for testing before going live. All is fine except there are two identical ignorable entries in the primary message log during startup just before or after "On-…
Experience the Difference! How a strategic partnership with IBM Software Platinum Experience deliver
Welcome to IBM Platinum Customer Experience presentation on July 15 2026 Join us to discover why hope is not a strategy—and how predictability is essential for running a modern enterprise. IBM’s Platinum Experience delivers a proactive, strategic partnership that strengthens upti…
Update to utils2_ak, myexport, and scripts_ak
Folks: Please note that I have updated my utiles2_ak, myexport, and scripts_ak packages on my web site (www.askdbmgt.com/my-utilities.html): News: June 17, 2026 myschema: Fixed an intermittent issue processing VIEWs. Thanks to Dietrich Krum for identifying the issue and offerin…
SBSPACE Chunk error
Hello All, We are working on IDS 14.10 and yesterday we created SBSPACES everything was fine, but we are getting multiple alerts for SBSPACE chunks down.But in real chunks are ONLINE. After SBSPACE Full backup didn't run . I'm sharing the screenshot for related to my Queries. Onc…
What tables reference a given table with a FK constraint?
Hi Y'all. I recall that decades ago (I think before 2005) I posted this question: Given a table xyz, how do I find all the tables that have a foreign key constraint REFERENCES xyz and via what columns. Essentially, what I get in dbaccess when I choose Info -> (Table) -> cOnstrai…
How to configure alarmprogram.sh to trigger only on errors and replication failures?
Hello, We would like to tune our alarmprogram.sh script to receive alerts only when something goes wrong. After our initial configuration, we noticed that we receive alerts for successful events, such as when a backup or a logical log backup succeeds. We actually want the opposit…
Question about connecting from Linux sles15 to a database located on windows 2016 server
Hi everyone, I have a question about connecting from an SLES 15 server-where my application is running-to an Informix 12 database on a Windows 2016 server. The issue is as follows: I log in to the SLES 15 server using the username "test" and the password "test." My application th…
View with virtual column to select count(*) will return NULL value
The problem SQL is below: create table t1 (id int, name char(10)); create table t2 (id int, name char(10)); insert into t1 values('1','t1_01'); insert into t2 values('1','t2_01'); create view v1 (id, name, tn) as select id, name, 't1' as tn from t1 union all select id, name, 't2'…
CHK REQ times suddenly getting very long
11.70 FC4GE (Yes I know ;-) I have quite a large instance (as in storage) of the above primarily doing timeseries inserts using a mixture or putelem and bulkload. It has been running for years with pretty good performance as the number of data soruces grew. It is now at about 400…
IBM Informix Standalone Container v2.0.0 - Images not found in cp.icr.io/cp/
Hello, I am trying to deploy IBM Informix Standalone Container v2.0.0 on Red Hat OpenShift using the CASE bundle from: https://github.com/IBM/cloud-pak/tree/master/repo/case/ibm-informix-standalone The operator deploys successfully, but pods fail with ErrImagePull for images like…
SBSPACE
Hello All, Need one suggestion, we are having Informix cluster environment with Primary, Secondary and RSS nodes on IDS14.10 . We have to create a new SBSPACE, as I know we need to make change in ONCONFIG file by adding SBSPACE parameter for new SBSPACE name. So can we do it by u…
silly documentation question
Looking at the online docs for 14.10 , in the SQL Syntax manual section describing the ANSI-style join syntax, I see that the "INNER" keyword is listed above the main path of the diagram, while the JOIN keyword is on the main path, and options such as LEFT and RIGHT are presented…
Created raw table in Perl program but it vanished when I exit program
Greetings y'all. This is a big mystery for me and I hope there are enough users of the Perl DBI::Informix module to recognize this problem. Consider this code in a Perl variable: create raw table $wtab_name as select date(ins_dtime) ins_date, hex(rowid) row_address from $target_t…
Quickie question: Release 12.10: What is max size of physical log?
Greetings. On a new Linux box, I created a 4GB DBspace named phnysdbs. The name kinds tells you what I had in mind for it. I tried to move it out of te root DBspace into its new apartment with this command: onparams -p -s 4194300 -d physdbs # This is a few K shy of 4GB. I get th…
Took a while ... ifx_checksum against remote table with TEXT column
> select first 10 ifx_checksum(S.cat_descr,0),S.catalog_num , T.catalog_num, ifx_checksum(T.cat_descr,0) from catalog S, stores_demo@leap16_1_a_tcp:catalog T where S.catalog_num = T.catalog_num order by S.catalog_num ; (expression) catalog_num catalog_num (expression) 286993076 …
Infromix Timeseries and Grafana
Just a FYI - if anyone wants to drop Grafana on top of their TS data then .... https://www.oninit.com/grafana Very much a first external draft - ------------------------------ Paul Watson Oninit LLC Cell +1 9133877529 Oninit® is a registered trademark of Oninit LLC --------------…
Ifx 14.10 - DNS outage strategy ?
Hello, Following a shutdown of our DNS server for maintenance purposes, we noticed the following messages in the online.log file (see below). Our onconfig have this settings : NS_CACHE host=1800,service=900,user=900,group=900,sqlhosts=900 We are wondering what the best configurat…
Problem add BSON column in a table
Hi, I have a syntax error when trying to alter a table to add a bson column to a sbspace. If I create the table with the bson column everything work. Example: drop table if exists "prog".jgc; create table "prog".jgc ( jgc_seq bigserial not null , jgc_sdbo1_seq bigint not null , j…
Informix v15 Developer Edition
Been away for awhile ... no luck locating the download for Informix v15 Developer Edition for Linux. Checked HCL and IBM. Anyone? Bueller? Thanks! Mark Scranton mark@markscranton.com ------------------------------ Thanks! Mark Scranton The Mark Scranton Group mark@markscranton.co…
Linus <-> Solaris dbaccess connection with NETTYPE issues
Greetings folks. Bottom line on top: An Informix server on a Linux host (which requires Socket protocols) needs to connect to a server on a Solaris host, which only supports tli protocols. Disclaimer/warning: I'm back in my usual form. We are trying to set a Linux box for inform…
Question on file systems for cooked files
Since support for raw devices was removed in RH 9, we're starting the process of migrating on non-prod instances to cooked files. I've got a few questions now, and likely will have more in the future. First, as I understand from a presentation Art did a few years ago, the prefer…
Need advice on compiling dostats utility
Tried to compile Art's latest dostats on a linux x86_64 machine, however both make and 'esql -o' got below errors, I am not too sure if I missed something ( I also tried to update the make executable location and INSTALLDIR, issue persists). Could I get advice? [informix@sandbox]…
Unexpected RSS authentication failure for 'leap16_2_c_tcp' during the Initialization Phase.
Just an observation really, occasionally on a fully functioning cluster the following is reported leaving the RSS instance in Fast Recovery ... a simple restart (onmode -ky; oninit) of the RSS and all is good ... 13:17:22 ERROR on the following statement SQLCODE: -243 ISAM:-154…
Update to utils2_ak
Folks: I have uploaded an update to my utils2_ak package on my web site ( My Utilities ) that includes a new myschema option, --dbschema-sizing. Dbschema and dbexport do not include the LARGE or SMALL keywords in the CREATE TABLE statements if the table was created large or small…
Table /fragment size monitoring
Hi I have a monitoring sql for a tables in a database. I want to add idenficator or name for a table fragment if a table is fragmented. We have a fragmantation where the table using mor dbspace and we have fragmantation by years in a same dbspace. I would like to compare the size…
Finally IBM release a Grafana plugin
After 10??? years of pestering IBM for a Grafana plugin they finally released one https://grafana.com/whats-new/2026-02-24-explore-ibm-db2-data-directly-from-grafana/ [Sorry if posted twice] If anyone wants a plugin for Informix TS then ping me -- Cheers Paul Paul Watson Oninit …
Sessions and transactions
Hi Y'all (with a capital Y ) A few weeks ago I posted a question about transactions and, with the help of Markus, I was able to create the query and wrapping script that I was planning. My manager liked the idea but now asked for a similar scripts to summarize session, so we can…
Informix JDBC 15.x download place
Hello, where can I get recent jdbc version 15.0.1.5? jdbc downloads used to be on Fix central or developer downloads but newer recent versions I cannot find there. Thanks a lot ------------------------------ Milan ------------------------------…
Petty comments on Version 15 ...
Hi ... just because ... 1. Warning: Parameter duplicated in config file (/products/15.01.FC1/etc/onconfig_leap16_j_a). Only the first occurrence will be used. (USERMAPPING) > grep USERMAPPING onconfig.std # USERMAPPING - Control access to the server for users without operating US…
LVARCHAR to CLOB data casting via encrypt and decrypt
Hello All, I need suggestion for selecting the data from a table after decrypting from CLOB column type. Data is being stored in a table which has LVARCHAR data type(earlier created) in encrypted format and then inserting in another table (newly created) which has CLOB data type …
Install IBM Informix 15 on openSUSE 16 (Leap) and default java install ... and permissions not set
Latest openSUSE 16 (Leap) zypper install java # ./ids_install Preparing to install Extracting the installation resources from the installer archive... Configuring the installer for this system's environment... Launching installer... ===============================================…
AXIS2C removed from 4GL
Hi all, AXIS2C server is removed from 4GL distribution since 7.51.xC2. Please, what can we replace it with? ------------------------------ Sincerely, Dennis ------------------------------…
onstat -x and sysmaster:systrans
WOW! I feel so anachronistic! Here folks are discussing release 15 and "large tables" and I'm back in release 12! I am almost certain Lester K must have posted a query about this but I can't find it. So I ask the community: Here's a sample of output from onstat -x , filtered …
Informix 15 compatibility mode
After upgrading from 14 to 15 the server is in Compatibility mode. If there is no plan to use larger tables, chunks, and page sizes would it be OK just to keep it in Compatibility mode indefinitely? Or are there some other 15 features missing in this mode, like will we still be …
Informix 15.0.1.0 Time Limited Trial Downloads
Hi, On https://www.ibm.com/resources/mrs/assets/packageList?source=ifxids&lang=en_US the Enterprise and Advanced Enterprise Time Limited Edition Installers for 15.0.1.0 are missing. Regards, David. ------------------------------ David Williams Senior Database Platform Engineer Fl…
Informix 15 questions
Hi y'all. Is anyone running V 15.0.1 in production? If I keep all tables SMALL in V15, can I use the legacy client SDK or do I need the SDK 15.0.1? Thanks in advance, Snorri ------------------------------ Snorri Bergmann ------------------------------…
Cute: Lowest log sequence numner on transactions VS lowest log sequence number
Here's a cute riddle posed to me by two onstat commands. No downed server, not problems, just this curiosity nagger: Owing to the messages that motivated my questions on IPL complaints I was curious to see some of this with my own investigation. To start with, I wanted to see a …
Serial and pseudo-rowid values going negative
Hi again today. It is known that when I create a table "with rowid" (or alter fragment .. with rowid) the server create a shadow serial column named rowid and and index named "system-rowid" to go with it. We have experienced serial values overflowing the 2^31 threshold, resultin…
Is there an easier way to tell if a table was built "with rowid"?
For various reasons, mainly the need to partition some tables, we will need to alter fragment .. with rowid for some tables. But to avoid redundancy (and maybe upsetting an existing pseudo-rowid) I need to determine which tables in a database already have "with rowid". I know f…
How to decode value of ifx_replcheck
Hello, can someone help with decoding value in ifx_replcheck? - I have read in docs it is timestamp plus row version but need more precisely. We re using ifx_replcheck to identify changed rows since last recorded values for rows. Currently we are looking for why ifx_replcheck is …
Shadow column
May I ask how to retrieve a table list for all the user tables that have shadow columns? (going to retire CDR). If after we stop using CDR, would it safe to drop shadow columns (by: ALTER TABLE table_name DROP CRCOLS;) from all user tables? After drop shadow columns, shall we ru…
ancient Informix product - Perform
This one is for the Informix dinosaurs who remember Ace and Perform. The manual documents the pf_getval() as: pf_getval(tagname, retvalue, valtype, vallen) char* tagname, *retvalue; short valtype, vallen; and it lists the possible return values as: 0 The operation was successful…
Alert regards incremental backup (L1, L2) with large number of sblobs
Hi Informix Enterprise user, I believe it is my duty to point out defect DT462130, as it leads to a server status of 'Blocked:archive', which can only be resolved by a 'hard' restart of the server. DT462130 description from Support: "The defect is about an incremental backup (L1,…
Speedup Index Creation on a large table
Hello All, Greetings from amit. I need some suggestion from you all. I'm creating an index on a table which is having 230 Millions of records. Table is fragmented and having NVARCHAR columns, so we can't create ONLINE index. This index creation is taking around 6 hours. index siz…
IIUG March TechTalk
IIUG March 2026 TechTalk: An Amazon-style B2B e-commerce application fully powered by Informix with Xavi Escoté Llopis We've built an enterprise-grade platform for customers that mirrors the core capabilities of Amazon - product catalogs, ordering workflows, pricing rules, custom…
Update to utils2_ak
Folks: I just uploaded another update to my utils2_ak package: myschema: Added a new option, --enable-boost, to include SQL API function calls to enable PFSC Boosted Caching of free space in variable length tables when this feature is enabled in the source database for a table. T…
IDE 15.0.1.0 : JDBC could not open database table
I've tested with DBeaver & RazorSQL, both failed. DBeaver: RazorSQL: DBeaver database snapshot: ------------------------------ Baharuddin Masdar ------------------------------…
IPL commit (tx:
Hi Y'all. There a message that occasionally pops up in the message log; here's one from December of last year: 12/29/25 21:56:19 Warning: IPL commit (tx:396465e28) is suspended, waiting for an open transaction from the oldest logical log (< some seq num >) to complete. When I go…
Changing from raw to cooked
As many of you know, RH dropped support for raw devices starting in RH9. I know, I know - they've dropped support in the past and then added it back in. This time, so far as I know, they have not added it back. One source claimed that Linus finally got his way and support for …
Parameters adjusted at startup
Greetings, Y'all. (Spell-checker does not object to "Y'all". Cute.) I have a newly configured toy RH Linux system at work. When I bounced it this morning, watching the online log, the first lines were: Parameter's user-configured value was adjusted. (DIRECT_IO) Parameter's user…
Replication not replicating
Good day All In need of assistance. I have this issue on replication. Replication not replicating from server 1 to server 2. both server is connected and active. if i check replication queue it clears but the data is not replicating from the one server to the other server. Replic…
Query F.E. Version in sysmaster ?
Is there an option to query the F.E. Version of Clients in sysmaster database ? I found syssqscb:scb_feversion, syssqlstat:sqs:feversion and views based on these tables, but all of them Return 9.03 since years (this problem is also mentioned in several cases). The background: I w…
Obtaining IBM ODBC driver for Informix
Download the CSDK from IBM fixcentral/PA site (good luck finding it though) Note - the latest pyodbc will not (or didn't work) with the latest ODBC driver, I need revert back a revision on the pyodbc. If you search the list you should be able to find what I go…
Update to utils2_ak
I have uploaded an update to my utils2_ak package with a fix for dbsavail: dbsavail: Fixed the free space and free percentage calculations for smart blobspaces. Thanks to Roland Wintgen for identifying the issue and helping to test! Also fixed the compile time warnings when compi…
IDS 11.70FC4 Timeseries Bug
I know it's old but it's all I have. I have no idea if the bug still exists but it may save someone time - it cost me quite a lot of time yesterday ;-) Given a table 'tab' with timeseries with a key of 'key' with a rowtype of just an integer, and a corresponding virtual table v_t…
How to estimate the free size of smart blob dbspaces?
Dear community members, In his presentation on the sysmaster database ( https://advancedatatools.com/webcasts/managing-and-optimizing-the-ibm-informix-server-using-the-sysmaster-database/ ), Lester Knutsen has published an SQL query (dbspace_free.sql) that determines the free spa…
Upgrade from IDS 15.0.0.2 to 15.0.1.0 errors for IPA's
Hi everyone, When I try to upgrade from 15.0.0.2 to 15.0.1.0 I have errors about IPA's. On 15.0.0.2 I run for each database: select sysadmin:task("table update_ipa",tabname) from systables where tabid >= 100 and tabtype = "T" ; When I start 15.0.1.0 I have the following messages:…
Connection Manager - spelling of DISABLED not checked for FOC
Just saying … spell DISABLED wrong under FOC and nothing reported BUT failover can be performed by CM … and lo - two headed PRI. Having two CMs in failover for two clusters and they seem real flaky on startup as regards consistent behaviour (I.e. sometimes works, sometimes doesn'…
Java Version for Informix Installation
Just an FYI for which java versions to use. It's a bit frustrating having to reinstall java 8 just to get the licensing installed (also a waste of time to figure out). IBM Informix Dynamic Server Version 14.10.FC11WE you can use Java 11 or 8 IBM Informix Dynamic Server Version 1…
Logical log's and initialize new instance
Hi group, The logic for 6 small log's at initialize a new instance and in root dbspace is : we know that dbspace will be there. A lot of on config values are set to small / starting values to get instance up and initialized. Then set up instance: add new dbspace's / chunks Move …
Error in COMMIT WORK when trying to add a chunk
Strange things happen around here. Kidding aside: We just created a new instance so there is exactly one DBspace with one chunk. Now we want to add a chunk. $ onspaces -a rootdbs -p /usr/informix/bnhprod5_rootdbs_ch2.p -o 0 -s 2097104 Verifying physical disk space, please wait .…
IDS 14.10.FC13 compatibility with other Informix tools
Hi Experts, We plan to upgrade current IDS 12.10.FC10 to IDS 14.10.FC13 on AIX 7.2 and noticed that apart from IDS 12.10.fc10 we have other installations (below) on the same AIX server. We are in the planning stage & would like to know if all these tools below are compatible with…
DRDA redirection to HDR primary
I was recently unable to work out how to do this directly on latest IDS 14.10. I am about to write a technical article on a work-around using Connection Manager, but that involves more effort and failure points. Does anyone know how to construct a DRDA client configuration so tha…
Long transaction message discusses a strange number
Hi Y'all! We had a long transaction rollback on a test system. Here's the report in the message.log: 01/21/2026 15:42:10 Aborting Long Transaction: tx: 0x1d298fba8 ID: 847 username: reubens uid: 5168 01/21/2026 15:42:10 Rollback For Long Transaction 847 Started. ... 01/21/202…
using ER to clone a table with different column type
Keep the schemas the same for loopback then trigger on the target to move the row into the new table. But why can you just insert into new select * from old ? Cheers Paul…
Open MCP servers
Hi y'all. Are there any open MCP servers for Informix you know of? I'm using Claude. Thanks in advance, -Snorri ------------------------------ Snorri Bergmann ------------------------------…
Informix 15.0.0.2 IL1: Insert from SMALL table into temp LARGE table very slow
Hi community, We are still testing for Migration from 14.FC4W1 and 14.FC11 to 15.0.0.2. During our tests we recognized, that only after activating Infrastructure Level (IL) 1, a specific script which usually takes about 240 seconds suddenly took over 2 hours. When setting TABLE_S…
onstat -g opn does not match published documentation
Greetings, Family. As a curiosity, and to follow up on a Perl script I never got around to writing, I wanted to see the output of onstat -g opn (open tables/partitions). The printed (PDF) manual on 12.10 (P 20-121 or 587) gives a format and explanation that could be helpful and l…
Informix 15.0.0.2: Aggregate function group_concat now built-in created but the underlying functions are not.
Double post from drafts, please ignore.…
any recommendation on NONEXCLTRIG parameter?
Hi Informix community, We are facing an issue to create trigger on a table , always get error saying not able to obtain exclusive lock. I did try to set lock mode to wait, it didn't help. ( db runs on 14.10.fc10w2 ,linux) When I checked onstat -k and onstat -g ses 0 output, there…
Executing a query just once without it using any cache
Hi everyone, I'm using Informix 14.10.FC8 and I'd like to execute a query just once without it using any cached plan or statement cache - basically, I want it to be fully re‑parsed and re‑optimized for testing purposes. Is there any supported way (per‑session or per‑statement) to…
Next IIUG TechTalk
IIUG January 2026 TechTalk Meeting – Understanding How Indexes Work with Mark Jamison January 15 @ 2:00 pm EST Free Join the IIUG for our first free Informix Tech Talk of 2026! Understanding How Indexes work, what type of Indexes there are, and basic Performance tuning considera…
BlockLogXmit status
| view attached (2) Dear All, Happy New Year to All. I'm working on Informix 14 on Solaris 5. We get one issue mostly in every 3 months around for replication issue between Primary Server and RSS server and get the status on Primary server as "BlockLogXmit" and we need to restart…
Can't license IDS version from FixCentral?
Hi All, My dev machine is windows. I had to reinstall my local informix instance from scratch so thought I'd put the latest available on, in this case 14.10.FC13 from fix central (I can't do v15 due incompatibilities with production running v14). We are licensed for Workgroup Edi…
Listener Thread
Hi All, How can I tell if my listener threads are over worked , is there a gauge to monitor the performance of the listener threads? Basically, We have many applications that constantly logon and logoff, when it gets really busy complaints are coming in that it takes too long for…
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…
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…
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…
#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 --------…
Error -25587 using a shared memory connection.
Hello everyone. I was trying to run some heavy Genero 4GL jobs on the DB server via a shared memory connection. Some ran fine but other jobs crashed almost immedately (while in a cursor loop) with error $ finderr -25587 -25587 Network receive failed. A system call has failed. …
User-Friendly External Smartblobs Using a Shadow Directory
Hi All: I don't write here much, but I'm an Informix old-timer. I've worked w/ Informix since RDS Informix 3.3 on an IBM PC-XT. I worked at Informix Corp and IBM for ~20 years back in the day. Coincidentally, I've been here at Actian (a database/integration company) since 2006…
Memory block header in pool 'rsam' corruption
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE We got 5 occasions of memory block header corruption in less than 2 hours, all in pool 'rsam'. Two of these occasions generated AFs that emerged in online.log. And these 2 occasions appeared simultaneously with dbs_partn mutex c…
DIRECT I/O (KAIO) Disabled in RHEL 9
Installing Informix 14.10.FC10 in a new linux RHEL 9 server. KAIO is disabled and I don't know the reason: rpm -qa | grep libaio libaio-0.3.111-13.el9.x86_64 ls -l $INFORMIXDIR/bin/oninit -rwsr-sr--. 1 root informix 28388480 Mar 8 01:38 /home/informix/pdbwic2016_dev/bin/oninit o…