Threads from 2022
Browse by month: Jan · Feb · Mar · Apr · May · Jun · Jul · Aug · Sep · Oct · Nov · Dec
Hibernate 6 does not support Infomix anymore
Hello, Hibernate ORM 6.0 was released in the summer of 2022. And Hibernate ORM 6.x no longer supports Informix,The InformixDialect has been removed from Hibernate. Hibernate no longer sees the need to support Informix. Has anyone found a way to use Hibernate ORM 6.x with Informix…
stat() failed for chunk file
Hello. I have Informix 14 FC8 on Windows Server. All works great, but when server is starting i see message in log file to all my chunks: Warning: stat() failed for chunk file... How I can fix it? ------------------------------ Alexander Ivanov ------------------------------ #Inf…
Ontape parameters
Dear colleagues: I need to make backups on tape. I have an external HP LTO Ultrium 6 drive with native 2.50TB cartridges, and my problem is focused on the TAPEBLK parameter, which I had at 2048 when I backed up to disk, but when I want to do it to tape, the ontape tells me that d…
Informix KMIP Encryption
Hello Team, One of my customers is migrating from the Local Key Store to KMIP Key Store. They have tried migrating from the Local Key Store to KMIP but the Database stops working. Any recommendation?? Regards Amit Kumar Thakur Software Engineer : Customer Success. ---------------…
r4gl won't work/does nothing
Hi: After many years of being away from Informix, I am back building an Informix demo. I want to use the 4gl standard demo. For reasons I won't discuss here, I have installed IDS 12 in one directory and 4GL 7 in a different directory. I'm on centos 8. I've never installed tools…
ALTER TABLE removes it from audit trail
Hi. Ran into a strange situation. ALTER TABLE xxx ADD AUDIT; Do a dbschema and the WITH AUDIT clause is present. ALTER TABLE xxx ADD (c int); -- or whatever Do a dbschema and the WITH AUDIT clause is gone. Surely a bug? Newest version I tried this with is 14.10.FC7W1 Best regar…
Unable to interrupt SQL queries in some cases
We have some problems where we are not able to interrupt queries in dbaccess with certain combinations of clients and servers. Could it be due to some traffic passing a firewall in the network? How is sqlbreak() (which I am guessing is used to implement the interrupt functionalit…
WAIUG Meeting/Tech Talks - December 8, 2022
A reminder that the Washington Area Informix User Group (WAIUG) will hold a virtual meeting on December 8 starting at 9 AM EST. You don't need to be a member of the WAIUG or IIUG to join the webcasts, but please register at WAIUG Meeting Dec 8th Coming Up - Washington Area Inform…
Issue with roles
IDS 14.10.FC7W1 RHEL 8.6 I'm having the weirdest problem with roles. I'm running the following sequence of statements while connected as the owner of the database: database my_dev_database; -- successfully connected to database select * from sysusers where usertype = "G"; -- no …
IIUG Sale - Purchase the Informix 14.10 Exam for $49.99 US
IIUG Sale - Purchase the Informix 14.10 Exam for $49.99 US We are running an end-of-the-year sale price for the Informix 14.10 Exam. Purchase the exam by the Midnight December 31, 2022, EST, for $49.99 and take up to 90-days to schedule and complete your exam. Once you have succe…
index on timestamp & optimizer strategy failure
I've got a large events table (~1500 million rows) with 2 timestamps (datetime hour to second) recording a time associated with the event and a time when the row was inserted. The event-time may be in the future, but in most of the cases it is near the actual point in time. If th…
Inner Join
I need to do an inner join where I need to bring only the records that were updated with the date >= today, The tables do not contain a column that informs a record update date to use as a reference, how can I solve this? ------------------------------ Fabricio Moura ------------…
Informix 11.5 and Server 2012R2 – Database stuck in Quiescent Mode
I am experiencing an issue with an archive Informix database that is stuck in quiescent mode. When trying to start the service in windows services I get the following error: "The informix IDS – service on the Local Computer started and stopped. Some services stop automatically …
Better performance with temp dbspace in RAM disc?
Hello, we have the workgroup edition, which is bound to 32GB shared mem. Some machines have 64GB RAM or more... so my idea came up to create a 24GB RAM disc and move the temp space in the ram disc. Anyone tried that before? It should boost performance or ? BR, Marc --------------…
Backup from InformixHQ and continous log backup
Hello. Actually I have two questions. 1). I set up a backup from informixHQ. Is there a way to send me an email when the backup is in progress or if it fails? I have configured Informix to email me from various alerts, but I can't find the backup alert. 2).In my current configura…
shmget: [ENOSPC][28]: key 525f4802: The server could not allocate shared memory because an operating system limit was reached
Hey gurus, What do I need to increase to allow the database the ability to add additional virtual memory segments? HCL person could not answer my question when I opened the case and I have dozens of servers getting the same message. -- Thanks, Kate Tomchik She/Her/Hers Principal…
In-place alters and rolling back to a previous version of Informix
I understand that if we want to have the ability to rollback to a previous version of Informix after upgrading to Informix 14, then we need to perform in-place alters for certain tables that need them. Here is a link to an article about how to do in-place alters: https://www.ibm.…
onstat -c $INFORMIXDIR result
Hi, I have one script that uses onstat results as arguments, on bash I am veryfing one issue. As INFORMIXDIR appears on some variables they are not resolved by shell #!/bin/bash ONLINELOG=$(onstat -c | grep "^MSGPATH" ) # This command return something like $INFORMIXDIR/tmp/online…
How to see what querry blocked table?
Hello. I have Informix 14.10. I started the session and checked DBINFO('sessionid'). Then in that session i ran: BEGIN; INSERT INTO ttt VALUES(1); In another session i ran SELECT * FROM syslocks; and see 2 locks on my table and the owner is my sessionid. I was expecting that whe…
Blade server (hs 23) hard disk information
Dear all, I have bladecenter hs 23 and I want to know hdd serial and product number of blade server. I can't find any information. I logged in bladecenter advanced management console and I see more of them have infor about sn and pn number except hdd/ssd. Best regards, Sabina Agh…
RSS stopped log apply when setting DELAY_APPLY=1s
Hi, My IDS version is 11.5.FC9W3, I use RSS to do the data migration, originally the primary instance have only 2 rss. I add another 4 RSS instance recently. so totally I have 6 RSS now, and I found if I set DELAY_APPLY=1s in 4 instance added later, those 4 RSS will stop to d…
Where can I download ESQL/COBOL
Hi everyone, Last year it was still possible to download the ESQL/COBOL SDK but today I did not success to find the download location. Is someone know where I can find it please? Best regards, ------------------------------ Stephane GONZALEz ------------------------------ #Inform…
dbimport to the older Informix
Hello. We have a task to move from Informix 9 to Informix 14. We tested our program on Informix 14 and so far everything looks fine. We will change the production version soon. So while we decide what to do if something goes wrong. Of course, we don't want to lose data. Will ther…
Swapping Primary and RSS roles in HDR Replication Without A Backup/Restore
Hello everyone, I have not had to swap primary and RSS secondary roles in a while (years) and I have never used the "oninit -PHY" option. Whenever I swapped the roles of such servers in the past, I always went through the usual synching involving a level zero backup and restore. …
In-place upgrade with DBDELIMITER problem
Hi all, just opened case: If you have audti turned on or you use external spaces, you have to unset DBDELIMITER before in-place upgrade. Explaination: During in-place upgrade two scripts are responsible for unloading and loading data: smi_unld and smi_load smi_unld just unloads t…
Revoke Role public from user
Hello. I have an old Informix 9. Now I need to create a user with select permission only. 1. I have created an OS user and am using GRANT CONNECT. 2. I checked that the user can connect and see my tables, but can edit the data. 3. I tried REVOKE ALL ON table_name FROM user_name, …
Informix 14 and AIX 7.3
Hi all customer wants to buy new HW (P10) and they want AIX 7.3 - but according to Informix Server System Requirements ( Informix Server System Requirements ) this is not supported combination. I know it is working but customer wants IBM to state that. Whom do I have to contact? …
Unregister a blade?
Informix 12.10FC14 Solaris 10 1/13 I do not seem to be able to unregister a blade. Observe the following screen scrape: informix@ifmx-prod-jnu>blademgr prodjnu2tli> prodjnu2tli> list acoms DataBlade modules registered in database acoms: excompat.1.0 binaryudt.1.0 ifxregex.1.00 …
V14.10.FC9 installer missing librarie(s)?
After a full root installaton informix@Elbereth:~/GoogleDrive/IBM_Files/installfiles$ $INFORMIXDIR/bin/oninit -V cannot access /opt/informix/infmx.14.10.FC9DE/lib/libisi.so.2 No such file or directory (errno 2) IBM Informix Dynamic Server Version 14.10.FC9DE Mon Oct 3 16:03:02 CD…
Getting IDS 12.10 FC12 support on RHE 8.6
HI Everyone We have a system upgrade need in our datacenter , whereby we need to upgrade our current RHEL6.x OS system to RHEL 8.6 and that is driving our need to get 12.10 FC12 being supported by IBM on RHEL 8.6 otherwsie its is a upgrade without IBM supported platform. Also we …
IIUG Board Nominations
Folks, Nominations for the 2023-2024 IIUG Board will close at midnight EDT on November 7, 2002. If you are interested in becoming a Board member, please review the information on the Election Page at https://www.iiug.org/en/iiug-board-elections-2023-24/ and submit your nomination…
Informix - uniqueidentifier
Hi, In SQL Server they have - uniqueidentifier In Informix, what data type I should use ? Please help ------------------------------ Dalia Hudson ------------------------------ #Informix…
Performance V 14 is significantly slower compared to v 11
I had opened a series of support tickets with IBM and we had been battling this issue for months. We are migrating from IDS 11.7 to 14_10 FC7 and had set identical configuration, on both. We changed a little on v14 on the following moved to 3 temp dbspaces from 2, and from 40Gb…
New location for CSDK / JDBC files, correct URL for Trials and Downloads
As covered in the recent FC8 webcast, the Informix Trials and Downloads site has become the comprehensive repository for CSDK and JDBC drivers. All available 4.10 and 4.50 drivers are now located there along with the Developer Edition and Time Limited engine downloads. In some ca…
Replay of Informix FC8 webcast now available
The replay and presentation materials from yesterday's IIUG sponsored webcast on FC8 functionality and announcements is now available in the Library : Webcast Replay section. The video should be available on the IIUG TechTalk YouTube channel shortly. -----------------------------…
Excalibur on Linux
Hi All, I realize this is a total shot in the dark, an extended reach ---- but is anyone running the Excalibur Blade on a Linux server? We have code downloaded in early 2021 for version ETX.1.31.FC1, but the latest version is FC2 and we cannot find hide nor hair of it in Passport…
Onmode -wm don't change some parametrs
Hello. I have Informix 14.10 and I am trying to use informix -wm to change onconfig options. But for example "onmode -wm RESIDENT=-1" works well, but "onmode -wm CLEANERS=4" shows me a message saying "The configuration setting to be changed is invalid or not supported with this o…
Create Type As Enum
I see in keyword ENUM. Anyone try to create type(not row type) as enum ?! i don't find any example with enum or how to use enum in informix. ------------------------------ iliyan iliev developer MoI-DCIS ------------------------------ #Informix…
Updatable Seconday
Hi All Till now i always used HDR as a Read only Server, but Could it be updatable ? and if so will the data updated on HDR be written on the Priimary ? Thanks in advance ps: working with informix 11.70, 12.1 and 14.1, ------------------------------ John Smith -------------------…
SPL Creation Date?
Informix 12.10.FC14 Solaris 10 1/13 How can one determine the creation date (or last modified date) for a stored procedure? I have looked at what I thought were likely tables in the system catalog, but, haven't found that information, yet. Thank you. Regards, DG ----------------…
Potentially Serious HDR Failover Bug
All: Over the weekend, we hit a serious issue that created a huge mess from which we're still recovering. 14.10.FC8. We have a three-node HDR cluster (I still want to call it "Mach 10" because I'm An Old) with one node as PRI, one node as HDR and one node as RSS. HA_FOC_ORDER is …
IO WAIT
Hello Traced some sql statements and noticed some iowaits, i checked io on chunk (-g iof) but needed also any feedbacks about analysing io wait please this example is useful to understand my case, runtime in 2 sec, but totaltime 12 sec, no locks, no sorts ...nothing but io waits …
demo/c++ link failure
Hi All, I am working on HP-UX 9000/800 platform. I am trying to compile the demo source code provided with the Informix 14.10 client. (informixConnect_1410/demo/c++/) I modified the make file in order to use gcc and c++ compilers rather than cc and aCC. Unfortunately, any demo pr…
demo/c++ link failure
Hi all, I am working on HPUX 9000/800 platform, and I am trying to build the c++ demo code provided with the Informix Client 14.10. Because I don't have aCC compiler I modified the makefile in order to use gcc and c++ compilers. Unfortunately, I get an error during the link phase…
Why is the built-in lower() function variant?
As we know, when creating a functional index, the function needs to be non variant. So, for instance if we want to create an index on the result of lower() on a field, we need to wrap it in a UDR and declare it as NOT VARIANT. But why is lower() considered a variant function? If …
Separate DBspace for indexes
Hello all. I have a task to migrate from 9 to 14 Informix. I saw Lester Knutsen's webcasts and he recommended separating indexes from data. At the moment the indexes are not separate. Can I, as a DBA, automatically separate all indexes from data after I import data from 9 to 14 I…
Ifx 14.10xc8 - ISAM error: operation illegal on a DR Secondary
Hello, I need help for : IBM Informix Dynamic Server Version 14.10.FC8DE -- Updatable (RSS) we are testing an hdr/rss (updatable) configuration and we are getting systematic errors like this on rss : 229: Could not open or create a temporary file. 140: ISAM error: operation ille…
Replication of Informix
Hi Team, I am setting up HA for Informix. I am getting issue with trusting both Primary + Secondary Servers. The errors are as follow: Primary DR: new type = primary, secondary server name = labsoc DR: Cannot connect to secondary server DR: Turned off on primary server Secondary …
libbsapsm.dll missing
Hello. I am learning Informix from scratch. I installed Informix 14 Express Edition on Windows Server 2019. Now I'm trying to use "archecker" but it can't work because it needs "libbsapsm.dll". But there is no such dll in my informix folder. Where can I download it? -------------…
alarmprogram.sh not backing up logs after upgrade
This seems to happened every time I upgrade our ERP server. SUSE Enterprise (SLES) 11.4 -> 15.4 and Informix 12.10.FC7 to 12.10.FC13 Added some debug lines in the script and showing a 127 error - which not sure makes sense as permissions look ok I think. can't seem to figure out …
onconfig.std errors
All: While upgrading an engine to 14.10.FC8, I noticed a couple of issues with onconfig.std: - It still lists GSKIT_VERSION even though that parameter has been deprecated - It lists noage as a valid parameter for VPCLASS aio and VPCLASS jvp, even though it's only valid for VPCLAS…
How many sql statements
Hello In order to activate SQLTrace, wanted to have an idea on how much sql statements are run during a day? is there a system table that record this stat ? or is there another way (Informix 14.1) thanks in advance ------------------------------ John Smith -----------------------…
Documentation error?
syssqltrace table: syssqltrace description ends with: although sql_statement type is char(16000) and there are 7 more fields in this table. Hrvoje ------------------------------ Hrvoje Zokovic ------------------------------ #Informix…
Informix DB_LOCALE use utf8 matches '[a-z]' got wrong results
Informix set DB_LOCALE to en_us.utf8, the matches '[a-z]' got the wrong results. I tested the Informix version 11.50, 11.70, 12.10, 14.10, all had this BUG. Below is the test case: export DB_LOCALE=en_us.utf8 export CLIENT_LOCALE=en_us.utf8 export GL_USEGLU=1 on14fc8:/tmp$ dbacce…
Smart Triggers Push Data and restarting from commitTime or txnid
Hi, I'm trying to test out the push data feature of Informix to verify it can do what we need it to do, which is not lose data if our consumer goes down. I've got a java application based on this code public class BankMonitor implements IfmxSmartTriggerCallback { public static vo…
Backup Status
Good day Inadvertent setting of RTO_SERVER_RESTART and CKPTINTVL caused some grief with checkpoints not being instituted correctly and the system ran for some days, and someone bounced the server, resulting in data loss. Therefore we have decided to include regular Level 2 backu…
list sql statements
Hello Usually i use onstat -g top to figure out the most consuming CPU sessions, but i need also to list all sql statements (not onstat -g stm with only thos on cache), with there costs, duration, prefectly , these informations (sessid, sql statement, cost, duration , cpu consum…
Connection Manager Issue (Rampant Speculation Invited!)
In which I describe a problem and invite rampant speculation. We have a CM (Connection Manager) with multiple redirect mode TLS SLAs where one of those SLAs would routinely stop responding. Sessions would connect and redirect as expected for a brief period of time, then all subse…
delete time series data using tscontainerpurge
Hi, i tried to delete time series data through a specified timestamp using tscontainerpurge with this script: - unload to "regular_purgetest.unl" SELECT GetContainerName(para_values),InstanceId(para_values),GetIndex(para_values,'2018-01-01 23:00:00.00000'::datetime year to fracti…
Tales about end of life
Hi , To HCL, It's very sad, after 21 years after IBM bought Informix, I still hear (read) from other IT companies this: "We've also been hearing that Informix might reach end-of-life soon, which would be something we'd have to consider as we think about a native integration." I'm…
Informix 14.10 Linux
Hi, We 've this message when starting informix : 10:56:08 WARNING: Number of cpuvps (6) * kaio chunks (8) + aiovps (1) * number of non-kaiochunks (1) exceeds system wide file descriptors (-1) defined in /proc/sys/fs/file-max. This may lead to unpredictable system behavior. cat /…
Informix recommended setup for storage
Hi everybody, we are planning a new database server (pair, should be HDR) for a huge customer. Our admins started a discussion on how to configure storage. We want to have ~6TB of space and are planning to be running with a set of NVME Raid (Raid 10, 5 disks e.g. 5x3.8TB like Sam…
anyone using SolarWinds for monitoring?
Informix 14.10.FC7W1 on RHEL 8.6, SolarWinds APM 2020.2.6.50231 So the company is using SolarWinds to monitor several Windows servers and SQL Server databases, using the APM (Application Performance Monitoring) and DPA (Database Performance Analyzer) tools, and there is an effor…
Odd -1266 error with combined conditions and fragmented index
Hey, everyone. Hitting a weird issue which I can replicate on 12.10.FC14, 14.10.FC7 and 14.10.FC8 (all on CentOS). Run the script below (change the dbspace names in the index creation statement to ones that exist on your system). All of the statements work except for the final on…
Phantom rsccompdict table
Informix 12.10FC14 Solaris 10 1/13 I am attempting to delete unused chunks from an Informix rootdbs. One I would like to delete is almost empty. I say "almost" because when I examine the objects in that chunk, I observe one table: rsccompdict. I have looked at two sysmaster tab…
start onbar and ontape simultaneously
HI, all: When the onbar backup is running, I start a ontape backup simultaneously, the online.log display: Archive on rootdbs,phydbs,logdbs,datadbs ABORTED. Does it mean when the onbar is running I can't start ontape to do the backup again? Thanks for your time. -----------------…
Empty Sblob Chunks?
IDS 12.10.FC14 Solaris 10 1/13 It is only in the last few months that I have had to pay much attention to smart blobs. I admit that makes me an antedeluvian troglodyte. Below is part of the output of 'oncheck -pe' for a particular sbspace in one of our systems: Are all those h…
Find start value of SERIAL/BIGSERIAL column
Hello! Where can I find the start value of a column defined as SERIAL( start-value ) or BIGSERIAL( start-value ) in the Informix system tables? I did not find this in the syscolumns... Seb ------------------------------ Sebastien FLAESCH ------------------------------ #Informix…
TLS/SSL with IBM Data Server Driver
All: We have a .NET application which, unfortunately, is connecting to Informix using the IBM Data Server Driver v10.5. We need to change our connections to communicate via TLS/SSL rather than unencrypted. Does anyone here have any experience with this? From what I can tell, the …
Pages allocated / pages used
Hi Fellas, we have a RHEL8 system with 14.10.FC7WE running. 4K dbspace with a huge wide table with 182 columns and ~10 million rows. Number of pages allocated 16777215 Number of pages used 16777215 Problem is, that we already reducded that table from ~28m to 10m now and again we …
Informix 14.10 FC8 installation on Linux
Hi, Any idea on the following errors ? Done this for 20 + years, first time got this:-) Thanks Frank 1) case 1 Root# ./ids_install Preparing to install Extracting the JRE from the installer archive... Unpacking the JRE... Extracting the installation resources from the installer a…
more than 4 RSS NODE
Hi, Do anyone has reference that one primary node has more than 4 RSS node in the production environment? Does the primary node wrok fine ? my IDS version is 11.5. ------------------------------ chuan lu ------------------------------ #Informix…
restore through STDIO
HI, I want to backup the instance and restore to another 3 instance. 1, I run the blow comand to do the backup. ontape -s -L 0 -t STDIO | gzip >level-0.gz then, I use scp copy the zip file to another machine. 2, I try to run below command to do the restore , chmod 660 level-0.gz …
Enterprise Replication and IfxSmartTrigger doubts
Hello, I'm capturing some events on a informix database using IfxSmartTrigger in Java. My first question is about ER function to reset capture, i tried to execute the following function on sysadmin: execute function admin("pushdata reset_capture", '{"logid":"440467", "logpos":"0x…
Spammed by Lil Durk - Malware?
Just FYI - I received 6 emails from "Lil Durk via IBM Community" on August 22, 2022 between 1:05AM (ET) and 1:12AM (ET). Apparently, the real Lil Durk is a rapper. One of the links is https://lildurk.com, which is not the rapper's website. Whois shows the website hosting company …
HA - Switch between Primary and RSS
Hello, Is it possible to switch HA types between Primary and RSS as we can to do with Primary and HDR We have a set of three servers (without Connection Manager) Primary / HDR / RSS (on remote site) And we'd like to do this (for testing purpose): Primary -> RSS…
Connecting to a high-availability cluster through IBM Informix Connection Managers
Hi, I have a connection problem using java applications with jdbc through IBM Informix Connection Managers The situation is the following: I have a high-availability cluster (c1) that is composed of two servers. The user name on all cluster servers is user1 . The password on all …
9628 error with binaryvar
Hi, I'm having a phenomenon with a script, on some servers it works on others with the same version of informix 14.10 or 12.10 I get this error: 9628: Type (binaryvar) not found. indicating unknowledge about this kind of field. I've been trying to find information about this erro…
Informix 14 Certification
Hello, I have earned the IBM Informix on Cloud V12.10 Database Administrator badge in 2020. Do I need to upgrade to the 14.10 version of the badge? Thanks, ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of --------------------------…
Bringing down and up a HA cluster
Hello Is there a preferable/right order to bring down and up a HA cluster (primary / HDR / RSS) ? Also is it better to pass through quiescent mode, forcing a checkpoint,... Thanks ------------------------------ Samuel ------------------------------ #Informix…
Innovator-C download?
We want to use the Informix Innovator-C Edition. The links (both the Developer and Innovator links) are broken. Clicking on them yields: Oops - that's not right! The page you requested cannot be displayed. 503: Service Unavailable Suggested actions If you typed the address, plea…
ReadAhead for rollback error message
Hello All, My customer's Informix encountered a type of error message that didn't normally occur. What could be the cause? 08/05/22 17:04:27 Logical Log 996906 Complete, timestamp: 0x530fc895. 08/05/22 17:04:31 Performance Advisory: ReadAhead for rollback failed to find valid LLo…
quirk with sequences
I noticed a weird quirk today with sequences, and wondered whether anyone else had seen it or knew if it was expected behavior. When running 'dbschema -d database_name -seq sequence_name', I get output similar to: create sequence "informix".my_test_sequence increment by 1 start w…
Manual Switch Primary , Secondary while RSS exist
Hi I have a client running IBM Informix 12.14 in RedHat 7.6. They have IDS Primary & IDs Secondary in HQ Data Centre while IDS RSS in DRC Data Centre. I didnt setup Control Manager. All this while I'm using manual via onmode command. I always refer Art Kagel document how to sw…
InformixHQ storing password to database servers
InformixHQ Server Version: 1.6.2 Build Timestamp: 2021-12-21T01:53:11-0600 From informix 14.10.fc7w1 install I have informix hq install on RH 8 server and setup to monitor with agents deployed. Everything working as expected. I have the monitoring and admin setup in HQ as informi…
varchar maximum length of 254 with an index
All, I learnt very early on in my Informix career that the maximum length of a varchar column is limited to 254 characters, instead of 255, if the column is indexed. This restriction is documented here: https://www.ibm.com/docs/en/informix-servers/14.10?topic=types-varcharmr-data…
Help to understand this sqexplain (now with plain)
Hello, here I am again, this time with sqexplain in the body message. I have this query that is taking many hours to run. I made a setexplain of it but I can't understand where the problem is. I believe I should create some table indices but I don't know which tables ------------…
Help to understand this sqexplain
| view attached Hello, I have this query that is taking many hours to run. I made a setexplain of it but I can't understand where the problem is. I believe I should create some table indices but I don't know which tables ------------------------------ Leandro Kohler -------------…
Set a default value with UPDATE trigger
Hello! I must be missing something obvious. Is there a simple way in Informix SPL/triggers to replace a value with an UPDATE FOR EACH ROW trigger? For example, to set a default value when the updated value is empty/NULL? I have tried this, but get a syntax error: CREATE TRIGGER t…
How to preserve whitespace at the end of a CHAR or VARCHAR
Dear colleagues: I am building a flat file or text file with 34 columns, each with a predefined format, and I find that the blank spaces in the last column do not appear. I have defined the 34 columns as CHAR with the length that corresponds to each one, and as I told you, the bl…
sql_begintxtime convertion
Hi, I am trying to use dbinfo to convert sql_begintxtime on syssqltrace and get wrong values. I am using the same process used for DBINFO('utc_to_datetime',sql_finishtime). I have done some research and found information about one procedure to do it, I have tested and get wrong v…
Question on sysprocedures
Informix 14.10.FC7W1 on RHEL 8.6 I've got a couple of questions about the sysprocedures table. First, the isproc column. It looks like isproc is set to 'f' any time the routine has return values, regardless of whether it was created via CREATE PROCEDURE or CREATE FUNCTION. I g…
IFX 14.10xc8 Updatable RSS and CPU Usage
Hello, In dev env. i've configured a pimary with 2 rss. there is no user activity and i see a high usage of CPU when a do a onstat -z followed by onstat -g smx i've notice a very high number at #scheds onstat -z; onstat -g cpu | grep smx IBM Informix Dynamic Server Version 14.10.…
Clear BUFFERPOOL
Hi, We are tuning some queries on Informix 14.10.FC8. Is there a command or a way to clear the BUFFERPOOL without restarting Informix? The first run of the query takes about 30 seconds though since the data is in memory subsequent runs of the query take less than a second. Than…
WAIUG Meeting Thursday July 14th
The WAIUG (Washington Area Informix User Group) is excited to bring the community a set of free virtual Informix technical talks with support of the IIUG. The event is on July 14th 2022 from 9:30am-1pm EDT. This free virtual meeting is open to anyone in the Informix community who…
Connect QRadar to Informix
Hello The QRadar doc says The IBM® Informix®® Audit DSM allows IBM QRadar® to integrate IBM Informix audit logs into QRadar for analysis. What is the IBM® Informix®® Audit DSM ? Maybe this https://www.ibm.com/support/pages/setting-ids-auditing-onaudit ? Thanks -------------------…
RSS setup question using disk clone technology
| view attached (2) HI, I want to setup Informix RSS instance using external backup technology (EMC srdf, snapshot and LVM technology), but before doing the external backup, I don't run "onmode -c block". When the rss node do the logical recovery, it report below errors and pan…
Informix RSS question
HI, the customer want to setup two RSS node, the primary have two network card, the hostname are host1 and host2; the hostname of the first rss instance is host3, the hostname of the second RSS instance is host4, host1 can ping host3 successful, host2 can ping host4 successful, b…
setup the two RSS instance
HI, I have one primary instance , and I want to setup two RSS instance, the primary have two network cards, and the hostname are host1 and host2,the hostname of the first RSS instance is host3, the hostname of the second RSS instance is host4, host1 can ping host3 successful, an…
Automating IBM Systems with Ansible Automation Platform Webinar
Summary It's been understated, but IBM has been very involved with Red Hat's Ansible Automation Platform. This webinar will look at how Ansible can be used to automate IBM Systems from the Mainframe to the IBM Spectrum Virtualize Please join us on Thursday, Jul 21st, 2022 at 1:00…
New RFE idea
Team: I have entered a new RFE: INFX-I-475 More efficient unique indexes for monotonically increasing keys and constraints If the idea seems useful to you, please vote for it. Art ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Managem…
.Net Core with IBM DB2 EF Core. Datetime format issue
When Im trying to update the database via context.savechanges() method I'm getting Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index') Exeception Following are the parameters passing for my query inside .Net call savechanges(…
AWS Snapshot and Informix IDS
We have a client that has just migrated their live Informix IDS 14.10 instance into AWS and they have automated the process of taking a snapshot using AWS API on this Linux server. We have provided them with scripts to block and unblock transactions but I have a query regarding w…
"Physical Logging while in Critical Section" in online log
I'm getting the message below in the online log, and I want to know in which case it occurs. Looking at the transaction log at that time with onlog, this message seems to occur at the time of truncate and chfree. It is currently suspected that truncate caused the message. Is this…
DIRECT_IO for Informix 14.10FC8
I see that with Informix 14.10FC8 we have a somewhat different onconfig explanation for the DIRECT_IO that what was used for Informix 12.10.FC10AEE: New: # DIRECT_IO - Set of flags that may be combined to control "special" I/O # 0x0 = Neither direct I/O nor concurrent I/O is used…
optimization question on EXISTS subquery
I was looking for sites to help explain the EXIST condition to someone, and found a page that explains it from a SQL Server perspective. The page mentioned something that makes perfect sense, but I've never seen it documented in the Informix world: The EXISTS operator returns TR…
"Data Not Available" in syssqltrace_hvar
Hive mind! I'm trying to trace errors in a session using syssqltrace, syssqltrace_iter and syssqltrace_hvar. But when I query syssqltrace_hvar, I always get this: sql_hvar_type unknown sql_hvar_data <Data Not Available> How can I fix this so that I see the actual data? I have the…
Latest Informix 14 versions
Am I correct in thinking that Informix 14.10.FC7W1 is the latest version of Informix for AIX and version 14.10.FC8 is the latest version for Linux? Also, if you have any insights on how stable these versions are, please share them. ------------------------------ John Dargan -----…
Odd -255 Errors
All: While tracking down another issue, I noticed several sessions reporting error -255 (Not In Transaction). These seemed out of place, because the sessions I saw showing that error were not doing COMMIT or ROLLBACK, which as far as I can tell should be the only statements that …
%Cached using onstat -p vs %Cached using onstat -g buf
I am on Informix 11.70, and I am grabbing metrics to record. One of them is the buffer write% for each server. When running onstat -p , it shows the %cached as 90.60 . However when actually calculating the %cached, it yields 80.20. The 80.20 value aligns with the value from onsta…
how to execute tspurgefunction for rolling container
so, i tried to load creates a control file named regular_purge.unl to delete elements from time series instances: but it return error 674: routine(getcontainername) cannot be resolved. UNLOAD TO 'regular_purge.unl' SELECT GetContainerName(para_id),InstanceId(para_id), GetIndex(pa…
Informix 14.10.FC8 on RHEL 8.6 installation - missing packages ?
Hello, In the doc i see - Red Hat Enterprise Linux ES release 8.0 (Kernel: 4.18.0-80, Glibc: 2.28-42). The following packages have to be installed: libaio-0.3.110 libgcc_s1-8.2.1 libstdc++6-8.2.1 ncurses-utils-6.1-7 pam-1.3.1-4 elfutils-libelf-0.174-6 When i try to install libgcc…
Non-Hashable Data Type
Informix 12.10.FC14 Solaris 10 1/13 I have a table with a smart blob column. (It is a photo.) I am interested in determining the total number of photos, and also the number of unique photos. To determine the total number of photos, I did the following: SELECT * FROM <table> WH…
Optimize AIX 7.2 on Power9/Power8 settings for Informix 12.10
Hello, I am looking for recommendation how to tune AIX 7.2 tunables on Power9/Power8 to run with Informix 12.10 (or 14.10. if recs for 12.10. are not available) for the best performance both AIX and Informix. There were some papers in the past, but not sure if still valid. Thanks…
syntax error on EXECUTE statement
IDS 14.10.FC7W1 on RHEL 8.5 I know I'm missing something simple. I'm preparing a statement early in a procedure, and then later trying to execute it, but I get a "-201 Syntax Error": LET p_sql_statement = "update user_roles_tbl " || " set user_roles = bitandnot(user_roles, ? )…
Problem with EXTERNAL TABLE
Informix 14.10.FC7W1, RHEL 8.5 (I think) I have a table invoice_tbl, and I want to unload some of the data from that table to an external table. The table has six rows that meet the selection criteria, but the resulting file contains only one row. I have the following SQL: SELEC…
Potentially Serious HDR Bug 14.10.FC7W1
All: I wanted to make you aware of something we've hit a couple of times and also find out if someone else has encountered it. Twice in the past few months, I've had DR Ping faliures on our HDR primary which seem to have left the cluster in an unstable state. It's as if the prima…
Next Informix Tech Talk: Updated Informix SQL Performance Tuning Tips for Informix Developers by Jeff Filippi
Next Informix Tech Talk: Updated Informix SQL Performance Tuning Tips for Informix Developers by Jeff Filippi Thursday, June 16, 2022 at Time: 2:00 PM EDT Learn how to improve your Informix SQL statements to optimize performance on your Informix Database system. Info at - https:/…
can I delete sysutils:bar_instance ?
select count(*) from sysutils:bar_instance 50000000 rows can I delete sysutils:bar_instance? or I used onsmsync -t "" to expire some backup ? ------------------------------ ZhiWei Cui GBASE ------------------------------ #Informix…
create table taby as select * from tabx PANIC informix server
| view attached On informix 12.10 and 14.10 can create table as select from. I used the informix demo DB to test. But when send two create table as select from two SQL at same request like below PANIC the informix server: create table itemxx as select * from items; create table c…
create table taby as select * from tabx PANIC informix server
On informix 12.10 and 14.10 can create table as select from. I used the informix demo DB to test. But when send two create table as select from two SQL at same request like below PANIC the informix server: create table itemxx as select * from items;create table custxx as select *…
restoring informix using the onbar command. problem
hello, i had both informix and tsm spaces on the same physical disk. this disk is broken. Using the files devices.cfg, volhistory, dsm.opt. I was able to restore TSM using the DB restore command. Next, I need to restore the informix spaces that were backed up once a week with onb…
How to enumerate tables referencing BLOBs in a particular sbspace?
Informix 12.10.FC14 Solaris 10 1/13 I have an Informix instance that contains several databases. Only one of these databases contains any BLOBs (smart large objects). There are 12 tables that contain, in total, over 650,000 BLOBs (mostly photos). I wanted to move all the sblob…
create function uisng foreach cursor from multiple table to return multiple row
Hi, i try to create SPL routine using foreach cursor from multiple table but it did not follow the parameter given during the execution. Anyone know how to fix this? CREATE FUNCTION neo_trend1(ParaId INT, startdate DATETIME YEAR TO FRACTION(5), enddate DATETIME YEAR TO FRACTION(5…
How to create function using foreach cursor from multiple table to return multiple row
Hi, anyone know how can i fix this? CREATE FUNCTION neo_trend1(ParaId INT, startdate DATETIME YEAR TO FRACTION(5), enddate DATETIME YEAR TO FRACTION(5), Code NVARCHAR(10)) RETURNING INT AS ParaId, DATETIME YEAR TO FRACTION(5) AS date, DECIMAL AS value, NVARCHAR(10) AS Code; DEFIN…
PSORT_DBTEMP not working after upgrade to 14.10
For some long time we were using script on Informix 11.7: #!/bin/ksh onmode -wm MAX_PDQPRIORITY=20 export PSORT_DBTEMP=/SORT export PSORT_NPROCS=4 dbaccess -e DB <<END execute function sort (); END onmode -wm MAX_PDQPRIORITY=1 After upgrade to 14.10FC7 sorting to filesystem is no…
Index rebuild?
I always thought index rebuilds on Informix weren't necessary but a recent investigation has made me question that. The incident involved a large number of sessions accessing the table via this index during a period of exceptionally high traffic. The sessions experienced buffer w…
sbspace defaults
Informix 12.10.FC14 Solaris 10 1/13 Q1 : When one uses onspaces -ch to change a default value (for example to turn logging off), does one need to include all the values that were originally set (in addition to the value one wishes to change)? That is, would specifying just the …
CPU VPs configuration on VMWARE
Hi folks, long time no see, I hope everybody doing well. I have a question: I have read and tested configuring more than one CPU VP per core on AIX Power VM, using SMT=2 or 1 at the system level. This works pretty well. I would like to know what is your opinion (with respective r…
Moving Smart Large Objects
Informix 12.10.FC14 Solaris 10 1/13 I want to move smart large objects from their current sbspace to a new sbspace. Working with BLOBS isn't always done the way one might, at first, think. I found this document: How to move a table's sblobs? Is it current and accurate? Will it …
Common Table Expression not giving right output
Does somebody knows why the following CTE does not work? In particular why SUBSTR(line, 1, 10) is giving me only one character and not ten? WITH t1 (line, mySplit) AS (SELECT "123456789 ASDFGHJKL 123456789 XCVBNMKLP ", "" UNION ALL SELECT SUBSTR(line, 11, LENGTH(line)-10), SUBSTR…
Secundary server - fast recovery mode
Hello, everyone. After an immediate shutdown of the servers and a subsequent startup, informix on the secondary server stopped working. Primary server is working, but the secondary server is on recovery mode. What should i do? Primary server: IBM Informix Dynamic Server Version 1…
Simple Large Objects and RSS
Informix 12.10.FC14 Solaris 10 1/13 Folks, We use RSS for a database for reliability-- in case of an unforeseen disaster at one location, we have a mirror copy of the database at another city in the state, about 700 miles away. We have a few older (legacy) tables that have in-ta…
Guardium
On ibm pages (https://www.ibm.com/products/ibm-guardium-data-protection/databases) Informix is not listed as officially supported. Since we did some guardium - informix installations years ago, I'm curious if this is official, or IBM forgot to list Informix (as usual)? Regards Hr…
SPL transactions
Could you please give me an example of how to properly manage transactions in an SPL? Thanks. ------------------------------ Antonio Ferrara ------------------------------ #Informix…
SPL was called by another SPL
is there a way to know if an SPL was called by another SPL? Thanks. ------------------------------ Antonio Ferrara ------------------------------ #Informix…
4GE 7.50 to 7.51.FC2
Does anyone know if you can upgrade the Informix 4GE to 7.50.FC6 to 7.51.FC2 just by installing the binaries there? I know HCL said we had to recompile to go to 7.51.FC3 because it was build with 4.50 CSDK, but 7.51.FC2 was built with 4.10 CSDK. -- Thanks, Kate Tomchik She/Her…
IBM data studio and SPL debug
I am new to the group, I apologize if I ask a question that may be trivial. I would like to know if it is possible to use IBM Data Studio to create and debug an informix SPL. If so, could you tell me where to find a tutorial to learn how to do it? Thanks. ------------------------…
Informix on a Windows Server
My boss asked me to research whether using Informix on a Windows Server is a good idea or not. Up until now we have used it with AIX and Linux machines. If anyone has an insight to share, please let me know. Thanks in advance. #Informix…
In-table Simple Large Objects
Informix 12.10.FC14 Solaris 10 1/13 I have in-table simple large objects (both TEXT and BYTE). I want to move them to a distinct blob space. I started with a small table that contains only a few TEXT objects. Here is excerpt from oncheck -pT: TBLspace Report for doc:wmoriart.c…
RFEs
Hello, everyone. I haven't seen much evidence that anyone at IBM actually pays attention to them, but I'm asking you to go review and (if appropriate) vote for the following RFEs, most of which I've just created: Mine: CM should log client IP and SLA on failures: https://ibm-data…
Need help about the cpu usage on the function spparse etc.
I have collected the tprof info on my test box (informix 12.10xc12 aix7.1) and find the function spparse,yield_processor_mvp,sq_cmd,mt_shm_malloc_segid use a lot of cpu as following: Question: how can I optimize the cpu usage ? could I set some parameters to enhance the performa…
New release of utils2_ak
Folks: I have uploaded an update to my utils2_ak package today. Here's what's new: May 3, 2022: dbcopy.ec: Changed Usage output to write to stdout to simplify piping to less/ more. Removed old debug trace. Added new -J option to alter the target table to TYPE(RAW) before the copy…
xC8 download
Hi, I see that 14.10.xC8 is available for download only on fixcentral (not on PA). But, I can't find any licence installation file there. Any hints? TY Regards Hrvoje ------------------------------ Hrvoje Zokovic ------------------------------ #Informix…
JDBC & TLS/SSL
Pardon the n00b-ish question, but I'm [thankfully] mostly Java and JDBC illiterate. Traditionally, we've connected to JDBC data sources by using something like the following: jdbc:informix-sqli://myhost.mydomain.com:9288/mydb:INFORMIXSERVER=my_ifxsvr This works for 'onsoctcp' ser…
Informix Roadshow Events - Central and Eastern Europe June 6-June 22, 2022
What is the Inform i x Roadshow? The 2022 Inform i x Roadshow is a one day deep-dive technical event that gives you hands-on experience with the latest IBM Inform i x release features and technology. This roadshow is designed to help you gain fresh, innovative ideas for optimizin…
archecker error with PSM
Hi, Level 0 and log backups are being made using psm on an AIX system for testing. I tried to recover the table with archecker using psm's backup, but I get an error as below. command) archecker -bdvs -f schemafile onbar backups or restores are performing fine. I also tried slibc…
New Informix Webinar from IBM!
This Thursday at 2PM EDT IBM will be presenting a new Webinar entitled "Informix - The Future is Now!" Register here: https://ibm.biz/BdPBWP ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------…
Need help to execute procedure. Having an error
I'm a informix newbies. Below is my table. Parent and child CREATE TABLE teststudent ( id serial NOT NULL, firstname varchar(100) NOT NULL, lastname varchar(100) NOT NULL, enrollmentdate date NOT NULL, PRIMARY KEY (id) ); CREATE TABLE teststudentdetail ( id serial NOT NULL, tests…
Stored Procedure with Commit and Rollback
Hi, I'm Informix Newbies. I want to insert into 2 table. Parent table & Child table I've table as following, CREATE TABLE teststudent ( id serial NOT NULL, firstname varchar(100) NOT NULL, lastname varchar(100) NOT NULL, enrollmentdate date NOT NULL, PRIMARY KEY (id) ); CREATE TA…
Insert Parent Table that have Id(Serial). Then this Id(Serial) being used in Child Table
Hi, I'm Informix Newbies. I want to insert into 2 table. Parent table & Child table I've table as following, CREATE TABLE teststudent ( id serial NOT NULL, firstname varchar(100) NOT NULL, lastname varchar(100) NOT NULL, enrollmentdate date NOT NULL, PRIMARY KEY (id) ); CREATE TA…
Manipulating binary18/binaryvar values
IDS 14.10.FC7W1 on RHEL 8.5 I did a search in the forum for 'binary18' and 'binaryvar', both returned "No results", so I may be out of luck, but here goes. I want to store data in a binary18 column. I created a varchar(38) variable that I used to create a string representation o…
Data Migration Guide : H2 Database in InformixHQ
See Blog post : https://community.ibm.com/community/user/hybriddatamanagement/blogs/linesh-deoraoji-gujarkar/2022/04/19/informixhq #Informix…
CDR_DBSPACE setup on existing ER environment
Hi, all. I already have a running ER without CDR_DBSPACE set. As per the documentation and technotes, the only way to set CDR_DBSPACE is setting it to desired dbspace, restart the engine, and create all the data replication definitions. My actual environment is very large so I wa…
after OS/Informix upgrade alarmprogram not backing up logical logs automagically
I'm testing the upgrade of our ERP server (OS & Informix) on our test/dev server and everything went well except the alarmprogram not doing logical log backups. And, I am puzzled by why is not working. prior to upgrade was SUSE Linux Enterprise Server 11 SP4 with Informix 12.10.…
Informix for Database Administrators Training
Are you ready to upgrade your skills for Informix 14.10? We have the training for you. I will be teaching our next Informix for Database Administrators class, on May 9-12, 2022 - Instructor lead online classes by Zoom - Four days of hands-on Informix Experience - Separate AWS Inf…
User defined data type
Hy We want to use user-defined types, but there are many different errors. 1) After we altered the tables from decimal(16,0) to pieceround_t datatype we have issue with a case/decode expressions. (-800 Corresponding data types must be compatible in CASE expression or DECODE func…
Issue with role
IDS 14.10.FC7W1 RHEL 8.5 We have two databases that are related, and are creating some roles and assigning permissions to those roles. The same role name will exist in both databases. The first database works just fine, the role gets created, permissions assigned, the role is a…
Issue with role
IDS 14.10.FC7W1 RHEL 8.5 We have two databases that are related, and are creating some roles and assigning permissions to those roles. The same role name will exist in both databases. The first database works just fine, the role gets created, permissions assigned, the role is a…
Error -404 When Running cdr realize template
This one's new to me. IDS 14.10.FC7W1: $ cdr realize templ tmplt_webmaint -S gprim__webdata -F webdata@gprim__webdata cdr error: Cannot close cursor - cdrcolcur SQL code -404 :The cursor or statement is not available. ISAM 0 : I've tried trapping error 404 but nothing gets fired.…
Facing some difference in size between 'onstat -d' , 'oncheck -ce' and 'syschunks' table values for 8k page size dbspaces and chunks
Hi, I have written a query to find Total, Used and Free Space in all chunks. All the columns in query are fetched from syschunks and sysdbspaces tables from sysmaster database. I know onstat -d will show Total and Free Space Details. But I would like to see Total, Used and Free S…
Migrate database from Solaris 10 to Solaris 11
Hello, Need some advice. I trying to find what is the best way to migrate the same version of Informix. We do have 2 different Solaris servers, the current one is Solaris 10 and the another ( new ) is with Solaris 11. Inormix server is running in the current one with Solaris 10, …
Multiple lines wtih "connection rejected" in online log when the instance is starting
Hi gurus, Is there any way to disable the huge amount of messages that is logged in online.log when the instance is starting ? I don't have control in applications that is atttempt to connect to the instance, so is not posible stopping these applications before the startup. Examp…
renaming a chunk file pathname
Hello, I have a chunk file that I want to move to a different directory. This is not the online_root file, just a different file that holds a few dbspaces. After doing some searching, I found a page on the IBM support site that says this can be achieved during a restore with 'on…
Recovery thread monitoring
Since the update to 14.10, we're having to scale back our recovery threads counts because of how much faster they are, and them ending up in ready state and setting off alerting. However, there appears to be no way to actually confirm how many threads are assigned other than read…
Installation with sudo online (RHEL8)
Hello friends, i have a customer, who only provides a system with a user which is allowed to use "sudo" it is RHEL8 x64 system. I have the problem, that the installer blames about: "Install libm.so.6, libc.so.6" files are there.. i tried to set LD_LIBRARY_PATH already to /usr/lib…
HDR server - heavy CPU load
Hello In a dev environment we have two ids servers in primary/hdr configuration. This environment has no load at all and I just noticed by chance that the HDR server uses a lot of resources. The IDS version is 14.10.FC4W1. I first stop and run again informix, but it does not help…
Buffer wait occurs when performing INSERT in multiple sessions
Hello All, In my customer's system, a buffer wait often occurs when an INSERT statement is performed on the same table in multiple sessions. In that case, there are about 1000 sessions with the first flag value of B in the onstat -u command. And the online log file shows the mess…
New DBA package
Folks: I've uploaded a new package to my web site ( My Utilities ) called scripts_ak. It contains a number of useful DBA scripts. Enjoy! Art ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------…
How to detect if table has old-fashioned attached indexes (index pages in non-fragmented table partition)
Hello, does any one knows, if there is a way how to detect tables with attached indexes (in old meaning – index pages are together with data pages in one partition). Curently system catalogs have such indexes, but we can configure such indexes for user tables via DEFAULT_ATTACH e…
IFX_ISOLATION_LEVEL 2 vs 3
Hello I d like to understand what are the differences between isolation level 2 and 3 Both of them are "equivalent to TRANSACTION_READ_COMMITTED " https://www.ibm.com/docs/en/informix-servers/14.10?topic=database-informix-environment-variables-informix-jdbc-driver Please, could s…
Performance Informix encryption
I wanted to ask you guys about your experience with performance degradation of enabled DB encryption in Informix. We have tables with 100 columns and 30 million records, does the activated inplace encryption of the Informix DB still play a big role or is it hardly measurable in t…
Upgrade Express Edition 12.10.FC5 to 12.10.FC15W1
Hello Informix Forum, I want ot upgrade our Express Edition from 12.10.FC5 to 12.10.FC15W1, as we occasionally get the server crashing, usually with a Linux "mutex" error (curiously a few hours after executing an ALTER TABLE command). On the IBM Fix Central it has fix packs for e…
Repack/Shrink With In-Table BYTE Columns
All: I have a couple of tables that have millions of records and each of which has one BYTE column stored in-table. I've deleted over a million records from each of them (probably accounting for about 35% of the total records in the table) and then did 'table repack shrink,' whic…
kernel: INFO: task oninit:1720 blocked for more than 120 seconds.
Anyone has experience/solution with this: Feb 14 14:28:46 dbpri kernel: INFO: task oninit:1720 blocked for more than 120 seconds. Feb 14 14:28:46 dbpri kernel: Not tainted 4.18.0-348.12.2.el8_5.x86_64 #1 Feb 14 14:28:46 dbpri kernel: "echo 0 > /proc/sys/kernel/hung_task_timeout…
Origina IBM Support
IDS'ers ... Does any have any experience using a company called "Origina" for IBM-related tech support? You can email me directly if you don't want to post here at mark@markscranton.com . Thanks in advance - Mark Scranton ------------------------------ Mark Scranton -------------…
unaccent where clause ...
Hello, i'm looking for a nice solution to make search "non case sensitive" and/or "non accent sensitive". Sample : name of user "éric" i'll find it in a where clause user like '%ERIC%' ... i know that we can create a "search column" parsed with a cleaned value but it's a global s…
Adjusting lru_min_dirty and lru_max_dirty when an instance is online
Hi, is there any way to effect a change to LRU min/max dirty while an instance is online? I am aware of AUTO_LRU_TUNING which does adjust these parameters. The behaviour of this when turned on is to set all pools to 50%/60% then adjust them as per the rules in the manual. Switchi…
Smartblob spaces
Hey all, We have a smart blob space that has reached 100% for a vendor package TWS. We don't know what is in this space. If this was a data space, we would repack and shrink. If it was an index space we would drop and rebuild some of the larger indexes. Is there anything lik…
Informix and BigQuery
Has anyone attempted to move/replicate data from IDS to Google BigQuery? Am VERY curious... Thanks in advance! Mark ------------------------------ Mark Scranton ------------------------------ #Informix…
Trusted remote servers - fail to connect without password
Hello, I try to establish a trusted connection between two servers without success. Server 1 - configuration $INFORMIXSERVER er1 Hostname ids-er1 IP 10.0.50.32 /etc/hosts 10.0.5…
where can I download informix 12.10FC7
I want to experience the advanced features of the AEE version There are only licensed installation packages here ------------------------------ ZhiWei Cui GBASE ------------------------------ #Informix…
RSS Logical Log Configuration?
Informix 12.10.FC14 Solaris 10 1/13 Currently using RSS with two identical machines (hardware and software). No problems. Don't have another machine to do a test, so figure why not ask here. When using RSS, do the primary and secondary need to have identical logical log config…
Enterprise replication can not sync data
when I create an replication，the data can sync;but wait one or two days，the replication will stop。 SERVER and replication status is oK. online.log: can not get replmap for replicate 2687022 CDR CDRDS:transaction abort（Error in retrieving the replicate's attributes） with SQL error…
err = -956 not trusted by the server.
Hello, We are receiving err -956 error when we connect from one informix instance to another. It is working for long time and suddenly this error started showing up. No changes are made in any files(/etc/hosts.equiv or sqlhosts) by Unix or DBA teams. We fixed the issue once by bo…
PAM/LDAP & Informix Authentication Methods
I have a client wanting to move off LDAP authentication (long story). Does PAM (pluggable authentication modules) require LDAP? OR - what other authentication methods can folks vouch for in an AIX environment other than LDAP? Does 14 bring anything new? Thanks in advance - Mark S…
Migrating workgroup to enterprise
Hi I just need a quick advise. The client running a instance using IBM INformix workgroup 12.10.FC6WE on RedHat Linux 7.5 VM. All instances are in cluster (Pri,Sec & Rss). With the new direction and new maintenance, they want to upgrade to Informix IBM Enterprise. My question, f…
weird and unexpected errors -908 on archecker
Hi Folks I am working with archecker with the option of table level restore, which has been working fine on my lab systems. I am now testing a script on my customer's staging system, with same ifmx version (14.10 FC4) which looks ok in terms of connections (dbaccess under the soc…
I Still Haven't Found What I'm Looking For
No, I'm not singing U2, I'm looking for csdk 4.50.fc7 for Linux x86_64 There's only 4.10 version. My old links are no more working. Yes, it exists, it is not legend - since I already download it: -rwxrwxrwx 1 257950844 257950209 203919360 stu 15 21:28 ibm.csdk.4.50.FC7.LNX.tar (s…
Informix rolling upgrade FC3 > FC7 - sysmaster issue
Hi, i tried today on our QA system to upgrade from FC3 to FC7 directly. It failed at rebuilding the "sysmaster" db. How to proceed in this way? ------------------------------ Marc Demhartner ------------------------------ #Informix…
IBM Informix 14.10.xC7W1 - Fixlist ?
Hi all, we want to upgrade from FC3 to FC7 - and now i see that there is 14.10.xC7W1 - anyone tried it already? Still nothing on the usual sites? Defects fix list for Informix Server v14.10 releases ------------------------------ Marc Demhartner ------------------------------ #In…
Memory issue on Informix primary server
Dear All, We have upgrade our Informix server from 11.7 to Version 14.10.FC6X3 on Sun OS 5.11. After that We are facing multiple memory segment issue on Primary server, but everything is normal on Secondary server. Before Upgrade there was only on Virtual memory segment. I have …
Replay available - Informix TechTalk
Folks, Replay available - Informix TechTalk: All about Informix data export and Import tools by Art S. Kagel on YouTube at https://youtu.be/6wF3eNwSU9w Informix TechTalk: All about Informix data export and Import tools by Art S. Kagel Informix TechTalk: All about Informix data ex…
Informix v.14.10.FC7 DeepDive replay now available
The replay of the IBM Informix v.14.10.FC7 Technical DeepDive, given at the German Informix Users Group is now available. You can get it on this site here (replay and presentation materials) or at the IIUG TechTalk YouTube channel here (replay only). Highlights include undocumen…
Can someone help me to connect Informix IDS with Spring Boot?
Dear colleagues: I am trying to connect an Informix IDS 7.31 TD9 engine in a project created with Spring Boot via JDBC, but I am not getting my goal. I first tried Maven's Informix dependencies, but they all give me the same error: "Connection refused". I note that when you creat…
low efficiency for cpu vp
Hello I see low efficiency for CPU VP for one of my production servers. I wonder what it does mean. 2 CPU VPs are sufficiently doing their job or more CPU VP is required. How does this number(Eff %) useful in calculating Instance performance? Although user is not complaining abo…
Solaris 11 , UFS or ZFS ?
Hi, My customer going to migrate from a Solaris 10 virual zone UFS-file system to Solaris 11, they use Informix 12.10.FC15. There is a suggustion to use the ZFS for the new machine, but Iam not sure what dose that mean for the database, I wonder if anybody know which one of those…
Only on temp dbspace is used
Hello Team on 12.1 server , i have many temp dbspaces , but got an error when one of them is full !! is there a way to fix it ? without increasing their sizes ? i also set PSORT_DBTEMP variable but nothing changed ! thanks in advance for your help ------------------------------ J…
session(s) taking the most cpu ressources
Hello please, is there a way to identify sessions that taking the most part of a CPU ressources ? regards ------------------------------ John Smith ------------------------------ #Informix…