Threads from 2021
Browse by month: Jan · Feb · Mar · Apr · May · Jun · Jul · Aug · Sep · Oct · Nov · Dec
Happy New Year
To All. I wish all of you all of the best in 2022. Have a Happy New Year in 2022. Scott Pickett IBM Informix WW Technical Sales IBM Expert Labs IBM Informix WW Cloud Technical Sales IBM Expert Labs IBM Informix WW Cloud Technical Sales ICIAE IBM Expert Labs IBM Informix WW Inform…
Informix 4GL Resources for Developers
Happy New Year! I taught an Informix 4GL for Developers course this month. I had fun doing that class and working with this superb language. I pulled together this list of 4GL Resources for the course based on articles I have written in the past. Here is my blog post on this. ht…
Update to utils2_ak
I posted an updated utils2_ak to my web site. It contains a critical fix to dostats_ng.ec and a couple of new features in dostats_ng.ec and in myschema. www.askdbmgt.com/my-utilities ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Mana…
Licensing Innovator-C edition
Is anyone on the forum using the Innovator-C Edition? If so, how did you obtain your entitlement jar file (ie_edition.jar)? I ask because it seems that no one at IBM knows. We have licenses for Workgroup Edition for our primary application, and have recently upgraded from an emb…
Technote on Log4j vulnerability in Informix
An official TechNote is now available on this issue. The full Security Bulletin will be published (with the same information) through the PSIRT channels shortly. Tech Note: Log4j Vulnerability ( CVE-2021-44228 ) in IBM Informix workaround Basically it affects the latest IHQ vers…
Linux Distributions
Hey, everyone. I just wanted to the Linux users among you as to which distribution(s) you're using to run Informix and how happy you are with them. Given the death of CentOS, I'm weighing alternatives. #Informix…
how can I find who block current transaction?
I have a transaction(insert into tab values (...）)。 mostly, this transaction so quickly in 30 ms. but the transaction used 10s occasionally。 how can I found which session or whic resource block this transaction ??? ------------------------------ David Cui Technical support gbas…
Questions about the CVE-2021-44228 vulnerability
Hello All, I have a question about a vulnerability related to Log4j. The document below is an update on the vulnerabilities of Log4j-related classes. https://www.ibm.com/blogs/psirt/an-update-on-the-apache-log4j-cve-2021-44228-vulnerability/ The files informixhq-agent.jar and inf…
Changing SMX_NUMPIPES setting
Running onmode -wf SMX_NUMPIPES throws an error. Informix version is 12.10.fc15. $ onmode -wf SMX_NUMPIPES=4 Configuration Parameter to be changed is not valid or not supported with this option. However, the documentation states that the wf option is possible. Is the documentatio…
Replay - Informix Tech Talks: Informix Benchmarks on Cloud Systems
Folks, Informix Tech Talks: Informix Benchmarks on Cloud Systems - Updated! by Lester Knutsen from December 9, 2021. Replay available at: Informix Tech Talks: Informix Benchmarks on Cloud Systems - Updated! by Lester Knutsen #informix #tech #databases #ibmchampion On YouTube - In…
index size
Hi, I am having some performance problems with last versions 12.10 and 14.10 over customers. From what I have seen over systems I don't find any problem over OS and informix, I suspect the latency is related to some modifications that my colleagues made over some tables and index…
Logicallog Backup Retention
Hi, i've set up a logical log backup with ids 14.10 fc7 (windows) like i did it with all versions before: onconfig: LTAPEDEV=PATH_TO_A_FOLDER alarmprogram: SET BACKUPLOGS=Y set BACKUP_CMD=ontape -a -d The llog backup is workin as expected, but old llog backups are not removed fro…
CSDK free site and the Developer Edition Free site
All, There have been a number of complaints, some privately made, some public here on the Community page, about access to the Informix free sites and the number of them (specifically 2 sites as opposed to one). This is in relation to the marketing and so forth that you encounter …
CSDK on MAC 12.10 architecture M1
Hi, Is there a chance to have the CSDK ported for MAC OS M1 processor ? Regards ------------------------------ Garcia Benjamin ------------------------------ #Informix…
Backup compression with windows
Hi, did anyone successfully use 7-zip or something else as BACKUP_FILTER and RESTORE_FILTER ? With the 14 years old windows port of gzip it's possible to use the filters, but the speed and the compression are realy bad compared to 7-zip. Thanks. Joe ------------------------------…
flags (onstat -g ses)
Hello i have some sessions with status "running" and flags "---P---" , not doing or waiting for anything, other sessions are on "---PR--" (reading) what does "---P---" mean please ? Thanks ------------------------------ John Smith ------------------------------ #Informix…
ER not propagating and no error messages
I'm using Informix IDS 10.00.UC6 on Solaris 11, with two machines having the same database schema and all tables replicating in both directions using Enterprise Replication, so in theory both databases should have the same content. However , a problem has arisen where one directi…
How to wait milliseconds within SPL?
Hello All, Is there a function in SPL that works similar to sleep? I used system ('sleep 5') , sysmaster:yieldn(), sysadmin:yieldn() functions, etc, but it doesn't seem to work in milisecond units. Because it is an AIX environment, usleep or nsleep cannot be used. Any ideas? drop…
Alzehiemers .....
Maybe I am just mis-remembering but I thought a tar/untar of 14.x engine would preserve the license entitlement ? Cheers Paul Paul Watson Oninit www.oninit.com Tel: +1 913 674 0360 Cell: +1 913 387 7529 Oninit® is a registered trademark of Oninit LLC Failure is not as frightening…
decimal type data input error (-1226)
Hello, The table has a column defined as decimal (7,1) . When I look up the table, there is a record in which the value -21474840 was entered. How is this possible? If I create a new table in the same instance and insert -21474840 , I get an error -1226. Any advice would be appre…
How many aio/KAIO
Hello All When using KAIO, what is recommended for vpclass CPU and AIO please ? Thanks ------------------------------ John Smith ------------------------------ #Informix…
Documentation errata
Is there a way to notify HCL of errata in the online documentation? Looking at the ESQL/C Guide, there is a section titled Enable the AUTOFREE feature . In that section, it says " For more information about the IFX_AUTOFREE environment variable, see the HCL Informix Guide to SQ…
14.10.FC7 Upgrade Issues/Warning
All: Just completed some development environment upgrades to 14.10.FC7 (from FC6) and hit on a couple of issues you should be aware of. First, as noted in other threads, the MIRROR parameter has been deprecated and the engine setting is now always on. So if you weren't previously…
14.10 - direct flooding "Network driver cannot accept a connection on the port"
Hi, i have a problem after reboot and informix start i see tons of flooding when informix starts up in online.log of: 12:12:54 listener-thread@soc_be.c :2701: err = -25573: oserr = 22: errstr = : Network driver cannot accept a connection on the port. System error = 22. 12:12:54 l…
Informix XA datasources in JBoss EAP 7 application server?
Is there anyone who have successfully configured XA datasources for Informix (14.10) in JBoss application server (EAP 7)? And who also have gotten it to work with an HA setup with multiple connection managers? I struggle a bit putting the pieces together here. -------------------…
InformixHQ Last Level 0 Backup Alert
Hi, how can i configure this alert correct? I want an alert is the backup is older than 2 days. In case of a 20 hours old backup i get following alert: InformixHQ Alert on xxx - Informix Backup to old: Last Level 0 Backup of 1 (1637089204,0) is greater than 2,0 Thanks. ----------…
InformixHQ Last Level 0 Backup Alert
Hi, what is the correct value for the alert? The Alert i got is this one: InformixHQ Alert on xxxx - Informix Backup to old: Last Level 0 Backup of 1 (1637089204,0) is greater than 2,0 I want an alert i my last level 0 backup is older than 2 days but it looks like 1637089204 is a…
question about Cleaner Parameter
Hello as recommandation, Cleaner parameter should be equal to number of chunks or number of disks ? Thanks ------------------------------ John Smith ------------------------------ #Informix…
CPU efficiency
Hello seen with onstat -g glo on a heavy OLTP server , CPU efficiency is about 40% ? do i need to change some parameters (VPCLASS CPU ...other ?) Thanks ------------------------------ John Smith ------------------------------ #Informix…
dbschema output
Informix 12.10.FC14 Solaris 10 1/13 Folks, The following SPL exists in an Informix database: CREATE PROCEDURE informix.is_pattern_arg(str1 varchar(255), options char(4000)) RETURNING INTEGER RETURN 1; END PROCEDURE; -- Permissions for routine "is_pattern_arg" grant execute on fu…
LRUs Writes / Chunk Writes
Hello Reading Onstat -F, there are LRUs writes more than Chunk writes should LRUs Writes be 0 or at least less than chunk writes ? Thanks :) ------------------------------ John Smith ------------------------------ #Informix…
14.10.xC7 is out now
Hi, just noticed... finally xC7 is out - includes a bugfix we found Fix list for Informix Server 14.10.xC7 release IT38221 Calling stored procedure twice throws error -9969: Corrupted collection type information Cheers ------------------------------ Marc Demhartner --------------…
buffers count is always the same
Hello to All using statement below on sysmaster, the number of buffers is always equal to those configured 'BUFFERPOOL', does it mean that i have to increase buffers ? SELECT COUNT(*) AS pages_used FROM sysbufhdr WHERE bufsize = 4096 AND bflags != 4; found here : https://www.ibm.…
dbschema
Informix 12.10.FC14 Solaris 10 1/13 I have used dbschema to generate individual text files for each SPL by rippling through sysprocedures and calling dbschema for each one. That works fine, so long as SPLs are not overloaded. When encountering overloaded SPLs, dbschema concatena…
Great!
If you visit www informix com - there is potential security risk Another IBM great job Hrvoje ------------------------------ Hrvoje Zokovic ------------------------------ #Informix…
What are the licensing considerations for InformixHQ?
Howdy! Wondering if anyone knows what are the licensing considerations for InformixHQ? I know people who are running 11.7, obviously no longer under support. with that in mind, and considering that HQ might work with 11.70, HQ could be extracted from, say, the IIUG development ed…
need a point of view :)
Hello All here is (onstat -p) output, i noticed buwfaits and (ixda-RA idx-RA da-RA logrec-RA RA-pgsused lchwaits) lines but need to know if i have to add buffers or do something on LRUs thanks in advance Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cach…
BTS(Basic Text Search) module install error
Is there anyone who can help me? ------------------------------ seong su kim ------------------------------ #Informix…
System Administration Certification exam 918 for IBM Informix Dynamic Server 11 prep
Hi, Does anyone still have the link to download this material? Or there is new one for latest release? I have been searching for it and cannot even get from IBM website. Thanks, Denny ------------------------------ denny guo ------------------------------ #Informix…
How to uninstall the Storage Optimization optional add-on feature on IDS 12.10?
Need to uninstall the Storage Optimization optional add-on feature on IDS 12.10, but I can't seem to find the documentation on how to do so any where in the IBM/HCL docs. Any one knows? Thanks in advance! ------------------------------ Ramon ------------------------------ #Inform…
Migrate Oracle database to Informix database
Hi, Please help to suggest any migration tools that support to migration oracle database to informix database. Currently we only prepared SQL script to unload from oracle database & load to informix database, but have issue with datatype clob/blob. Please advice. Thank You ------…
IDS 14 - SBLOB - IFX_ISOLATION_LEVEL and table locked
Hello We upgraded our development DB to IDS 14, and now we have a problem when we manipulate smart blob from the app. One of the tables with a smart blob field remains locked . The same app/code when connected to another DB server with the same connection string and with exactly …
14.1 WE - fastest way to load 61Mio lines CSV file
Hi all, i have a question about loading CSV files into informix. Currently we´re getting really huge CSV files from ERP systems (61Mio lines in 1 file) - and it takes hours to load it via dbload. How you would to it ? Base is Informix 14.10 Workgroup Edition with RHEL8 64bit ----…
DDL SPLs?
Solaris 10 1/13 Informix 12.10.FCI4 I received a request from a developer who wants me to send him a text file for every SPL in our system that contains any DDL. I am not aware of any automated way to extract such SPLs (such as some system catalog property that would reduce it t…
UDR improvement suggestions
In the following SQL: SELECT fname, lname, ssn from tab1 where lname like "%vijay%" AND ( telephonenumber IN ((123)456-7890 , ......, ....) OR homephone IN (+123 456-7890, ......, ....... ) OR mobile IN(123-456-7890, ....,.....,....) Custer wrote an UDR to take out all extra non…
Detect if we are inside a transaction
We have a library function that needs to run inside a transaction, so we would like to check if we are inside a transaction, and if not, start a transaction, do the work and commit. If there is a transaction already, we don't do anything. Currently we do a "begin work" and check …
New utils2_ak and myexport features!
Folks: I have uploaded new releases of my utils2_ak and myexport packages on my web site ( My Utilities ). Here are the highlights: Myschema adds a new option, --myexport-binary, that produces unload and load scripts that use EXTERNAL TABLES to unload data in INFORMIX binary form…
IIUG World 2021 Keynote by Arvind Krishna
View the Informix IIUG World 2021 Virtual Conference opening keynote by Arvind Krishna, Chairman and Chief Executive Officer of IBM on YouTube at https://lnkd.in/djZPa8BY ------------------------------ Lester Knutsen lester@advancedatatools.com Advanced DataTools Corporation Voic…
For archecker gurus: how do I restore a sequence using archecker ?
Hi Community, simple question today: in case a sequence has been dropped by mistake ( not me ;-) ) How do I recover a sequence from a backup without restoring the whole thing(instance) ? Can archecker do the trick ? I have seen that archecker handles tables, but what about sequen…
how to from informix sbspace
I create a sbspace and create a table with blob column。 blob column in sbspace。 insert many many rows. dbaccess dbname - > truncate table tabname; $ onstat -d I find sbspace's remain unchanged。 how can I free sbspace ？ ------------------------------ David Cui Technical support …
PDF documentation is available!!!
Great news!! The PDF documentation set for Informix v.14.10.FC6 is now available for download from the Library section of this community. The direct link is here! Thank you to HCL for producing this set and making it available to the Community. ------------------------------ Ca…
DBSERVERALIASES problematics with sqlhosts
Hi fellas, i have a question regarding Informix with Linux (RHEL7) and the usage of alias names for the informix server. For our developers we have a DEV system (e.g. olv16ffpdev) with Informix 14.10FC3WE We imported some databases from production there - so developers requested …
Informix on RHEL on VMWare - cooked vs. raw devices recommendation
Hello, I need some advice what is better solution for Informix 12.10 on RHEL 7 in VMWare VM - cooked file or raw devices? From performance point of view? Thanks a lot. ------------------------------ Milan Rafaj Infrastructure Architects and Specialists Team Leader Kyndryl +42073…
discrepancy in how Informix checks disk space
Informix 14.10.FC6, RHEL 8.4 on x86 hardware I ran into an interesting situation yesterday that revealed a troubling discrepancy in how Informix checks available space. I have two servers that are supposed to be identical, so that one can be used as a DR server. The DR server wi…
Informix with PHP performance
Hello to all, I am facing a very annoying dilemma. We have been using Informix for 25 years with 100% satisfaction on its robustness and performance with applications developed in Informix 4gl, delphi and 4js genero. We would like to use PHP/Symphony with PDO for 100% WEB applica…
Virtual segments on SDS server
Hello everyone. We are running 14.10 in SDS mode. Roughly 2 weeks ago a heavy update was performed on the primary which resulted in a lot of 9/29/2021 13:32:10 Dynamically allocated new virtual shared memory segment (size 134400KB) on the secondary (48 segments were allocated). T…
For IFMX and Tableau fans
Hi community, If you don't like Tableau or not interested in Tableau, you can skip this one My customer is a big fan of Tableau and does really cool things with (yes, Tableau is a masterpiece for BI). As some of you may know, the IFMX Tableau driver is not an official one but abo…
CDR RQM Error: `ctbufdata_inline` column missing for on-disk queue tables
Hello everyone! I have upgraded informix 14.10FC2 to 14.10FC6 successfully. But when I wanted to start ER with "cdr start" command , I got below error ": CDR RQM Error: `ctbufdata_inline` column missing for on-disk queue tables! Before starting ER, make sure that ER queus are emp…
Multiple Informix Session & 1525 Port
Hello, I think I know the answer but in case of I'm wrong ;-) If I run multiple instance of Informix Server [Same Version 14.10.FC3] on the same Linux Machine [Red Hat Enterprise Linux Server 7.9], is it mandatory to have for each instance a different port ? Are we not able to us…
Creating an Azure type Remote Key Store
https://www.ibm.com/docs/en/informix-servers/14.10?topic=utility-creating-azure-type-keystore ------------------------------ Apoorv Kapse ------------------------------ #Informix…
ODBC Limit or Excel Query Limit
Hello All, I have spent much time trying to learn the correct terminology to find an answer for my problem but I cannot seem to be able to do it. Here is what I am doing and what is happening. Hopefully someone can tell me why this happens and can clue me in on the right terminol…
VIEWs and WHERE statements
Hi Group, how does Informix execute a WHERE statement in a query on a VIEW? Suppose we have this view (syntax might be not 100% accurate) CREATE VIEW myview AS SELECT st.blah AS st_blah, st.whatever AS st_whatever, st.anotherthing AS st_anotherthing, at.thingy AS at_thingy, at.gr…
TIMEDATE field problem
Hi, I am trying to load values for one table with DATETIME field, even defining the DBDATE format the problem continues giving 1263 error... 1263: A field in a datetime or interval value is incorrect or an illegal operation specified on datetime field. my table create table bi_sp…
temp table performance issue on IDS 14.10FC3 EE
Hi We have an issue with creating temp table on Informix 14.10FC3 EE + Red Hat 7.9 . When we are running a big query than we hang on a IO wait issue. We configured the DIRECT_IO to 5 for the direct io function and we didn't gained any performance. What are we missing? IBM Informi…
idle session consuming lots of cpu time, but doing nothing apparently
Hi Folks I am trying to identify any global perf issue on a system where users suddenly complain about a drastical loss of performance "with apparently NO CHANGE done on the system". This is about a series of heavy load tasks that, according to customer's 'feeling', took around …
Index in Temp table
Dear All, I'm running below query to delete data. Using Index on Temp Table: CREATE TEMP TABLE temp2 (cust_numb INTEGER); CREATE INDEX "informix".temp2_n1 ON temp2(cust_numb) using btree; INSERT INTO temp2 select first 10000 cb.cust_numb from optim_cs_csdi cb WHERE EXISTS (SELECT…
Problems with temporary dbspaces
Dear colleagues: I come to you, because it is the first time that I have encountered this problem, which I have investigated a lot through documentation and I cannot find the solution. I have an Informix IDS 7.31 TD6 engine on Windows 10, which is mounted as a test, to be able to…
PDF documentation
Hi, Does anyone know about PDF version of the manual? If there is any intention from IBM/HCL to release or we will be forced to stay online to check the Informix documentation? I miss a lot the old and good PDFs library, mainly know were I focused to prepare our production to mig…
database object last access
Hello to All I need to know the date of last access for a table, index ..etc , i thought it was systables.ustlowts column but when i red the description it mentions when the last statistics were done. https://www.ibm.com/docs/en/informix-servers/12.10?topic=tables-systables than…
Linux Informix ODBC driver
So ... trying to find the CSDK for Linux that has the INFORMIX ODBC driver. The latest (or at least what I pulled down) for Linux has, get this, the db2 drivers (!). IBM/HCL confirmed that this is the case in the PMR I opened. But they haven't responded to my escalation - apparen…
Informix 14.1 : Change owner
Hi, used to export/import schema to change objects owner in previous version, is there a new way to do it on Informix 14.1 ? Thanks ------------------------------ John Smith ------------------------------ #Informix…
Index creation strategy when autolocate is set
Hello All, If autolocate is set to a value greater than 1, the table is created with a round-robin schema, but indexes cannot be created with a round-robin schema. I would like to know if there are any best practices on how to create indexes in a database that is set to autolocat…
ENCRYPT_AES/DECRYPT_CHAR
Here's an esoteric one for you. If I have a column that's been encrypted with ENCRYPT_AES, and I know the encryption key, is it possible to decrypt that value external to the database, i.e., without using DECRYPT_CHAR? We're hitting an apparent bug where a particular column won't…
for the sysmaster gurus
Hi Friends How to I emulate 'onstat -P' ( capital P ) with a sysmaster table ? I mainly want to know how many buffers used for table pages, btree pages and 'other' I bet I have to query sysbufhdr and work with hex(bflags) but I did not find documentation on those flags Or do I ne…
Shared Memory
Hello, Today I checked the Informix shared memory by onstat -g seg on Informix 14.10FC6X3 informix [rs-om-ifx-201] on_nebula21 $ onstat -g seg IBM Informix Dynamic Server Version 14.10.FC6X3 -- On-Line -- Up 16:43:49 -- 10327040 Kbytes 2021-09-03 15:36:42 Segment Summary: id …
sysmaster tables gone
Had an interesting situation ... IDS 12.10 engine had most of the sysmaster tables/views "disappear." This impacted a number of ops, including archives, etc. Some of the tables were there, so an engine bounce didn't attempt a recreate of the sysmaster database. Of course I recrea…
Tracing single session
Hi all. I'd like some assistance with the use of sql trace and dynamic explain. When I encounter a long-running session, I try to use "onmode -Y [sessionid] 1 /tmp/filename.sessionid" to get some more detail. Sometimes that works for me, sometimes I get nothing. When I get no out…
Connecting to Informix from Net5.IBM.Data.Db2
I can't get working the db2 provider with Informix. I keep getting this error: ERROR [08001] [IBM] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "172.…
4GL application performance over TCP / IP connections
Hello community, I have this situation: 1. We are migrating database and applications (4GL) from a power 7 to a power 9. 2. In the previous architecture (Power 7) the applications (4GL) were running on the same LPAR as the database. 3. In the new architecture it is proposed to se…
Calculate the ISO Week Number
Hello All, I'm trying to convert to week number (1-53) for a specific date. And I want to use ISO week. I looked at the post below, but it didn't help much. https://www.sqlservercentral.com/articles/a-simple-formula-to-calculate-the-iso-week-number I wrote a messy query like the …
InformixHQ repository
Hello, I see that we need to set up a repository https://youtu.be/xsylAz5U1sY?t=2612 But in the IBM doc I didn't find instructions for this https://www.ibm.com/docs/en/informix-servers/14.10?topic=administration-informixhq-guide Also, Is it preferable to set a a light server just…
SQL Time
I'm running below query with set explain on. QUERY: (OPTIMIZATION TIMESTAMP: 08-12-2021 18:44:05) ------ select count(*) from cs_subr_pcn_00 cb WHERE EXISTS (SELECT cl.cust_numb , cl.subr_numb from cs_cust cs, cs_clse_cust cl WHERE cs.cust_numb = cl.cust_numb AND cl.cust_numb =…
Extent size and data forecast
Hello everyone, Please tell me the simple formula for calculating the INITIALI and NEXT extent size for below criteria. TABLE "informix".cs_cust row size = 758 number of columns = 50 index size = 331 If customer says table growth rate 100000 rows per month. We have 2 GB chunk siz…
.Net Provider connecting to MS SQL Server
Folks, Unfortunately, we need to migrate from Informix (12.10.FC14) to MS SQL Server. One of our developers is doing some very preliminary experiments. We opened a tech support case to get assistance with acquiring and setting up a .Net Provider. We are working with a very helpf…
HQ install
Hello, Based on https://www.ibm.com/docs/en/informix-servers/14.10?topic=started-starting-informixhq-server I try to install HQ Java is installed, and when I run this command : java -jar informixhq-server.jar informixhq-server.properties The command hangs without any output. A h2…
DB connection
Dears, I need to write few SQL statement which where I can use temp table in joins. But it is giving syntax error. As I know Unix command can not be run under informix session. Is there any other way to do it? Table names are in loop, so can't use hard coded. CNT1="SELECT COUNT(…
Rubrik Anyone
I hope I am not breaking any IBM rule asking this question but we are evaluating Rubrik as a replacement for TSM. I would appreciate any insight from anyone involved in that process. From what I saw, I am not sure it is the right tool for Informix yet or even for DB2. Thanks Walt…
Possible CM / CSDK 4.50.FC6 / SSL Issue
FYI: I recently updated a couple of our connection managers from 4.50.FC5 to 4.50.FC6 (CentOS 7). After doing so, I started periodically seeing these errors: 00:22:06 listener accept new fd failed:network error = -28014 cannot accept Eventually (typically after about 3-5 days of …
Informix Client CSDK Parameters
Hi All, I am trying to improve network performance between client server comunication. I am not finding documentation about Parameters on Infomix Client CSDK to try improve this comunication ? (like parameters to improve TCPIP Buffers, etc...).. now 2/3 of time is spending in …
14.10 user/connection limits?
Planning to upgrade a set of 11.70 databases to 14.10. Need to know more about how users/connections are counted/limited for the various editions. Seems to be 25 max. Installed the 14.10.C5 version on Windows Server 2012. Didn't run the version installer, so by default, develo…
Informix NoSQL syntax in SQL + UDR way / Not mongoDB way
Hi all, I am at the moment testing using NoSQL data in some tables ( stored as BSON), thru the use of ESQ/C or 4GL language All good when I read data from the table, that is LET qry_stmt = "SELECT acct_code,desc_text,start_year_num,start_period_num,end_year_num,end_period_num,gro…
Backup from secondary server
Hello, Is it possible to run a backup (ontape/onbar) on a secondary server in a HDR configuration ? Thanks Samuel. ------------------------------ Sh To ------------------------------ #Informix…
Informix 14 - ALTER JOIN -
INFORMIX OUTER JOIN - We upgrade server to Version 14.10 FC5 , we are facing a performance issues in queries who uses OUTER JOIN . Comparing in the same machine / same configuration, between verions 12.10 FC14 and 14.10 FC5, queries who uses OUTER join are 4 times slower, other…
IBM Informix v.14.10.xC6 Deep Dive replay #2 is now available
Just a quick note to let you know the full replay of part 2 of the Informix v.14.10.xC6 Technical Deep Dive is now available at this URL . I hope you find the content worthwhile. Carlton ------------------------------ Carlton Doe ------------------------------ #Informix…
ontape does not finish the backup: tape full
Hi all, We have a cron job running at 22:00 hrs to backup our database. I have no clue why ontape is aborting. I hope I have entered enough info below. The resulting bzip compressed file is 240G one day, 253G the next, so it is aborting on different sizes and also after different…
Silly question on HDR setup
Hi Everyone, Can we use the whole system backup (onbar -b-w) from Primary to do physical restore of HDR secondary instead of the standard level 0 backup (onbar -b -L 0). ------------------------------ Thanks & Regards Vijayanand Dhandapani. ------------------------------ #Inform…
Utils2_ak_myschema_compiling_AIX
Hello everybody, Download the latest version of utils2_ak and compile it into: AIX 7.1 bash-5.0 $ esql -V IBM Informix CSDK Version 4.10, IBM Informix-ESQL Version 4.10.FC14 Software Serial Number AAA # B000000 bash-5.0 $ xlc -qversion IBM XL C / C ++ for AIX, V12.1 (5765-J02, 57…
Informix SSL and Websphere
We all know that Informix works with SSL but for some reason IBM Websphere support guys think Informix doesnt't support SSL, even supplied a link on Google that stated it so it must be true. I have provided them with java test harnesses proving all is good via SSL, CM with SSL an…
Upgrade IDS 12 to 14 – JVP abort
Hello, I just tried to upgrade IDS 12 to 14 and I got this on online.log 15:22:17 The C Language Module </IDS/informix/extend/krakatoa/lmjava.so> loaded 15:22:17 Loading Module <java_security:SecurityUtil> 15:22:17 Got the mutex 15:22:17 LD_LIBRARY_PATH=/IDS/informix/extend/k…
Informix Dynamic Server 14 - How to list users with DBSECADM role
There are no results from SELECT * FROM sysroleauth, or SELECT * FROM syssurrogates or SELECT * FROM sysusers after granting user DBSECADM. Any one knows how to get the list of users with this Database Security Administrator (DBSECADM) role? Thanks ------------------------------ …
What is an esql++ file?
Hello All, My client is planning to change the machine of the Informix server and client from AIX to RedHat Linux. However, there is an esql++ file in the $INFORMIXDIR/bin directory of the old client, but it doesn't seem to exist in the latest version. Does anyone know about this…
ER CDR SYNC: cdr sync does not start due to some locks in the to be replicated table: any way to set some dirty read sync ?
Hi all I am despererately trying to cdr sync a few tables from one instance to another. Most of replicates work fine, but a few of them have some locks in the table, that prevent the initial "select count(*) from table" statement fired by cdr sync to run successfully, therefore c…
dbaccess select, tabular output
Hello, dbaccess presents select query output as a "table", one row per line, if the line is less than 80 chars, and switches to one column per line when greater than 80 chars. It does this in a linux terminal regardless of the width being well over 80 chars. This is very frustr…
Finding the CSDK v4.50.xC6
Folks: It looks like IBM messed up again. If you are looking to download the latest CSDK (v 4.50.xC6) you will not find it on the CSDK download page. It was mistakenly put on the Informix Engine Developer Edition download page. All earlier releases of the CSDK are on the CSDK dow…
How many CPU do i need ?
Hello to All Question : How can i determine how many CPU cores do i need on a Server ? I Have 2 CPU used (dedicated + uncapped mode) on a 4 CPU pool, and Informix sometimes uses more than the 2 CPU , (3,5) can i configure informix to use only the 2 CPUs, or should i increase the…
How to configure informix to store TPS on logfile (without query on sysmaster)
Hi I want to monitor Transaction Per Second of informix database. and need to write TPS on log file after that monitor that file. How configure informix to store TPS on log file (without query on sysmaster)? Thanks ------------------------------ Indeed_1 ------------------------…
how increase log space (12204: RSAM error: Long transaction detected)
Hello, our software supplier asked us to run a SQL script that came with a software upgrade. The script copies a fairly large table to a temp table with an extra field, then drops the original table and renames the temp table to the original table. Somewhere during the operation …
LIMIT DELETE ROWS
Hello All, Can we Limit the Delete Records in Informix? Or Is it possible to set number of record deletion per Commit? Thanks Amit Patel ------------------------------ AMIT PATEL ------------------------------ #Informix…
Setting "HOME" directory for client when using SYSTEM command
Greetings, Encountering an interesting issue. Server is: 12.10.FC12 When invoking an SPL procedure from a remote client which calls the routine: create procedure system_test() system 'echo "Hello"'; end procedure; I get the following error: SQL error = -668 ISAM error = 0 error s…
Curiosity Question
Hello, Is Informix MaxConnect EOL? And if so why was this product discontinued? I am asking this question in order to think about a strategy for client connectivity to servers. Is it still necessary to keep connections always active on the client side or is the overhead that a "c…
Informix Tech Talks: History of the Informix User Groups - Part 1 and 2
Folks, The replays are available at and on YouTube: https://www.iiug.org/en/2021/06/24/informix-tech-talks-history-of-the-informix-user-groups/ Informix Tech Talks: History of the Informix User Groups - Part 1 and 2 by Carlton Doe, Walt Hultgren, Cathy Kipp, Lester Knutsen, and M…
Client SDK Download
Why do IBM and HCL keep hiding the CSDK download? It used to be less of a big deal because it was bundled with the engine. Now it no longer is, and the only stuff available on Passport Advantage is 4.10 and older or the Windows versions of 4.50. When I try to download via the iiu…
Groups and IDS 14.10.xC6
A word of warning for a lesson learned the hard way. When setting up groups in sqlhosts, you need to define a group ID. There's a poorly-documented (or perhaps undocumented) requirement that the Group ID used in the i= parameter must be a number between 1 and 32767. I don't recal…
SSL Listener not getting started in Solaris 10 and Informix 11.5 Combination.
Hi All, Back to informix world after about 2.5 years IMPORTANT NOTE - I understand the version is outdated and there will be suggestions to upgrade Informix version. FYI, I just joined this new company two weeks back and don't have any say on the versions at this point although …
IBM Informix v.14.10.xC6 Deep Dive replay #1 available
The replay of yesterday's IIUG sponsored Deep Dive into the xC6 fixpack is available here . It covers enhancements to ER as well as new kernel and SQL features and functionality. The second Deep Dive, covering IHQ and backup from a RS secondary node, originally scheduled for June…
Informix Windows issue: ERROR: Could not initialize the security subsystem.
Windows 10 default installation + updates, IDS 14.10.FC6DE (tested with IE, WE, Ent, Exp) Figure #1 My user Hrvoje is member of Administrators and Informix-Admin Registry has HLM\\Software\\Informix\\Online\\%INFORMIXSERVER%\\Security including "IXDBSA Group" -> Informix-Admin Wh…
Get ipcshm buf_wait semop errno=43 on Restore
Hello, (Testing/learning purpose.) Briefly, I have one server IDS 14.10 with demodb database And another server with identical disk definition and IDS 14.10 installed. I made an ontape -s -L 0 on the first server Got an archive of 39MB I copied the archive file to the second serv…
Informix v.14.10.xC6 overview replay is now available
It is in the Library / Webcast replays section. I think this direct link should work. Many thanks to JC Lengyel for the session as well as all the developers who worked on this fix pack. Carlton ------------------------------ Carlton Doe ------------------------------ #Informix…
Unload over writes existing files
Got tired of unload files being overwritten by mistake - https://ibm-data-and-ai.ideas.aha.io/ideas/INFX-I-412 Cheers Paul Paul Watson Oninit www.oninit.com Tel: +1 913 674 0360 Cell: +1 913 387 7529 Oninit® is a registered trademark of Oninit LLC Failure is not as frightening as…
No link to todays Latest enhancements in IBM Informix 14.10xC6 Webcast
Hello all, I was wondering if any one has any way to communicate with Cindy Lichtenauer, and let her know that her invite to the Latest enhancements in IBM Informix 14.10xC6 Webcast has no links in it. Same for the upcoming kernel, ER and SQL features, and IHQ and Backup from R…
Fragmentation issues
Hi, I frequently see fragmentation in tables and indexes, even though I have activated the auto_crsd task there is still fragmentation. Are there any other tasks needed? How can I get the size of tables and indexes, including fragments? Thanks in advance for any help, SP --------…
multiple table Data deletion
Hello All, I have to delete data from multiple table (around 300) , kindly suggest what precaution should I take while data deletion that Process should not get aborted due to LOCK or LOG and LONG TRANSCTION. ( Working on IDS 11.70 ). There are separate queries , All 300 tables h…
How to check autolocate settings ?
Hello All, After setting AUTOLOCATE of onconfig to 3 as shown below, I set the location of the database using the administration API. The table seems to be successfully created in the specified dbspaces, but sysmaster:sysautolocate does not show the specified dbspace list. Is thi…
Cannot perform this operation on a table defined for replication
On our system we have certain tables in one of our main databases that are associated with "data capture" and full-row logging (a.k.a., "log snooping"). The "cdc_set_fullrowlogging" command can be used to either enable full-row logging or disable full-row logging. My experience h…
Distributed query on databases with differents DB_LOCALE ...
Hi, Actually we can't not mix databases created with differents "DB_LOCALE" (error -23197) ... What's the best strategy/advice for working (e.g. : synchronize process, ...) with mixed databases because we want to create an UTF8 database for "web purpose" with "unicode support" b…
AUTO INCREMENT Value
Hello All, I'm working on Informix 11.70. I have created an sequence and for incremented value I'm using (Sequence_name.nextval) every time. But is possible in Informix that if I enter '0' or NULL then also field value should increment automatically by 1 or any integer value. Kin…
A bit more clarity on LEVEL 1 backups
Hi, maybe a dumb question, but I just want to know for sure. In the documentation I read that a LEVEL 1 backup contains all data that has changed since the last LEVEL 0 backup. So this would mean that I make a LEVEL 0 on Sunday I make a LEVEL 1 on Monday evening I make a LEVEL 1 …
RESTORE_POINT_DIR - Size
Hello https://www.ibm.com/docs/en/informix-servers/14.10?topic=pm-configuring-recovery-restore-point-data-in-case-upgrade-fails I have the default configuration CONVERSION_GUARD 2 RESTORE_POINT_DIR $INFORMIXDIR/tmp Now how I can evaluate the space needed to store the restore poin…
AUS status
Hello, I slowly prepare the steps to upgrade. And I see that the "update statistic" is an important one, after the upgrade. The problem is, I inherited the database without really knowing what it is !! : ) or even what was going on in it. It seems to me that the AUS is "running":…
Database Migration
Ifmx 12.10.FC14 Solaris 10 1/13 The management at my organization has decided that Informix is not to be in our future. We will be migrating from Informix on Solaris on SPARC to MS SQL Server on Windows. We will likely be using a contractor for this operation, but I am also inve…
Next Informix Tech Talks: History of the Informix User Groups
Next Informix Tech Talks: History of the Informix User Groups - Part 1 by Carlton Doe, Walt Hultgren, Cathy Kipp, Lester Knutsen and Mike Reetz Thursday, Jun 24, 2021 2:00 pm EDT We will share stores about how the Informix User Groups got started in the early 90's. Does anyone el…
CSDK
Ifmx 12.10.FC14 Solaris 10 1/13 Our developers work in Java. I do DBA and sysadmin work on our Solaris/SPARC systems. The point is I haven't done much with Windows. I have a developer now who needs to use dbaccess from his WIndows 10 machine. So, I need to install a Windows CSDK…
oncheck -cDI >>> inconsistency warning
Hello, In an oncheck before upgrade that i took from here https://youtu.be/xsylAz5U1sY?t=1374 oncheck -cDI devdb https://www.ibm.com/docs/en/informix-servers/12.10?topic=utility-oncheck-cd-oncheck-cd-commands-check-pages https://www.ibm.com/docs/en/informix-servers/12.10?topic=ut…
How to check currently working onmode -I option?
Hello All, The onmode -I 243 command was executed to collect the lock error information of customer Informix. My question here is, is there any way to check if the onmode -I command is currently working or what error code it is running for? (not by checking the messages displayed…
How can I create stored procedures from c# code that uses .NET provider?
Hi all: Through the .NET provider, my c# program can successfully create tables, constraints, and indices. But whenever I try to create a stored procedure, I get error 42000 'A syntax error occurred'. However, if I copy and paste the text assigned to the .CommandText property, in…
Modeling "Overrides"
Let me start by saying that logical modeling has never been my strong suit. I've always been more of a physical infrastructure / back-end kind of guy. So I want to ask the peanut gallery how to solve a problem. What's the best way to model overrides in the database? You're probab…
With IDS 14.10.FC5 ALTER TABLE of VARCHAR truncates trailing blanks
Hello! With IDS 14.10.FC5 (no problem with IDS-12.10.FC9IE): When changing the size of a VARCHAR column with ALTER TABLE, trailing spaces are removed. While CHAR columns are blank-padded, to me trailing blanks in VARCHAR columns are part of the value, even if they are not signifi…
Compression with fragmented tables
Hi everyone, we're using Informix 14.10.FC5. I need to fragment a table in let's say one 30G dbspace a week (7 millions records/ week) for easier data rotation (detach full fragment, attach empty fragment strategy). Btree indexes are of course attached. In order so save some spac…
Blocking Checkpoint?
Ifmx 12.10.FC14 Solaris 10 1/13 What does it mean when a checkpoint shows "# Waits" = 1, but "Block Time", "Ckpt Time", "Wait Time", "Long Time" are all zero? Critical Sections Physical Log Logical Log Clock …
Network encryption using GSSCSM and Informix
Hi group has anybody experience with using informix network encryption I successfully implemented encryption using GSSCSM and the default cypher arcfour-hmac concsm.config on server GSSCSM("/informix/lib/csm/libixgss.so", "","c=1,i=1") Concsm.config on client GSSCSM("C:\\Program …
Best reorganization ever in smartblobspaces
Hello community!!. I have a table with a blob column stored in one smartblobspace which is growing hugely, I would like to know the best way to reorganize it trough several smartblobspaces. I know that MODIFY column with ALTER TABLE will be done, only to new records. Please tell …
Long Running Query thru shell Script
Hello All, I need to write a shell script to find long running Query in Informix 11.70 . (We will upgrade with 14.10 in August 2021). As it includes three main steps 1. Search onstat -g act -g -x (x= 1, 2, 3, 4, ....) 2. Check tcb column with Non ZERO value and run onstat -u | g…
Informix Tech Talks today; Informix Large Table Operations by Ben Thompson
We have another exciting Informix Tech Talks today; Informix Large Table Operations by Ben Thompson. The replay is on our YouTube Channel at: https://youtu.be/Tq91-Hv6KUI ------------------------------ Lester Knutsen lester@advancedatatools.com Advanced DataTools Corporation Voic…
Onconfig file converter
One of the most time-consuming part (for me) of planning upgrades, especially major upgrades, is creating a new onconfig file. I never just drop the old file into the new directory because there can be other onconfig changes specific to the new version, and doing that doesn't nec…
Next Informix Tech Talks: Informix Large Table Operations by Ben Thompson 5/272021
We have another exciting Informix Tech Talks: Informix Large Table Operations by Ben Thompson on Thursday. Please join us and register at Informix Tech Talks by the IIUG Description: Many databases are getting larger as systems mature and organizations put more value on data. Si…
Documentation - Upgrade from IDS 12 to 14 in primary/HDR/RSS configuration
Hello, I looked for information about upgrading primary/hdr/rss from IDS12 to 14 But I only found for IDS11 https://www.ibm.com/support/pages/upgrading-high-availability-data-replication-hdr-pair Do I have to go through the same steps for 12 to 14? Also, Step 4: I could understan…
EOS Date
Hello All, I was searching for the Informix 10.00 FC10W2 End Of Support date. Not getting any information in google. If someone has any information , kindly let me know. Thanks Amit Patel ------------------------------ AMIT PATEL ------------------------------ #Informix…
Unload count discrepancy vs what Informix says is in the database
I have a very large table with over 265 million rows. When I unload the table, it reports a number unloaded. When I run a wc against the unload file, I get 140 more rows in the file than the database says it unloaded and reports as in the table from multiple sources. This is 11.…
IDS 14.xC5 and SQL_DEF_CTRL onconfig parameter issue
Hello, We plan to upgrade from 12.10 to 14.10 On test servers with primary/hdr/rss configuration we got this message (flag with value 0x400000 of the SQL_DEF_CTRL onconfig parameter). Please ensure that this feature is also enabled on the connected primary server, otherwise the s…
CDC through connection managers
Hi! We have recently tested a product called QDI (or Qlik Replicate) from Qlik for consuming log data from an Informix instance through CDC. When making a direct connection to on specific server this works without issues (apart from some limitations in Informix CDC). However, sin…
Next Informix Tech Talks: Informix Large Table Operations by Ben Thompson
Friends, Please join us for another exciting Informix Tech Talks Next Week. This one is Informix Large Table Operations by Ben Thompson on 5/272021 Description: Many databases are getting larger as systems mature and organizations put more value on data. Size can present challen…
ERROR 216 - 101 when enabling indexes
Hi, i am reloading tables in a database without logs. database is not compressed. For load i am using external tables then 'insert into table select * from external_table' working on AIX 7.2 with raw devices. The script uses dbaccess on the same machine than informix server. Prob…
DBACCESS - Comand not found
Dears, cbasys@rs-om-btch-201:~$ RS-OM-BTCH-201^C cbasys@rs-om-btch-201:~$ su - rpa_omdb_test Password: Authorized users only. All activity may be monitored and reported. mesg: cannot change mode rpa_omdb_test@rs-om-btch-201:~$ dbaccess oltp@test_ne51 -bash: dbaccess: command not …
Updates to myschema and myexport
Folks: For a long time I have wanted to change how the -O (dependence ordering) works in myexport. Originally it used myschema --dependency-order which guarantees that parent tables are unloaded and loaded before their dependent tables. This option avoids inconsistencies caused b…
dbexport alternative
Hi, I need to clone informix databases with some frequence, I know there is dbexport but it implies to have no connections. I would like to have some way to do it without downtime. I have tryed to clone with some old scripts I have, but I facing one problem with referencing const…
Informix SQL types to OpenAPI data types
Hello! I want to learn best practices about SQL data type to Swagger/OpenAPI data type mapping. I am looking for a REST API solution to access Informix SQL databases/tables (no JSON/MongoDB). Is there an equivalent of https://postgrest.org (PostgREST) tool with Informix IDS 14 ? …
-157 ISAM error: Interrupted ISAM call
Hello everyone, In a scheduling process done by one of the applications that connect to our Informix instance, we had many errors with the following message: "ERROR [IX000] [IBM][IDS/UNIX64] Statement interrupted by user. (-157 ISAM error: Interrupted ISAM call) -157 ISAM error: …
Querix Lycia - "Transform Informix 4GL"
Has anyone had experience with Querix for transforming an older 4GL application into a more modern-looking one? https://querix.com/ I scrolled to the bottom of this home page and saw a picture of Art Kagel with a positive comment about the product. They also show icons for variou…
14.10 on Centos 8
Any info about supporting Centos 8 (IBM product) for Informix 14.10 (IBM product) in the future? I know it is working but when you get this from support: "Did you check the system requirements? https://www.ibm.com/support/knowledgecenter/SSGU8G_14.1.0/com.ibm.relnotes.doc/idsfmx/…
New utils2_ak features!
Folks, I have uploaded an update to utils2_ak that includes new features in myschema to support new myexport features similar to recent improvements to dbexport. I will shortly release an update to the myexport package that includes direct support for these. In the meantime, you …
Question about connection manager feature
Hello All, I have a question about the connection manager feature. Is it possible to failover to a cold standby server using informix connection manager instead of using cluster software like pacemaker or PowerHA? ------------------------------ SangGyu Jeong Software Engineer Inf…
One comment about linux installation
I can't find that in installation guide but - when installing you can't have these mount flags on /tmp: nosuid,nodev,noexec Even if you try to "move" tmp with IATEMPDIR env variable, installation is still using /tmp, i.e.: Native API library will be stored as '/tmp/ismp006/libnat…
SDK Client on Oracle Linux
Hello experts, good evening I request your support to find out if there is an informix SDK client for the Oracle Linux Server platform version 6.10 (Linux onpb 4.1.12-124.24.5.el6uek.x86_64 # 2 SMP Wed Jan 30 13:24:08 PST 2019 x86_64 x86_64 x86_64 GNU/) I have validated at this l…
Warning in log file
We just upgraded a system from 11.70 to 14.10 Informix on Redhat 7. We are getting a new warning in the log file: 10:56:17 Warning: update statistics low using sampling may generate inaccurate index statistics for index informix.x0prv08u due to data skew 10:56:41 Warning: upda…
from SETs to Regular tables
I want to convert the following table: 1 SET{10,11} SET{20,21} 2 SET{15} SET{30,31} . . . into this: 1 10 r 1 11 r 1 20 a 1 21 a 2 15 r 2 30 a 2 31 a . . . WITH ttt (sq, rejectedPinSet, acceptedPinSet) AS (SELECT 1, SET{10,11}, SET{20,21} UNION ALL SELECT 2, SET{15}, SET{30,31} )…
Performance of 14.10.FC5 is worse compared to 12.10 is that possible?
| view attached Hi erveryone, i try to migrate from an Windows Server 2016 Informix 12.10 installation to an Ubuntu 20.04 LTS with Informix 14.10.FC5. Both servers run in an virtual machine on the same host. Both servers have configured 2 cores, the older Windows Server has only …
ontape -l show 100% full logs but ontape -a doesn't flush them
Hello, IBM Informix Dynamic Server Version 12.10.FC5 When I issue "onstat -l", I get: Physical Logging Buffer bufused bufsize numpages numwrits pages/io P-2 43 256 53 1 53.00 phybegin physize phypos phyused %used 2:53 …
Asking for a real IDS Tableau driver
For those who know Tableau, you will agree that it is a great product with great features. For those who don't, it's a great product for BI reports and more. Unfortunately, IDS is not part of the supported drivers for Tableau, making that some functionality just do not work with …
Could I force drop the database?
Hello All, I would like to ask for advice on Informix error message. A specific database of the instance has fallen into an inaccessible state. Below is the result of running the oncheck -cc command and dbaccess. Fortunately, it is an unused DB, so I want to know if it is possibl…
New utils2_ak feature!
I have uploaded an update to utils2_ak that contains an update to the dbstruct utility. There is now an option, -l, to produce a simple comma separated column list suitable for inclusion in a SELECT's projection clause or in some code situations. ------------------------------ Ar…
New RFE - CSDK support for static links under the latest GCC releases
If you find this RFE relevant to your systems, please vote for it: Currently the only way to produce a statically linked utility using ESQL/C is to compile and link with a GCC release earlier than 5.5. The latest is v10. https://ibm-data-and-ai.ideas.aha.io/ideas/INFX-I-406 -----…
informixHQ without informix
Hi, Concerning I have some java problems with some of our programs. As OAT, can informixHQ run outside informix server only with CSDK installed? SP ------------------------------ Sergio Peres AIRC Coimbra ------------------------------ #Informix…
Things Fail! - Getting Serious About Redundancy! by Tom Girsch an Informix Tech Talk this week
Things Fail! - Getting Serious About Redundancy! by Tom Girsch an Informix Tech Talk this week. Date: Thursday, April 29, 2021 2:00pm EDT Please register at: https://www.iiug.org/en/services/next-webcast/ Join us for a great discussion on how to plan and avoid failures in compute…
HQ - Current SQL statement or Last parsed SQL statement
Informix HQ does not display "Current SQL statement" or "Last parsed SQL statement" for session unless sql trace is turned on. Is this bug or feature? Some customers have 100.000s statements per second and turning sql trace on will keep just last 0,05 seconds of sql commands (unl…
Things to do before upgrade - HDR/RSS
Hello As i can see here , there are a bunch of things to do or check before upgrade (IDS12 > 14). But do I have to do all this on all the servers ? For example, UDRs Do i have to recompile them also on the HDR and RSS ? (Also, if you have a link to UDR compile/recompile process, …
How to find which dbspaces are set to auto extend?
Howdy y'all! I understand what needs to be done to do make a dbspace auto extendable: Mark the chunk(s) extendable: DATABASE sysadmin; EXECUTE FUNCTION task("modify chunk extendable", "12"); Set the SP_THRESHOLD onconfig setting. Change how often the mon_low_storage task runs: …
question about in-place upgrade
Hello i'm suprised !!!! on this link it's said that we can upgrade in-place from 11.70 to 14.10 BUT 11.70 is compatible with AIX 6.1 and 7.1 and not with AIX 7.2 14.10 is compatible with AIX7.2 but not with AIX 6.1 and 7.1 so can we really do an in-place upgrade …
in place alters
Hello do we need to fix inplace alters when upgrading from 11.70 to 14.10 with dbexport from source 11.7 server / dbimport on target 14.1 server ? Thanks ------------------------------ John Smith ------------------------------ #Informix…
New release of utils2_ak! Also some great news!
Folks, I uploaded an update of utils2_ak to my web site (www.askdbmgt.com/my-utilities) GREAT NEWS! The ESQL/C bug that has prevented dbcopy from copying lvarchar type columns since v3.50.xC5 (over 10 years) has finally been fixed as of CSDK v4.50.FC5! Yippee! That means that onl…
storage restriction of Innovator-C Edititon
Hello All, I saw a post a few days ago that the storage limit (100 GB) of Db2 Community Edition was removed. Database choices made easy with IBM Db2 | by Karthik Gopalakrishnan | Apr, 2021 | Medium Are there any plans to remove the storage limit of the Innovator-C edition of Info…
Temp dbspace usage
Hello everyone, Hope all are safe and healthy in this pandemic. How can I check which query/session or activity is using more Temp dbspace. We have total 32 GB temp dbspace (16 temp dbspaces with 2 gb chunk each). Currently gets warning message for Temporary dbspace is 94% used …
Can I use InformixHQ on IDS 12.10.FC10 ?
I want to setup InformixHQ and replace old OAT for my production environment, the databases version is 12.10.FC10, Can I use InformixHQ on IDS 12.10.FC10 ? ------------------------------ Chaz Hsieh ------------------------------ #Informix…
Another "shoot yourself in the foot"?
I got invitation for: "Save significant costs by seamlessly migrating from Oracle to PostgreSQL with IBM" So I suppose IBM does not have any decent RDBMS for Oracle replacement. Regards Hrvoje ------------------------------ Hrvoje Zokovic ------------------------------ #Informix…
Fixing awkward-looking view-related queries
When we create a view using a sensible-looking query, the database converts it into a version that has lots of extra parentheses and odd-looking table names. Below is an example of one of these converted queries. This is a relatively simple example compared to some of the other …
Downgrade from IDS 14 to 12
Hello We'd like to upgrade our servers from IDS 12 to IDS 14 3 servers in primary/HDR/RSS configuration. To check/learn the process, I installed the same config on virtualbox (with demodb) I upgraded from IDS 12 to 14, and all work fine. But, I tried (on the same test machines) t…
Job opportunity
Please reply via private message. Software Development Manager – Governmental Services Direct report to: VP – Product Development Dotted line report to: VP – Governmental Services Location: Carrollton, Georgia or remote (Eastern Time) FLSA Status: Exempt Why SMI? SMI (Systems & M…
archecker utility on ontape level 1 archive
Hi, when I run the archecker utility on a level 0 archive taken with ontape, it runs fine and gives me PASSED and exits 0. When I run it on a subsequent level 1 archive, I get numerous errors. Should archecker also work on level 1 backups? Upon request I can paste the archecker o…
HDR shutdown and Restart
Dears, Please let me know, if have HDR setup for PRIMARY AND SECONDARY and if we have to shutdown for patching activity both server then can we directly shutdown ( onmode -ky ) and then restart ( oninit -vy ) ? In this case if we start both servers directly thru oninit -vy then w…
Install JDBC on IDS 14
Hello, I'm a little confused. How do I install JDBC? In the IBM doc (6a), I can see that it's possible to install JDBC during the installation process of IDS 14, https://www.ibm.com/docs/en/informix-servers/14.10/14.10?topic=installing-preparing-installation in the typical instal…
Access informix DB from other unix Server
Hello All, Please let me know how to access informix database from another unix server ? Another unix machine has No I nformix installed. Thanks Amit Patel ------------------------------ AMIT PATEL ------------------------------ #Informix…
Find who is connected via Prox connection manager
1. A session is rolling back and has held 14 Million lock. 2. When I check in sysessions for that rstcb, it gives me Connection Manager as "hostname". 3. Connection manager is in Proxy mode. 4. The program type is DBeaver. 5. How do I find the actual host/IP who is running the qu…
Kernel AI/O tuning
I have a question about tuning kernel asychronous I/O, specifically on Linux (RHEL 7). For a bit of background, kernel parameter aio-max-nr controls the maximum number of KAIO requests, divided among all CPU VPs. Informix environment variable KAIOON then determines how many reque…
Checkpoint duration and TXNS Blocked
Hello everyone, We are having problems with one of our servers. For a few days now, checkpoints that generally lasted 0 seconds are repeatedly taking 1 second, sometimes 2 seconds, and some transactions are being blocked. "21:11:18 Checkpoint Completed: duration was 1 seconds.…
Migration
Dear All, Currently We are working on IDS 11.70 and most probably in couple of month will move to 14.10. Our data size is around 1TB and all chunks are of 2GB size and page size 2K and most of the tables having rows in millions e.g. 10M , 15M etc. What would be the best way to mi…
change_MSGPATH.sh
I really like having my Informix log in separate files for each day, like this: -rw-rw-r--. 1 informix informix 2407 Mar 19 23:00 online-21-03-19.log -rw-rw-r--. 1 informix informix 2408 Mar 20 23:00 online-21-03-20.log -rw-rw-r--. 1 informix informix 2688 Mar 21 23:00 o…
Creating a series from two char columns
I had a table (let's call it ranges) where I had separated a-c values into two columns with respective values a, c. 1027 1-4 1 4 2562 a-c a c 2564 1-3 1 3 6663 a-c a c 7426 a-d a d I want to generate a table of this sort: 1027 1 1027 2 1027 3 1027 4 2562 a 2562 b 2562 c 2564 1 25…
Simple column encryption
We export data from our DB regularly and now we need to encrypt some columns. Something like unload to data.unl select col1, col2, crypt(col3), col4 .... This doesn't have to be super secure and the columns we encrypt (char and int) are rather short so we'd like to keep the encry…
zombie SQLERR 349
Hi, I am checking several connections with error 349 in several instances over versions 12.10.xx and 14.10.xx, the strange thing is that sessions appear in syssessions ...!!! As the error 349 is related to missing database selection. I am trying to identify the cause. Has anyone …
database exclusive access
Hi, I am having trouble making changes to some databases, I use a procedure that searches through syssessions and terminates all connections. However I have noticed that some dirty reads sessions and also sometimes connections to sysmaster:sysdatabases remain. If I run database <…
Journaling file system
Some Informix DBAs believe "journaling" should be turned off for file systems that hold Informix chunks. The idea is that Informix does its own journaling, so the operating system journaling is unnecessary and possibly harmful. http://infxms.blogspot.com/2012/04/file-systems-for-…