Threads from 2026
Browse by month: Jan · Feb · Mar · Apr · May · Jun · Jul · Sep · Oct
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…
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…
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…
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 …
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 …
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 …
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…
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 ------------------------------…
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…
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…
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…
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…
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. …
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…