Threads from 2023
Browse by month: Jan · Feb · Mar · Apr · May · Jun · Jul · Aug · Sep · Oct · Nov · Dec
Check if buffers are in swap?
Hello, maybe last question of 2023 :-) I noticed slow downs during last week in our single instance on RHEL8 - i suspect storage (SAN) speed slowdowns, but not totally sure. Also maybe swap oocured with oninit processes ? How can i check to verify this ? Thanks and good start for…
Shrink after successful repack made Informix to exit
Informix 11.70.FC5XE Repack of a large table finished successfully, after that, shrink caused the server to exit abnormally. $MSGPATH : 12:56:09 Repacked 153972346 rows in bluebird:informix.ord_l_curr 12:56:09 SCHAPI table repack bluebird:informix.ord_l_curr succeeded 12:56:15…
What prevents a RSS to roll forward as fast as its primary?
We have two servers of the same architecture, IBM Power 870. Each has storage allocated on separate IBM FlashSystem 9200. Primary's resources: Cores: 51 RAM: 600 GB RSS: Cores: 5 RAM: 400 GB Performing a table repack, the primary generates logical logs pretty fast, while the RSS …
Informix JDBC 4.50.J10W1 from fix central
Have anyone been able to install this one? After unpacking the final tar, I am not able to run the setup jar file: $ java -jar setup.jar -i gui Error: An unexpected error occurred while trying to open file setup.jar And, if I try to list the content in the jar file, I get: $ jar …
ISQL download
Hi Family. I may need to quickly refresh myself on ISQL. Is there a "consultants" version (i.e. free download) of this product? Anyone have the URL for this? My recent search missed it; it may be there under my nose. (Well, so is my mouth but I can't see that either. ;-) Thank…
Where can I download Informix 11.70？
Where can I download Informix 11.70？I need to download it to do some tests. ------------------------------ Zhimin Han ------------------------------…
PSM Error -88017
Have been playing PSM lately and regardless of how many times I recreated the catalogs, redo (delete/add) devices and pools, etc. I continue to get the following error: 2023-12-13 09:34:18 25493912 21037456 The PSM is ready. 2023-12-13 09:34:18 25493912 21037456 Error -88017: I…
ほぼテク12月1日ChatGPTと建築設計!?未来の建築を形作る新たなアプローチ
ほぼテク12月1日ChatGPTと建築設計!?未来の建築を形作る新たなアプローチ このブログでは、建築設計の複雑な課題を克服し、創造性と技術の融合を図る方法を探求します。建築図面作成における時間的・技術的制約、クライアントの要求、コミュニケーションの障壁など、一般的な課題を深掘りし、ChatGPTがどのようにこれらの問題を解決し、設計プロセスを革新するかを探ります。ChatGPTは、図面のアイデアスケッチから詳細な提案まで、建築設計のあらゆる段階で利用可能です。また、本文中で、現代的なアパートの平面図の作成にChatGPTをどのように活用できるかの例を示…
System Analytics
System analytics involve the analysis and monitoring of various aspects of a computer system or network to gather insights, optimize performance, and ensure efficient operation. These analytics provide valuable information about the system's behavior, resource utilization, and po…
Long transaction aborted
Hello, Adding a field on a 24 millions rows table fails on [ Code: -458, SQL State: IX000] Long transaction aborted. [Script position: 1108 - 1110 ] [ Code: -12204, SQL State: IX000] RSAM error: Long transaction detected. [Script position: 1108 - 1110 ] I could add logical lo…
What is wrong with my onbar invocation?
Hi, I try to restore my DB to point-in-time: onbar -r -w -t "2023-12-11 03:00:00" What I get is error 149: 2023-12-11 11:09:21 35913732 21823508 /opt/informix/11.70fc5xe/bin/onbar_d -r -w -t 2023-12-11 03:00:00 2023-12-11 11:09:21 35913732 21823508 Invalid Point In Time value s…
Informix Installer hangs while installing GSKit
Hi community, I try to install Informix 14.10FC9 and FC10 on CentOS 9 Stream, but the installer hangs while installing GSKit. The process /tmp/xxx/onisilib GSKit -i /opt/informix/lib wont finish. Anybody can help here? Thx ------------------------------ Jörg Seider --------------…
ほぼテク11月17日ChatGPTの力で探るカサ・ミラの魅力!?AIが拓く新たな文化体験!
ChatGPTを使ったスペイン、サグラダファミリアの事前調査の素晴らしさ 海外視察において、特にスペインのサグラダファミリアのような重要な世界遺産を訪れる際、十分な事前調査は不可欠です。ChatGPTを活用することで、視察の準備が効率的かつ深く行えます。本記事では、サグラダファミリアの歴史や建築の特徴をChatGPTで調査し、観光のヒントや視察プランの作成方法を紹介します。これにより、より充実した視察体験が可能になります。 www.growth-japan.com/blog/it-daily-brief-2023-1116 #AI #chatgpt #G…
InformixHQ: Entering credentials for monitoring and admin
Hi Family. Almost done with the polemics of the Java setup for InformixHQ but this is a different issue: I am now in this screen: I have the identical credentials for the admin section. My host name is maxwell2l. The group name is omni, containing 1 server named ol_first , which…
Starting up InformixHQ
Hi Family. In my usual concise manner (ahem!) I am asking for assistance. Yes, I have the Starting the InformixHQ Server page open. I started to watch the video on how to start up InformixHQ but it was so blurry and muffled as to be effectively useless; I gave up about 5 minutes…
Errors occurred while cleaning dbspace
Hi, IDS put a warning in message log when starting: 18:13:19 Assert Warning: Errors occurred while cleaning dbspace 'dbs01 informix ' 18:13:19 IBM Informix Dynamic Server Version 11.70.FC5XE 18:13:19 Who: Session(1, informix@elids5, 0, 700001f18a7c028) …
WAIUG Meeting this Thursday!
------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------…
Latest documentation on C++, ODBC, .NET and OLE DB
Hello, I need access to latest doc for the following documentation, can anybody help me with appropriate links? Object Interface for C++ programmer's Guide ODBC Driver Programmer's Guide .NET Provider Reference Guide Data Server Provider for .NET Programmer's Guide OLE DB Provide…
IBM data server driver connection to multiple connection managers
Hello, I already asked this on whatsapp channel Does anyone use drda connection to group of connection managers? here is my connection string: <add name="name2" connectionString="Server=IPADDRESS:PORT;User ID=user;Password=password;Database=mydb;Persist Security Info=True;" provi…
ibm data server driver + multiple connection managers
Hello. I already asked this on whatsapp - let's try here :) Does anyone use drda connection to group of connection managers? here is my connection string: <add name="name2" connectionString="Server=IPADDRESS:PORT;User ID=user;Password=password;Database=mydb;Persist Security Info=…
Guide for Server Specification Calculation
Hi, my name is Ryan. I'm still inexperience on Informix and would like to get some advice on Server Specification Calculation Guidelines. Here's some details furnished by the Development team : Environment : Virtualised Environment Database Size : 2 TB with estimated up to 8 TB…
Stop EAR
Greetings, I have to stop a single EAR deployed in a Websphere Liberty profile. I know I can do it from admin center console. But how can I do it from command line ? Sorry bu I can' t fund it in documentation. I know I colud do it with WebSphere traditional. Best regards --------…
Native Informix Driver for PHP
Hi, We're currently thinking about Informix and PHP for a very specific project in our company. As you know, the connector offered by PHP is a PDO maintained by IBM (pecl) and uses the Informix ODBC library. We've already adapted it a little so that we can use at least persistent…
How to switch RSS traffic to a dedicated network interface?
Hi, Trying to solve the -25582 problem we want to switch RSS traffic to a dedicated network interface. So, I added corresponding lines in sqlhosts, defined DBSERVERALIASES. Please, what are the next steps? ------------------------------ Sincerely, Dennis -------------------------…
Anybidy using IBM Date Server Driver client with multiple connection managers?
Hello I'm trying to connect app (using IBM Data Server Driver - drda connection) to multiple connection managers. In connection string I just put IP address, port, database name, username and password. And I have sqlhosts with group name with listed all connection managers. Any e…
Updated utils2_ak package available
Folks: I have uploaded updates to myschema and dostats_ng.ec included in the latest utils2_ak.zip package. Here are the changes: Added version & copyright to the verbose 2+ output in dostats. Thanks to Chris Karsten for the suggestion. Myschema: Fixed the reported length of LVARC…
Informix processing "freezes"
Hi all, wanted to ask some advice around some recent Informix "freezes" we've experienced lately. on two occasions we've had cases where Informix has frozen for several minutes resulting in the business application also freezing. the situation has resolved itself after a few mi…
bad passwd ifxjson during IIF.12.10.FC13IE.windows64 installation
Hi, i try to install this version on windows , choose custom installation with instance to be created.. the informix passwd is required : i give it : ok but same question for ifxjson : answer ifxjson => invalid passwd for existing user ifxjson.. i dont find any explanation neithe…
GLS Files source conversion file
Hello, Anybody knows how to transform a compiled conversion file (cvo) to source conversion file (cv) and vise versa ? Thanks ------------------------------ Garcia Benjamin ------------------------------…
Empty `onstat -g his`
Hi, That's my onconfig setting: SQLTRACE level=med,ntraces=1000,size=2,mode=user And that is what `onstat -g his` shows: IBM Informix Dynamic Server Version 11.70.FC5XE -- On-Line -- Up 22:33:44 -- 344686176 Kbytes Statement history: No statement trace data is available. A syssql…
November 12 New ideas - Please vote
Hi, Please vote up the new ideas I logged for Server Enhancements https://ibm-data-and-ai.ideas.ibm.com/ideas/INFX-I-579 Add functionality level https://ibm-data-and-ai.ideas.ibm.com/ideas/INFX-I-580 Add ability to control optimizer version https://ibm-data-and-ai.ideas.ibm.com/i…
Allocated and Used Memory
Hi. I have Informix 14. In InformixHQ I see allocated memory is growing steadily. But I'm wondering why there is such a big gap between allocated and used memory? ------------------------------ Alexander Ivanov ------------------------------…
Manual PRI and RSS switch-over
Hi, We have two servers setup, PRI and RSS. How to switch their roles? I suspect the Admin Guide omits some significant steps. ------------------------------ Sincerely, Dennis ------------------------------…
Tracing just one stored procedure
Currently, the company I am working for is using Informix 12.10 on Windows servers. Is it possible to trace all calls to one stored procedure using InformixHQ? I just want the calls and result(s) returned. If I use "trace procedure", do I have to place it before all calls to t…
Ugly Query - It ran in 12.10FC10 but doesn't finish in 14.10FC9 due to memory issues.
Hi Guys, I have a very simple but ugly query that would run in minimal memory in Informix 12.10FC10 but takes gigabytes (mostly in ralloc) in Informix 14.10FC9 This is fine when we run it on the production host as that has plenty of capacity - but it does not play well in our UAT…
backup fail - 14.10.FC4W1
Hello, Our backup stops to work (dev environment) RHEL 7.9 informix 14.10.FC4W1 There was no change before the backup failed no restart (440 days up) I if try manually ontape -s -L 0 >> $HOME/ontape.log 2>&1 this is what i get: ontape.log Thu Nov 9 08:11:01 IST 2023 Archive fail…
Slower 4GL Row by Row Inserts and Deletes on 14.10
My company recently completed a multi-year migration off old Informix 11.70.FC7 (RHEL 6) servers to new Informix 14.10.FC9 (RHEL 8) servers. Following the migration we are noticing slower performance of some app team 4GL scripts that run locally on the database server. One specif…
INFORMIX TABLE SIZE
Dear All, We normally use the following SQL to get the INFORMIX TABLE size. select tabname , ((npused * pagesize) / 1073741824)) GB from systables where tabname matches "<tab name> " Does it mean " DATA and INDEX storage both " or do we have to calculate all the index sizes of …
InformixHQ - alerts are reported only once
Hello, I am trying to configure alerts - I create 2 - one for Informix server is offline and second one for InformixHQ Agent is offline. When I started both InformixHQ server and InformixHQ agent and put db server offline or shutdown agent, I was alerted by e-mail, but when resta…
SQL query cost is very high
Dear Friends, We are using IDS 14X and the below SQL query is taking high query cost even if it perform INDEX path. Could you pl help us to optimize the SQL query below. select a.mobile_no, a.cbc_package, a.active_from, a.active_untill from cbc_mobile a, smgt004 b where a.mobile_…
Informix IDS 14.10 for Linux RHE9 aarch64
Hello, Is Informix IDS 14.10 available for Linux RHE9 aarch64? Seb ------------------------------ Sebastien FLAESCH ------------------------------…
Safe to DROP sbspace with zombie objects?
IDS 12.10.FC14 Solaris 10 1/13 This is related to this prior thread which discusses sbspaces that contain objects with Ref Count = 0, or Ref Count = 1, but with zero tables in the database that actually reference the object. The work-around is simple and effective: bounce Infor…
Optimizer question
In an Informix class many years ago, back in the 7.x days, the instructor told us that the optimizer would always do a table scan when accessing tables 8 pages or less. There may have been some exceptions if the access was to check a referential integrity constraint or something…
Cleaning up datablades
Is there any official way to remove all of the datablade tables/functions/etc after removing all blades from a database? I have a list of how to remove them all by hand. But I am just curious if there are any functions or methods to 'officially' remove them from a DB if there are…
Debian and RAM usage ...
Hello, We have a Debian VM with IFX 14.10xC8. When we run oninit the cache is correctly allocated and ipcs -a is ok and HTOP or vmstat gives us consistent RAM usage information. After several days of use, the memory does not move and everything is fine. On the other hand, if we a…
Mystery flag in syslogs/syslogfil
Hi Family. While playing around with the catalogs I ran the following query on syslogs: select number, uniqid, size, used, is_used, is_current, is_backed_up, is_new, is_archived, is_temp, is_pre_dropped, flags, hex(flags) h_flags from syslogs order by uniqid Here are the last two…
SBSPACENAME overiding PUT clause
Informix 12.10.FC14 Solaris 10 1/13 I have already opened a tech support case for this, but am posting here, in case anyone might recognize the problem and have a quicker answer. We have a table with a CLOB column. The table has a PUT clause defined, which specifies an sbspace …
Undocumented setting for IDS to ignore SIGHUP?
If you run "kill -1" (SIGHUP or "hangup") on an "oninit" process, it writes a small assert file and full stack trace for that VP, but stays running. This has been proved on both 12.10.FC14 and 14.10.FC10. Anyone know how to tell IDS to ignore it? Neither "trap" or "nohup" in the …
Informix CSDK
Hello, Trying to use Informix CSDK 4.50.FC10W1 on SunOS 5.11 / 11.3 SPARC: informix@iode:/dbs/64bits/ifx$ uname -a SunOS iode 5.11 11.3 sun4v sparc SUNW,Sun-Fire-T200 I get following error: informix@iode:/dbs/64bits/ifx$ esql -V ld.so.1: esqlc: fatal: /dbs/64bits/ifx/CSDK-4.50.FC…
How remove sblobs with Ref Cnt = 0 and no reference from any table in any database?
IDS 12.10.FC14 Solaris 10 1/13 This may be similar to a previous issue I posted about, concerning a zombie sblob-- but in that case, the Ref Count = 1. Today, I'm interested in removing (garbage collecting, I would think) several sblobs in an sbspace. The reason for this is I w…
SQL COALESCE() does not support SQL parameters
Hello! Seems that the nice COALESCE() SQL function does not support SQL parameters. I get this error: -999: Not implemented yet. Any bug / feature id? This would be very useful, it's supported by other DB engines. Seb ------------------------------ Sebastien FLAESCH -------…
Which ESQL/C versions support SQL DESCRIBE OUTPUT?
Hello! I try to find out in which ESQL/C version the OUTPUT option of the SQL DESCRIBE instruction was introduced. This would help us a lot to fix an issue very easily, but we want to be backward compatible with ESQL/C versions older than 4.50. The syntax of ESQL/C DESCRIBE seems…
Does Informix 4GL exist for Linux?
Hi, Is it actual release? ------------------------------ Sincerely, Dennis ------------------------------…
IFX 12.10FC16 for sol64
Hi, on fix central version 12.10xc16 for solaris sparc not available ? regards ------------------------------ Garcia Benjamin ------------------------------…
New ideas
Hi, Please vote up my new ideas. https://ibm-data-and-ai.ideas.ibm.com/ideas/INFX-I-568 Show reads/writes per session broken down by bufferpool. Note I am not saying by pagesize as I also want more than one bufferpool per pagesize to allow seperation and different page aging. htt…
Bufferpool for 2K pagesize
Hello, i was just wondering why read and write caches are showing 0% utilization even though we allocated 20mb for this default bufferpool to one of our informix instances. And buffer turnover ration is around 950 for 2K page size. we have not seen this behavior in other instanc…
Informix and Cohesity
My apologies if I posted this awhile back ... does any use Cohesity with Informix for backup/restores? Or do you know if Cohesity supports Informix? Thanks! Mark ------------------------------ Thanks! Mark Scranton The Mark Scranton Group mark@markscranton.com -------------------…
Key management and HSM
Hi Experts, Has anyone had any experience with storing encryption keys on HSM in 12.10 or 14.10? ------------------------------ Ali Shahnazi ------------------------------…
Backup smartblobs seperate and move from 11.70 to 14.10
Hello, is there a smooth way to backup smartblobs from 11.70 to 14.10 (different server)? System would be RHEL7 and RHEL8 Thanks ------------------------------ Marc Demhartner ------------------------------…
What does ALTER FRAGMENT do extending a fragment?
Hi, Running ALTER FRAGMENT extending a fragment I notice a significant pause when the session does nothing (?) ALTER FRAGMENT ON TABLE tab01 MODIFY PARTITION tab01_0047 TO PARTITION tab01_0047 ((item_id >= 115000) AND (item_id < 120000)) -- was: item_id>=115100 AND item_id<120000…
Get logical log backups 4 to 5 times faster
Abstract a) Fix network configuration on a TSM server (a wrong net mask even on an inactive interface can spoil the performance.) b) Disable NetBIOS over TCP/IP on the TSM server (provided it's running on Windows.) These activities brought us log backup in 10s instead of 45s. Env…
Cannot delete tenant database
Hello, I have been playing a bit with the tenant database and I see an issue when I try to delete the tenant database. The database has been created using the following command: EXECUTE FUNCTION task('tenant create', 'testmdb', '{dbspace:"testm_dbsp", blobspace:"testm_blsp", sbsp…
Innovator-C on AIX
Hello guys do you know if Innovator-C can be installed on AIX, or it is supported on Linux, Windows, Mac platform? Thanks a lot. ------------------------------ Milan ------------------------------…
我妻裕太が送るGPT連続投稿148日目！今回のテーマは研究概要書の作成。
我妻裕太が送るGPT連続投稿148日目！今回のテーマは研究概要書の作成。 研究者にとって非常に重要な研究概要書を効率よく、しかも分かりやすくまとめる方法とは？ GPTが研究概要書作成の課題を如何に解決するのか、具体的な例と共に解説します。 研究を外部に効果的に発信したい方は必見です！ ------------------------------ 裕太 我妻 ------------------------------…
Mirroring plogspace?
Informix 12.10.FC14 Solaris 10 1/13 How does one start (and stop) mirroring for an existing plogspace? I note that the documentation for 'onspaces -m' is careful to exclude 'plogspace' from the list of spaces upon which it operates. Thank you. DG ------------------------------ D…
ROWID question
I am working part time at a small consulting firm. They had a very old version of Informix with a 4GL interface dating back probably 20 years that hadn't been updated. There's a lot of code and almost all the searches are configured using ROWID. I've set up a VM using a modern…
Fragmentation problem
Good morning! in Informix IDS 10 (windows 32 bits), an error occurred while fragmenting a large table. The error was: 776: Alter fragmented error: unable to move row(s) to new fragmentation schema. 772: Record/key doesn't qualify for any table/index fragment. I know what I missed…
Encryption and restore
Hi folks, Informix 12.10.FC15 AIX Using raw devices I'm seting up encryption and came up with a doubt/question Intialized an instance Backed up and restored with encrypt option ( ontape -p -encrypt) Created dbspaces ( took so long ) Created database and imported data Backed up an…
onstat -d for non-privileged users
Hi Y'all. In my Perl package DBspaces .pm I have a function that runs onstat -d. I originally wrote it while using IDS 11.5. At the time, anyone could run onstat -d, just not with the "update" option. That was fine by me. Hence, anyone could check on the status of the dbspace…
KAIO not enabling on a device with 4096B block size
Hello everyone, It seems others have run into this issue recently (this year) and now I am running into it. KAIO is not enabling on a chunk that sits on a device with a 4096 B block size. 14.10.FC9WE running on Ubuntu LTS 22.04. root@informix03:/# blockdev --getbsz /dev/sdb1 409…
SMI equivalent of onstat -g spf
Hello, does anybody know if there is a sql table/view from sysmaster to get the info which command onstat -g spf provides? Thank you ------------------------------ Milan ------------------------------…
Create none OS user Informix 14
Hello. I'm moving from 9 to 14 Informix. Now I'm trying to create a user and give him the right to select from the database. In Informix 9, there is an OS user in the Informix-admin group. I don't want to create an OS user. I tried the CREATE USER statement and got an error about…
IBM TechXchange Livestream: Keynote Research Session
Don't forget to head on over to the ibm.biz/techxchange today at 1:15 PM PDT to hear the Keynote Research Session: Are You Ready for the New Age of AI and Beyond? Speaker Jason Gartner, General Manager and Chief Technology Officer of IBM Client Engineering, Technical Sales and Sk…
Informix IDS system requirements regarding libncurses 5 vs 6
Hello, Just seen this workaround in Informix Server System Requirements ** Following system libraries are needed for IBM Informix Dynamic Server version 14.10.FC9 and greater to run on Red Hat Linux 9. Higher versions of same libraries are installed on Red Hat Linux 9. As a worka…
Trying to recover a 11/50 TC3 32 bits instance
Hi folks Still struggling with the attempts to recover that customer's full instance ( see my last message about archecker issues) Making it short, big disaster with my customer's storage. After a few days we remain with 2 possible directions to recover something They could retri…
Error -25582, what's a reason of?
Hi, IDS 11.70.FC5XE MSGPATH was being filled with error -25582, listener-thread: err = -25582: oserr = 0: errstr = : Network connection is broken. As cherry on the cake, IDS almost stopped to accept connections from app servers. The only solution we found is restarting IDS. What …
Strange Error -1215 under Informix 14.10 (but not 12.10)
Hi All, This should be simple, but it's had me spinning for days. We recently upgraded from Informix 12.10.FC4 on Solaris 10 --> Informix 14.10.FC9 on Linux 4.18. Since the migration, nearly all of the SQL code and procedures work, no changes needed. EXCEPT one, which is suddenly…
Paul's presentation on One-DB
Great presentation there, Paul. Of course you only barely scratched the surface. Will the slides be made available for downloading? Also, I don't recall seeing any slides related to features on One-DB missing in IDS, planned or already in place. What kind of superset would it…
archecker on IDS 11.50 TC3 (windows 32 bits) : tapesize seems forced to 2 Gb
Hi community, I am helping a customer on rescue operation in this environment (I know, not the best, migration to linux/current version planned within weeks). Basically extremely severe damage on their storage, IDS server totally exploded, same for their backup media, but they co…
Informix 12.10, Windows 2016 updated now Error db_locale
Hi, we use many Informix Server 12.10 on WIndows Server 2016. Last weekend we updated the Windows OS, since then we get random Errors that the db_locale doesn't match. We can fire 10 times an SQL in the SQL-Editor and 8 times ok, 2 Times we get this error, sometimes we also get a…
August IIUG Tech Talk
------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------…
Restore failed via using backup file generated by InformixHQ
Hi, I notice that backup file generated from HQ is corrupted during restore in staging server. I use InformixHQ Server Version: 1.4.0 Build Timestamp: 2020-10-30T07:53:02-0500 Hence, it execute error; Physical restore failed - ÓÛ Program over. What makes me wonder is that when i …
ほぼテク8月13日ITセキュリティの新時代？ChatGPTによるシステムログのレポート作成！？ワードクラウド編①！
ほぼテク8月13日ITセキュリティの新時代？ChatGPTによるシステムログのレポート作成！？ワードクラウド編①！ GPTでシステムログのレポート作成の新時代を探求。棒グラフからワードクラウドの視覚化に挑戦。ITセキュリティ、テキスト分析、プレゼンテーション、教育での利用を解説。アクセスログを直感的に理解する新しい方法を試してみよう！ www.growth-japan.com/blog/it-daily-brief-2023-0813 #GPT #chatgpt #GPT-4 #レポート自動化 #ワードクラウド ---------------------…
Informix Server 12.10.xC16 is out!
Hi, Informix Server 12.10.xC16 is out! Whaat New! https://www.ibm.com/docs/en/informix-servers/12.10?topic=overview-whats-new-in-informix#newxc16_toc It was mentioned on the IIUG Inside on 8th August but the defect fix list is not there yet, come on! https://www.ibm.com/support/p…
Curious About Rebuilding Sysmaster
Solaris 10 1/13 IDS 12.10.FC14 In a recent tech support case, we needed to rebuild sysmaster. (Sysmaster had been dropped.) The engineer told me not to run 'buildsmi', but to bounce Informix. I did and, of course sysmaster was rebuilt. I should have asked, but didn't. Is ther…
Strange error message
Greetings. I'm running Version 14.10.FC9W1 on Linux. I tried this for fun: create table t1 (f1 char(100)); create index my_ix on t1 (f1[1,10]); 26601: Cannot define a partial-column index on the non-character column, (f1). $ finderr 26601 -26601 Cannot define a partial-column …
Default page size and variants
Hi Folks. I have a question regarding the default page size for a server. Actually a couple, though I think I have one answer already. All the Informix servers I have encountered in the past 15 years or so have all had a default page size of 2K. I recall that some Solaris syste…
Activating CDC and use of logical logs
Hello everybody, ¿Do you now if activating a table for CDC using the function cdc_set_fullrowlogging, use much more logical log ? I have not found any reference in the documentation about it. Please provide any clues according your experience. Regards, Roger --------------------…
Details to "WARNING: Detected slow or failing DNS service response XX time(s)."
Hi! Does anyone have more detailed information on " WARNING: Detected slow or failing DNS service response XX time(s)." What is the threshhold for "slow"? Can I activate any logging, to get the slow DNS-Response (Windows)? What I currently now (or think to now) from the online-lo…
dbs_partn_ mutex contention
Hi, IDS 11.70.FC5XE, AIX 7.1 Sometimes we encounter a situation when many sessions are waiting for mutex. onstat -g wmx says this is dbs_partn_ mutexes, please see below. What does a number in a mutex name mean? What particular resource is the mutex responsible for? The only work…
Informix IDS 10 - Windows 32 bits - odbc
Good morning, I have a server: "Informix IDS 10 - Windows 32 bits " and I need to connect with a migration tool from windows 11 64 bits . Is there a 64 bit odbc driver? Thank you in advance. Guillermo. ------------------------------ guillermo villanueva --------------------------…
ESQL/C conversion error with CLVCHARPTRTYPE
Hello, Once I reported an issue with ESQL/C charset conversion when using the CLVCHARPTRTYPE type: https://ibm-data-and-ai.ideas.ibm.com/ideas/INFX-I-400 Sorry but I have no bug or feature ID, I am totally confused with HCL/Actian/IBM forums and support channels, so I don't know …
Informix HA Cluster and CM
I need to setup a HA cluster with replication. We are able to replica and test failover both ways on node1 and node2. HOw do I get a cluster server on these 2 nodes. so that the Connection Mgr is able to control failover and route connections to the new active node? Do I need to…
Cannot drop a database
Hi, using IDS 14.10FC8 on AIX. i tried to dbexport/dbimport a database including timeseries. The dbimport failed. But now i am not able to drop the database : CFRSV50211016DB<informix></sauvegarde/kpi2/kpi2>echo "drop database kpi_old"|dbaccess - 214: Cannot remove file for table…
Smart BLOB 16359 bytes, w/ ref count = 1, yet apparently not used by any table
IDS 12.10.FC14 Solaris 10 1/13 I wanted to move all sblobs in a certain sbspace to another sbspace. I used this IBM tech note to do so: How to move a table's sblobs . It worked fine. Because I''m paranoid, I then used 'oncheck -pS' to confirm that no sblobs remained in the ori…
Meet-our-speaker at TechXchange
The upcoming TechXchange Conference is the premier, technical learning event designed with technologists for technologists who use IBM products and solutions. It offers over a thousand technical breakout sessions, hands-on experiences, product demonstrations, instructor-led labs,…
Want to DROP an empty rootdbs chunk
Informix 12.10.FC14 Solaris 10 1/13 Scenario: I have an instance that has a rootdbs with two chunks-- the initial and an added one. The added one is empty, and I want to drop it. Because, at one time, it did have contents, additional reserve pages exist in the chunk. Therefor…
Why GSKCapiCmd User's Guide password protected?
After Mark's question about GSKit/gsk8capicmd command [1], I looked for an online reference to the manual. I found it on this page: https://www.ibm.com/docs/en/informix-servers/12.10?topic=protocol-global-security-kit-gskit Which links to it here: GSKCapiCmd User's Guide at ftp:/…
using SSL with Informix
Been reading up on what it takes to set up encrypted communications with Informix. As I understand the docs, prior to 14.10.xC4W1, only GSKIT is supported for SSL. We're running 14.10.FC10 on Linux x86-64, so we should be able to use either GSKIT or OpenSSL. However, we have c…
Autenthication on IDS 11.50 server on WINDOWS
Hi Folks I hope everybody is doing good I have a stupid question regarding security on windows for a user to be authenticated on a xNIX IDS server, you need either to declare the client hosts in /etc/hosts.equiv file + declare a ~/.rhost file is the user's directory on the IFMX s…
dbexport and dbimport - partitioned table
Hello good day! in Informix IDS 10 I need to duplicate a database in another server with the same characteristics. The database has a very large table that is partitioned in several fragments. When I do dbexport and dbimport I get an error with this table: Is there any way for db…
Database dbexport and dbschema failed due to DELIMIDENT
HI I have a client running IBM IDS 12.10.FC6WE on RedHat 7.5 The last successful dbexport backup was on 10 June 2023. The dbexport failed started 11 June onwards till today. The dbexport stop with following message { WARNING: Parts of this schema require DELIMIDENT set in the en…
Informix future...
https://www.iiug.org/en/2023/07/08/iiug-insider-issue-275-june-2023/#Editorial "IBM and HCL are not interested in developing, marketing or selling Informix. They are satisfied with the revenue from the customers who are still using the product." I also hear Informix almost died l…
Informix vNext slides from IIUG/Scott/Karen/Shripad
Hi, Interesting IIUG talk from Scott/Karen/Shripad abhout vNext New Features https://www.iiug.org/wp-content/uploads/2023/04/Informix-VNext-New-Features.pdf "Performance better or equal than prior release: 14.10.xC1 Investigating new compiler impacts, better scaling on Linux, imp…
The physical log is too small for automatic checkpoints.
Hi Family. The stray cat y'all fed is back for more. (Picture a cat emoji ;-) I am reviving an old thread, with a question posted in 2009 and again in 2020. I just reinitialized my IDS server (still playing with parameters) and I now have: ROOTSIZE 1000000 PHYSFILE 200000 LOGS…
Minor alert for anyone installing Perl module DBD::Informix
Finally: I get my first chance in a couple of years to contribute something! I don't know how many Perl buffs there are in this family but I am one such nerd and had some minor grief installing this module, written by one of the GREAT Informix demigods, Jonathan Leffler. Download…
-5849 The sub-query flattening settings for the query plan and the current value of NO_SUBQF environment variable do not match.
Hi! We are getting -5849 error from our Informix server (14.10FC9W1). The error description mentioned the NO_SUBQF environment variable. Where can I find some information about this environment variable? The sub-query flattening settings for the query plan and the current value o…
CSDK Installation log: Mostly successful installation
Hi Family. And hoooray for me (and those who helped me): I finally got an error-free initialization of my Informix instance! Got past at least one spectacularly stupid oversight (physical log > rootdbs) and found it better to set RTO_SERVER_RESTART to 0. Now the next step:insta…
OpenSSL EOL
Given that OpenSSL 1.1.1 will reach EOL in a couple of months, I need to know - does CSDK embed any OpenSSL functionality inside its binaries? Or does it simply use the version of OpenSSL installed on the server? If CSDK includes OpenSSL, does anyone know what is the earliest ve…
JAVA 7, JAVA in general and other platform announcements.
Announcement The product announcement letters are available at http://www.ibm.com/common/ssi/index.wss . Search for Informix 12.10 and select Announcement letters. See the announcement for the following information: Detailed product description Product-positioning statement Pack…
DOSTATS in UTF8 Databases created with GLUSE_GLU=1 / Mix UTF8 and ISO Databases in one Instance?
Hello all We have a Instance with UTF-8 Databases. The Databases were created with GLUSE_GLU=1. It seems that everything runs well, like it should do. The Parameter was set bevore the Instance starts. One thing is, that the dostats tool will not start. When GLUSE_GLU=1 is set it.…
create function to unload data
Hi, anyone here knows if i can create function that can loop to unload data? since as far as i know, stored-procedure cannot do the looping for unload data. Thanks ------------------------------ nasiha zailan ------------------------------…
Easiest way to read 0-level archive of Informix database... without IDS?
Hey all, I have a 0-level archive of an Informix Database (it was on IDS 12.10 I think). We do not have IDS any more but I want to read the database. Is this possible without having to install IDS? If not, is there an easy way to get a trial install of IDS? thanks jc -----------…
$storageType() extension in API Connect switch policy not detecting request body content type
Per https://www.ibm.com/docs/en/api-connect/10.0.1.x?topic=switch-using-policy-condition-editor, I am attempting to use the $storageType([arg]) extension in a switch policy to detect the request body content type (binary, json, stream,or xml). - switch: version: 2.0.0 title: swit…
Large Fetch Bufer causes 4gl program to hang on an insert into a REPORT temp table
Anyone ever seen this before I ask IBM? The program in question works fine with FET_BUF_SIZE=2048000 but when I increase it to 4096000 it just hangs...it has been sitting at the same statement for 35 minutes. Typical runtime is 9 minutes. It ran for 3 hours earlier today befo…
Probably not the record but ....
1779 days for uptime is not bad ..... bash-4.2$ onstat - IBM Informix Extended Parallel Server Version 8.51.FC3???? -- On-Line -- Up 1779 days 06:38:21 -- 3936160 Kbytes -- Paul Watson Oninit www.oninit.com Tel: +1 913 364 0360 Cell: +1 913 387 7529 Oninit?? is a register…
Migrate Data Continuously from IBM Informix Database to AWS S3
Hi all, I have a requirement to send data from IBM Informix database to AWS S3, is there a solution that you could suggest for me? The data traffic should be initiated from Informix to cloud Thanks in advance, Eralper ------------------------------ Eralper Yilmaz ----------------…
How to make database temporarily READ-ONLY?
IDS 12.10.FC14 Solaris 10 1/13 We would like to make a database temporarily READ ONLY. Informix doesn't provide a built-in administrative function or button to make a database read-only. (And then, later, revertible with another function or button push.) So, I need to roll my o…
Linux Operating System Limits/AF files missing
IDS Workgroup 11.50.UC9GE 65GB mem on box Two engines, one 27GB, one 20GB I believe we're running into mem issues (too many segs, etc.) which is causing the box or engine to crash. Not sure which just yet. Situation: The prod engine crashed due to ADM VP issue: 06/19/23 21:02:59 …
onsmsync used to recycle backups : how effective is it?
Hi Folks, I have been installing PSM at my customers and deployed SPL controlled by the IFMX scheduler. I have been testing onsmsync with different options to clear the backup objects. The options I use are -t "datetime" -I number of days -g generations number to retain I am doin…
Help Request: Unable to login InformixHQ
Hi, I am learning InformixHQ. I was practicing adding a server and deploy agent to it. When I added the server, I specified informix as the monitor admin credential and root as the admin credential. I signed out and am not able to login any more, no matter if I used the initial p…
ONCONIFG in a directory other than $INFORMIXDIR/etc
Hi Folks. I feel so stupid asking this and there is an easy solution to my little conundrum anyway. But I've been away for too long and some things have just faded from my memory. So here it is: Of course when I specify in my ENV: export ONCONFIG=onconfig.schmoe then when I try…
system requirement for windows 2022
hi, according to Informix Server System Requirements windows2022 isn't yet compatible. Did someone has more information about this? thanks Jacques ------------------------------ jack rage ------------------------------…
Find high INSERT/UPDATE/DELETE tables
Dear All, Is there a way to find out the tables which has more INSERTs/UPDATEs/DELETs transactions ? Please help ! Thanks ! Best Regards, Indika ------------------------------ Indika Jinadasa ------------------------------…
stored procedure cleanup
IDS 14.10.FC10 on RHEL 8.8 We are trying to identify obsolete stored procedures so that we can remove them from the system. Some of these were developed as part of projects that never went forward, others are procedures that used to be part of our application but have been repla…
Possible bug with IT33524 fix ?
Hi all, The followoing test code exhibits different behaviour between 12.10.xC14 -> xC15, and 14.10.xC4 -> xC5: CREATE PROCEDURE test_nvl_trailing_spaces () RETURNING LVARCHAR, LVARCHAR; DEFINE t_int INTEGER; DEFINE o_int VARCHAR(20); DEFINE e_int LVARCHAR; LET t_int = 6…
Path length bug in ibm.csdk.4.50.FC10.WIN x64
Hello I recently started testing the 64 bits driver and I am having some problems. Tried 4.10.FC14 and 4.50.FC10. If I run C:\\Program Files\\IBM Informix Client-SDK\\bin\\ConnectTest.exe and perform some query it works as expected. Now If I copy ConnectTest.exe to some folder wi…
drop down space/chunks
Hello to All have a dbspace with many chunks, on down state, and could not drop them, pleaase help 700000132d96bc0 9 0x60005 26 5 4096 ND BA informix test_dbs 700000132d9ae28 26 9 25 26214350 0 PD-B-- /chunks/…
Question about fix list in 12.10.FC15W1
Hello. We are planning an upgrade from 12.10.FC12 to Informix 12.10.FC15W1. There seems to be a fix list for the xC15 version, but no documentation for the xC15W1 yet. Where can I get information about what has been fixed? Thank you, SangGyu Jeong ------------------------------ S…
When users complain of generic slowness (without specifics)...
Informix 12.10.FC14 Solaris 10 1/13 ...what are the first three things you check? Thank you. DG ------------------------------ David Grove ------------------------------…
Migration to 14.10.FC10 Asserts during sysmaster conversion
I decided to split this off the other thread. During my performance testing with PDQ on I'm running into a computation delta from non-PDQ runs causing the entire process to bail when math is done wrong. I've found the likely issue as a bug that is fixed in FC8. Instead of goi…
Informix WITH SQL Recursive cannot onmode -z stop session
The below WITH SQL run on Informix demo DB will cause Recursive CTE: WITH customer AS ( SELECT * FROM customer ) SELECT customer.customer_num , items.stock_num , items.order_num , items.manu_code , items.item_num , items.quantity , items.total_price , nvl(orders.backlog,'N') FRO…
Informix TLS Cipher
Hello, Since CSM is deprecated, we're on our way to implement TLS 1.2 According to IBM support, there is no method to select which TLS 1.2 (or 1.3) ciphers Informix is allowed to use. Our servers are monitored by Tenable and only these TLS 1.2 ciphers are considered safe. Others …
PDQ - Why does its performance suck sooooo bad?
I've been doing a lot of performance testing over the past couple of months and I've found several things that ended up being significant performance gains across the board in our Informix (4gl) environment. What sticks out is PDQ. It remains what it was 10 years ago when I las…
RFE - Implement nested loop join of external and indexed tables
Having trouble getting this accepted as a defect, would help to have more votes on the RFE: https://ibm-data-and-ai.ideas.ibm.com/ideas/INFX-I-505 The contents follow. Try this in the "stores_demo" database: SET EXPLAIN ON; SELECT {+USE_NL(customer)} * FROM ext_customer AS e JOIN…
How To Change Username in IBM Account?
Could you help me because i want to change my username but i don't know how to change . ------------------------------ Manga Go ------------------------------…
Using dbdelete utility
Hi, is there anyone has tried using dbdelete utility on windows? I have some difficulties using this utility, anyone can help. Thanks ------------------------------ nasiha zailan ------------------------------…
TechXChange Conference 2023
Hi Marius, I sent an email to you last week regarding some questions we had on the conference. I am hoping you and I can converse on this off the community. Could you please reach out to me? Thank you, Sherie Director of Marketing Motio, Inc. ------------------------------ Sherie…
Informix 14 system requirements - Java
Hello, I got little confused after going through installation documentation. Someone please clarify. https://www.ibm.com/docs/en/informix-servers/14.10?topic=installation-system-requirements Do we need to install Java 1.8 version(Licensed) in server before proceeding with install…
question about CPUs
Hello How could we know exactly how many Cores Informix is using on a Power IBM Server (AIX) ? Not the Sys view but the informix view ( -g glo helps ?) thanks in advance ------------------------------ John Smith ------------------------------…
HDR between On Premise y AWS?
We are in a process of digital transformation in the company and we plan to migrate our entire infrastructure to the cloud. We currently have Informix running on AIX in our data center and we need to move it to AWS. But we need a rollback plan. As far as I understand HDR does not…
RSS out of sync
Hello, We have issue with comvault today and primary informix instance logical backup stopped which led to logical log full and stopped instance. As quick solution, i have taken manual log backup with ontape -a -d which backed up log files to local directory. server was bounced …
Move rootdbs Informix 14
Hello. I have an Informix 14 FC8 on Windows host. I want to move rootdbs to another location. I changed ROOTPATH and moved file to another location. But the server can't start Onconfig parameter ROOTPATH modified from E:\\ifmxdata\\rootdbs.000 to E:\\ifmxdate\\ol_dohod\\rootdbs.0…
Odd restore failure
This is a new one for me. I am trying to restore a copy of a production server to a test machine for performance testing. I have tried ontape archives, onbar archives, and finally ifxclone all with the same result. The archive completes and wants the logical logs to be restored b…
Informix ER -
Hi, In our organization, we have several informix ids server (~30) and databases (~250) with the same schema on informix IDS server (version 14) all around our country. We would like to build some kind of Data Lake using informix ER and the pattern Primary-Target Replication Sys…
JSON_TO_BSON Funtion - special character
Hello, I would like to store json flux in BSON format in my informix database (espaciallye for using index for futures searchs) but i get some trouble with special characters Here is an example of request : SELECT JSON_TO_BSON('{"nom": "Robert", "ville": "Montréal"}') FROM sysmas…
Scheduled Automatic Backup - FAIL
Hi. I'm getting a warning when trying to backup using Scheduled Backup. Here installation details: Linux RHEL 8.7 Informix 14.10.FC10 (Also the same with 14.10.FC9) INFORMIXDIR /home/informix Backup directory /backup/data. Owner informix Permissions 770 I used InformixHQ to creat…
BUFFERPOOL with memory vs pages strange behavior
I'm experimenting with performance and I started playing with buffer pools. I'm getting strange behavior when switching from a line like: BUFFERPOOL size=4K,buffers=790000,lrus=20,lru_min_dirty=30.00,lru_max_dirty=40.00 To this line: BUFFERPOOL size=4K,memory=4gb,lrus=…
Difference between ONCONFIG parameters DYNAMIC_LOGS and AUTO_LLOG
Hi Family. Use it or lose it! It's been a while since I configured an ONCONFIG file and there seem to be some new items in 14.10. But I would tackle them one by one as it comes back to me. So for starters: The default value for DYNAMIC_LOGS is 2 so that "The server adds a new l…
informix benchmark question?
HI, I download the program from below website. and want to do some compare testing in different hardware. https://sourceforge.net/projects/iiug-software-repository/files/ESQL/tpc-c-ifmx/ and I setup those program successful in my thinkpad. and got the first round testing resul…
Aggregate within a ROW in a SELECT projection list is not allowed
Hello Community, I found a weird behaviour when I wanted to move a database from one server to another from Informix Dynamic Server 14.10.FC7W1AEE to Informix Dynamic Server 14.10.FC10AEE (both RHEL 8, but different machines). Everything works well except the following command fo…
Informix restore failure with "Unable to close the storage space restore"
Hello Community, Bit new to Informix and to the group so pardon me if missed anything basic. I am trying to restore Informix instance with the command "onbar -r -p" which should perform a physical restore of dbspaces. The restore is failing with "Unable to close the storage space…
For the IBM i Community ....
Please feel free to use my IBM i References pages blog @ https://ibmireference.blogspot.com/ It's my way of giving back to the IBM i Family. I get nothing other than the satisfaction of knowing it may have assisted someone on the IBM i job or research. It's designed to be a 1 st…
Verify Signature on IDS 14.10 download
Hi Family. I have not posted for a long time because I no longer had my own Informix environment. (That PC had died.) Now I'm trying to get started creating a new one. Starting up posting again, in my usual concise (ahem) manner: I've downloaded: - ibm.ids.14.10.FC10.LNX.tar - …
Cannot drop access_nethod
Hi experts, we have got a weird situation here. For some reason some time in the past somebody accidentally initiated a bts datablade installation in a database. Since this was not used anywhere, it did not cause any issues. On upgrade of the server to IDS14.10, an error was thro…
CIS Hardened SUSE Image and Informix 12.10
Hey all, Firstly, I will apologise if this post is in the wrong group. Hopefully not, but apologies if so. I am just looking for some information (be it docs or user experience) around any issues that people may have come across when using Informix upon a SUSE Linux OS image tha…
leolo INFORMIX worldwide Mastermind in Tyrol 5.-7. June - few days left to register
Only a few days left to register for the leolo INFORMIX Mastermind in Tyrol. Best place to InformixTechXchange, ever. Call for speakers open. Accepted speakers with a free conference pass and one free night. Three days in one of the most beautiful places on the roof of the Alps. …
CIS Hardened images and Informix 12.10
Hi all, Firstly, apologies if this question is posted in the wrong place! Just wondering if anyone has any advice or better yet, documentation, around running Informix 12.10 (or 14.10) on CIS hardened SUSE Linux images in AWS? Looking for 'gotchas' primarily. Many thanks, Dave. …
Empty dbspace won't drop
I cannot drop the following space. It gives me an ISAM 148. 14.10.FC7 I am certain the issue is the errors it is reporting. I don't have any idea how to clear these errors. This space had a table that spanned all these spaces that has been unloaded into a flat file and th…
Weird behavior with locks during delete.
Hi there, I am running into a problem where I can't see to wrap my head around. I'll try to provide all the information that I can think of, but please don't hesitate to ask if you think I didn't mention something. Current setup: * 14.10.FC9W1DE via the test docker containers * D…
Assert Failed: semop: errno = 22
Greetings. I have a customer who is running the Innovator-C edition: IBM Informix Dynamic Server Version 14.10.FC9W1IE -- On-Line -- Up 00:20:31 -- 8388608 Kbytes Running on Ubuntu 22.04.2 LTS Server The engine had been running without a glitch for over a month when they had to r…
Licensing question
Greetings. I always thought one could fire up an RSS node (enterprise edition) without licensing it as long as no user programs connect to it and perform SQL. A customer asked me this question and referred to a document IBM sent him: https://www.ibm.com/about/software-licensing/a…
how to cap sessions memory limit for STORED PROCEDURES/FUNCTION
Hi Friends, colleagues etc my customer is running 14.10 FC9 Workgroup Edition (max 24 Gb of SHMEM in total) (just upgraded for 14.10 FC5) on linux REd hat. He is intensively using stored procedures, and among those, some recursive ones. Fortunately, we identified some procedures …
TADZ/IZSAM
Has anyone successfully been able to use TADZ or IZSAM to verify data in their system? I am looking to ensure that all of the machines, products and usage are a reflection of what is running on our system. Is anyone using this tool for that kind of validation? Thanks ---------…
Best way to synchronize tables via HTTPS
Hello, we have a process requirements where we can´t directly reach customers informix DB via direct connection, so we need a process via HTTPS to synchronize some tables to our "master DB" on our side. What is the best way you can recommend? We would build a webservice for that.…
SHMTOTAL maxed on Workgroup Edition
Hi, I am running 14.10.FC7W1WE on Linux 64-bit VM. The SHMTOTAL has reached the license restriction of 32G and now Onbar Level 0 backups will not run because onbar cannot grab enough memory. 13:20:26 Warning: The IBM IDS Workgroup Edition license restriction limits 13:20:26 the…
Memory errors in online.log when the esql/c program does exit
Hi, I see messages as the following in online.log: 21:02:56 Found during mt_shm_free 1, error seen 1 times since last print to the log 21:02:56 Pool '328' (0xc000000087ed8040) 21:02:56 Bad block header 0xc000000090c2ef70 21:02:56 Assert Warning: Memory block header corruption…
IBM TechXchange Community Call 18 April at 12:30 to 1:00 PM ET
Remember to mark your calendar for 18 April 12:30-1:00 PM ET . We look forward to your participation in the IBM TechXchange Community Call. Come prepared to interact with IBM Experts and peers by logging in to YouTube with your Google or YouTube account and using a Chrome browser…
Informix Connect Version 4.50.FC8
Hello, I can't find the installation package for "Informix Connect Version 4.50.FC8" anywhere. Where can I download the installation package for "Informix Connect Version 4.50.FC8"? I searched on "Passport Advantage", "Fix Central", "Developers Tool", "IBM Search". Everywhere the…
Change constraint implicit indexes to explicit
Informix 12.10.FC14 Solaris 10 1/13 I have a legacy database with several thousand constraints with implicit indexes. I want to change those constraints to use explicit indexes. I'm not seeing any easy way to do that with any of the Informix administrative utilities, but, then a…
Upgrade to 14.10.FC10
Anybody run across this issue, trying to upgrade from 14.10.FC5 to 14.10.FC10. As root user, I copied the FC5 directory as a new FC10 directory, Extracted the FC10 install into the new directory and export the INFORMIXDIR to the new directory. I then ran ./ids_install, but it end…
Excessive logging in version 12.10
Hey all, We recently upgraded from 11.70FC7 to 12.10FC13. During the upgrade I created new log space with logs that were twice as big as they were in 11.70. Despite that change, the amount of logging has increased on the server. Does anyone know of a feature in 12.10 that mig…
Rename IDS 10 instance.
In IDS 10 on windows 32 bits I performed level 0 and level 1 backups with ontape. In order to restore those backups, should the machine name be called the same as the original? Should the informix instance be called the same as the original? Thank you in advance. Guillermo ------…
Informix enterprise replication
Hi I need to know that Informix enterprise replication support from source Informix version 14.10 on HP UX host to target Informix version 14.10 on Redhat Linux. Documentation clamming that replication on dis-similar hardware is supported but I want to confirm if the source and t…
Informix enterprise replication
Is the Informix supports replication from Informix 14.10 on HP UX to Informix 14.10 on Redhat Linux. In Documentation it is mentioned that dis-similar hardware supported in replication but is this true for big endian to little endian. ------------------------------ A. Naveed ----…
Cannot drop two chunks that got added from a storage pool
I have two dbspaces that at one time have had automatic storage added to them and I need that space to go away as it is empty and is impeding moving out of my raw spaces with mirroring.....Informix won't mirror these spaces or drop them. onspaces -d space -p /opt/informix/disk_li…
How to create a Stored Procedure to count the rows of each table in a database?
Dear All: I need to create a Stored Procedure that will count the rows of each table in my database, but I can't do it. I tried with: DROP PROCEDURE "informix".RowCount CREATE PROCEDURE "informix".RowCount( ) RETURNING Varchar(50,0), Integer; DEFINE vTable VARCHAR(50); DEFINE vRo…
Disk/Filesystem/LVM configuration recommendation for cooked Linux Informix chunks
I'm pretty far down the rabbit-hole of moving off raw spaces, thanks to people here and several great resources on the internet. At this point, I have a lot of questions relating to drive/lvm and filesystem config to have Informix use cooked files as efficiently as possible. Un…
What is the suggested approach to connect with Informix from Dotnet Core 3.1 or Dotnet 6?
We want to connect with Informix database from .net core 3.1 application. Currently we are connecting using ODBC ADO.net provider and have Informix ODBC Driver installed in our machine. we need to handle large number of insertions. So we need the library to support batch insert…
Rocky and Alma Linux
Informix 14.10.xC10 has been certified for Rocky Linux 8 and 9.1! https://ibm-data-and-ai.ideas.ibm.com/ideas/INFX-I-490 Informix 14.10.FC10 has been certified on AlmaLinux 8 and 9.1. https://ibm-data-and-ai.ideas.ibm.com/ideas/INFX-I-526 The idea for DB2 on Alma 8 is not marked…
Problems with ONTAPE
Dear colleagues: I am backing up the database (Informix 7.31 TD6) to tape and disk. Until last week there had been no issues, except that the tapes occasionally slowed down. Today I have found that both the tapes and the copies on disk are very slow. In addition, ONTAPE reached 5…
Replication of a table to another table that is in a sharding environment
Hello community, I have created a replicate of a table between a single instance and the root node of a sharding. When I make inserts to the table of the root node of the shrading, the data is distributed among the participating nodes. However when the data arrives through the re…
Idea - Make SSL_KEYSTORE_LABEL dynamically updatable to match DB2.
Hi, Please vote up idea https://ibm-data-and-ai.ideas.ibm.com/ideas/INFX-I-527 Make onconfig parameter SSL_KEYSTORE_LABEL dynamically updatable. The equivalent has already been done in DB2 https://www.ibm.com/docs/en/db2/11.5?topic=1152-manageability-enhancements ----------------…
Drop sbspace containing a referenceless object?
Informix 12.10.FC14 Solaris 10 1/13 I have a database with an sbspace, and the output from 'oncheck' for that sbspace ( 'oncheck -pe blob_sbs | grep "SBLOBSpace LO" ') is as follows: informix@ifmx-test-jnu> oncheck -pe blob_sbs|grep "SBLOBSpace LO" SBLOBSpace LO [3,3,69884] …
question on genBSON()
Playing around with genbson() to create some JSON output, I have the following query: database sysmaster; select first 10 genbson(ROW(p.dbsname, p.tabname, p.seqscans, t.ti_npdata, t.ti_pagesize), 1, 1)::JSON from sysptprof p inner join systabinfo t on t.ti_partnum = p.partnum wh…
A lot of extents in temp tables
Hi everyone, I have many of tables with high extents what can I do to fix it? Follow attached print ox tables and my dbspaces (onstat -d)…
Logical Logs - Flags and backups
Hi, total newbie here but needing some guidance re: logical logs and what the onstat flags mean, so would appreciate anything to help improve our understanding. Been reading up on what we can, but informix DBA knowledge is a bit thin in this neck of the woods, hence the forum que…
Might be useful to people ....
Working on a recovery project and knocked together a simple page type decoder thing https://www.oninit.com/download/onpagehdr.c Cheers Paul -- Paul Watson Oninit www.oninit.com Tel: +1 913 364 0360 Cell: +1 913 387 7529 Oninit?? is a registered trademark of Oninit LLC If…
How to compile dbdelete utility for utils2_ak file
Hello, Anyone knows how to implement or compile dbdelete utility for utils2_ak file? My computer environment is windows and i have no idea how to compile and apply it into the informix. ------------------------------ nasiha zailan ------------------------------…
varchar index on varchar(255) column
We have a table with approximately 50 million rows that contains a VARCHAR(255), not realizing that there is a max size of 254 when creating an index, we attempted to create an index on the column. It succeeded but seemed detrimental to system performance. So we dropped the index…
Migrating users from OS to DB
Is it possible to migrate >1800 Linux users and their OS passwords to the database so the will be internally authenticated? It is basically easy to create all the users in the DB but the password is more tricky I guess. Best regards, -Snorri ------------------------------ Snorri …
Drop table with no-logging mode
Hi, i have situation where i try to drop table contains of time-series data in production environment with HDR mode. The data is about 200GB. Is there anyone who knows how to do this? I try to delete table with no-logging since my logical logs are insufficient to carry the transa…
Granting Default Role in InformixHQ
I am playing with the new(ish) InformixHQ to determine if it can take the place of the older AGS management software. I have found one mission critical process for us that I don't see anywhere that InformixHQ can do....grant default database roles. I can create database privile…
DIRECT I/O (KAIO) Disabled in RHEL 9
Installing Informix 14.10.FC10 in a new linux RHEL 9 server. KAIO is disabled and I don't know the reason: rpm -qa | grep libaio libaio-0.3.111-13.el9.x86_64 ls -l $INFORMIXDIR/bin/oninit -rwsr-sr--. 1 root informix 28388480 Mar 8 01:38 /home/informix/pdbwic2016_dev/bin/oninit o…
longstanding installation issue
I'm getting ready to install 14.10.FC10 in our dev environment, and confirmed that there still is a weird quirk in the installation instructions. In the README_ids.txt file, there is this: Common installation methods: The commands below describe basic installation methods. The I…
SQLTRACE uid mapping
Two questions: 1. I've used sqltrace for many years but have one area that I can't get clear ... sql_uid mapping to users via sql (not SS, OAT or HQ). I capture via a scheduler task the content of sysmaster:syssqltrace to sysadmin:mon_syssqltrace. sql_uid equates to a number and …
Bad permissions on $INFORMIXDIR/tmp after installing CSDK
I recently upgraded my developer copy of Informix 14.10.FC10 and the matching CSDK. OS is Linux x86_64. Something in the CSDK install process munges the permissions on $INFORMIXDIR/tmp causing the server not to start. This problem has existed for a while, at least from Informix…
Dropping additional chunks from rootdbs
Solaris 10 1/13 Informix 12.10.FC14 Assume that rootdbs has an original chunk, plus one (or more) additional chunks that have been added to the original rootdbs chunk. Further assume that there are zero user objects in rootdbs, but that databases sysuser, sysutils, sysmaster, a…
InformixHQ run script
Hello. I have informix 14 FC8 on windows servers. For some reason the agent sometimes fails on my servers and now I find a way to restart it without manually connecting to those machines. Is there a way by which the TaskSheduler user in InformixHQ can run some kind of script on t…
Community call 15 March 11:00 ET discussion thread
Thank you for your interest in our Community Call series! Continue the conversation initiated in the 15 March 2023 call with your questions and comments below. ------------------------------ Marius Ciortea Community Director IBM Palo Alto ------------------------------…