Threads from 2024
Browse by month: Jan · Feb · Mar · Apr · May · Jun · Jul · Aug · Sep · Oct · Nov · Dec
Update to myschema available!
Folks: I have uploaded an update to my utils2_ak package to my web site ( My Utilities ) with the following change: Fixed the --infrastructure output for PLOG type dbspaces to eliminate free space within the PLOG space that is an artifact of having moved the physical log within t…
onstat Thread priority question
Hi, onstat -g ath | egrep "prty|sqlexec|kaio" tid tcb rstcb prty status vp-class name 14 46559390 0 3 IO Idle 9cpu* kaio 15 466239c0 0 3 IO Idle…
Informix installation issues 14.10.FC11W1 and Version 15!!
Hi, Dave the Destroyer strikes again... Informix installation issues 14.10.FC11W1 and Version 15!! These are on Rocky Linux 8.10 1. Both installation create an instance using the discontinued parameter MIRROR set to 0! attn: Ignoring unknown or deprecated config parameter (MIRROR…
Bug with CSDK 4.50 => V15 server with table having BOOLEAN before TEXT column
Hello, For us and certainly for others, it's strategic that Informix CSDK 4.50 still works with an Informix 15 server (in SMALL tables mode). (Confirmed by John Lengyel in Informix 15 server / CSDK compatibility matrix | Informix ) I have already reported this issue in the other …
Error -25587 using a shared memory connection.
Hello everyone. I was trying to run some heavy Genero 4GL jobs on the DB server via a shared memory connection. Some ran fine but other jobs crashed almost immedately (while in a cursor loop) with error $ finderr -25587 -25587 Network receive failed. A system call has failed. …
User-Friendly External Smartblobs Using a Shadow Directory
Hi All: I don't write here much, but I'm an Informix old-timer. I've worked w/ Informix since RDS Informix 3.3 on an IBM PC-XT. I worked at Informix Corp and IBM for ~20 years back in the day. Coincidentally, I've been here at Actian (a database/integration company) since 2006…
Simple way to run Informix 14 and 15 in parallel
Hello, For development I have both IDS 14.10 and Informix 15 installed on my Linux Debian 12. So far, I have to switch between both versions to do tests. I know it's possible to have more than one instance running on the same computer. I would appreciate if someone points me to t…
How to set SMALL tables option at server config level?
Hello, Reading: SMALL and LARGE tables How can I enable SMALL tables server-wide with an onconfig parameter? I see there is a session parameter SET ENVIRONMENT TABLE_SIZE = SMALL But what if I want to have only SMALL tables? Seb ------------------------------ Sebastien FLAESCH --…
Informix 15 CSDK compatibility indicator
Hello, Since Informix 15 CSDK introduced changes for example in the sqlca definition, I was wondering if there is some way to distinguish at compile time when an ESQL/C compiler V15 or V4.50 is used, so we can maintain the same .ec source code for different versions of ESQL/C. I …
After restore: informix.aus_cmd_info is not in the database
Hello, doing a test cold restore using ontape -r of an informix database instance, version 12.10.FC5 on Rocky Linux version 8.10. The restore runs without any issue, but when I start up the informix process through systemd with oninit it logs the following: 09:57:10 SCHAPI: Star…
ESQL/C 15 and sqlca.sqlerrd[1] for new BIGSERIAL
Hello, Since ESQL/C sqlca.sqlerrd[] is now an int8 array, I expected to get the last generated bigserial in this register, after doing an INSERT. Seems it is not the case... I see a value zero in sqlca.sqlerrd[1] , is this normal? Seb ------------------------------ Sebastien FLAE…
Informix 15 server / CSDK compatibility matrix
Hello, Simple questions: Can I use a CSDK 4.50.* to connect to an Informix 15 server? Can I use a CSDK 15 to connect to an Informix 14 server? Is there some compatibility matrix available? I have just face the following: 1) With CSDK 15 connected to Informix 15 server: CREATE TAB…
RSAM memory pool cleanup
Hello, Our customer is running application which allocates quite a lot of rsam pool, this memory is freed inside the rsam pool – so at the end it shows from onstat -g mem rsam Totalsize is cca 2gb but almost all free as column freesize shows but pool itself is not decreased. Is…
Limit in Informix 15.0.0.0 - "LO_hdr_partn"
Hi, Does the limitation of 16777215 pages in sbspace LO_hdr_partn still exist in Informix 15? Regarding presentations and other information: Some instance objects remain unchanged regardless of the infrastructure version such as ... Internal SLOB space partitions .... And output …
How to restrict access for a user to Informix by IP?
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE AIX 7.1 We have several application servers and LDAP based authentication. How to prevent a user's connections from any but the application servers' IPs? ------------------------------ Sincerely, Dennis -------------------------…
Informix 15 negative rowid values???
Hi, Just installed IBM Informix 15.0.0.0 and started some tests... Can someone explain why we get now large negative ROWID values? sf@toro:/tmp$ dbaccess -V DB-Access Version 15.0.0.0DE sf@toro:/tmp$ dbaccess test1 - Database selected. > create table tab1 ( pkey integer not nul…
V15 installer could not determine supported encryption library
Hello, I am installing IBM Informix 15.0.0.0 Developer Edition on my Linux Debian 12. I have selected OpenSSL as encryption library, and I have: informix@toro:/opt3/dbs/ifx/IDS-15.0.0.0$ openssl version OpenSSL 3.0.15 3 Sep 2024 (Library: OpenSSL 3.0.15 3 Sep 2024) And I got this…
InformixHQ H2 existing database encryption
Hello Can be h2 database encrypted after it was created without encryption and InformixHQ configured? Or it should be created encrypted as an empty db? Thanks for tips. Milan Rafaj -- Unless stated otherwise above: Kyndryl Česká republika, spol. s r. o. Sídlo: V Parku 2308/8, Cho…
IBM Informix CSDK licensing
Hi all, IBM ILMT detects IBM Informix Client SDK 4.50 installations and identifies the licensing metric as " Authorised User Single Install", however I am pretty sure there has never been the possibility of purchasing a licence nor a requirement to keep a record of installations …
Is it possible to turn an informix 12 developer edition into a workgroup edition?
Hello Guys, I have an Informix developer edition database running here. We have now bought an original Informix workgroup edition 12.10 license to get rid of the 8 GB disk space limitation of the developer edition. Is it possible to convert the developer edition to a standard wor…
Where to report bugs for Informix 15
Hello, Sorry it's unclear to me where I should report bugs... (we found one with HCL Informix 15 CSDK) On https://support.hcl-software.com , I can't find "HCL Informix" in the product list... only OneDB ... We detected a defect in the ESQL/C libs when using a CONNECT TO with USER…
Where to download Informix 15 server AND CSDK 15?
Hello, Sorry for this stupid question but where can we download the IBM brand of Informix 15 server and CSDK 15? We found packages of Informix 15 server packages in the Fix Central, but we find no CSDK 15 ... Tx! Seb ------------------------------ Sebastien FLAESCH --------------…
Informix and MinIO backup without encryption
I am trying to set up an S3 backup for Informix 15 following this guide: https://www.ibm.com/docs/en/informix-servers/15.0.0?topic=cb-back-up-amazon-simple-storage-service-using-bar-psm To follow this guide, you must create a credentials file. This creds file requires a specific …
New RFE to request PDF Informix v15 manuals!
Please vote for INFX-I-651 in the RFE site or INFX_I_652 in the Ideas site: Informix v15 PDF Manuals Ibm remove preview Informix v15 PDF Manuals View this on Ibm > https://ideas.ibm.com/ideas/INFX-I-652 ------------------------------ Art S. Kagel, President and Principal Consulta…
Cannot change the Expected Number of Concurrent Users during installation (IFX 15)
I have been trying to install the Developer edition of Informix 15 (INFM_DEV_V15.0_LNX_X86_64.tar). I am testing the console installation wizard. When I want to change the Expected Number of Concurrent Users , during the installation I stuck in the loop. ... =====================…
Used memory not showing as expected.
Dear All, We have a INFORMIX 14.10.FC11 instance and it runs on Redhat 9. We have allocated 7722628KB memory for INFORMIX ( e.g onstat - ) . The system memory is 16GB approximately. Pl. see the 'onstat -g osi' and top output of this server. We have taken those outputs when there …
Certificate expired ....
Hi all, I am not sure who can take care of that, but the IBM download server iwm.dhe.ibm.com has an expired certificate (valid until Sep, 4 2024). Since they jave a HSTS policy, the certificate error cannot be ignored. This is where I am redirected to when using the MRS tool ... …
Updates to my utilities package offerings.
I have uploaded an update to utils2_ak that contains an updated release of myschema that includes full support for v15.0 databases. All utilities in the utils2_ak package are v15 compatible! If you recently downloaded utils2_ak and are considering upgrading to or at least testing…
Problem installing IDS v15.0.0.0 on Ubuntu 24.04
Base Developer Edition installer run in console mode as root. Java v11.0.25 installed. Lots of added fonts. Here is the tail end of the install output: [==================|==================|==================|==================] [------------------|------------------|-----------…
High CPU across all Informix processes
Hi all, in the past few days we've encountered a situation where we see Informix run high CPU across all assigned CPU cores (16) for extended periods of time (up to 2 hours). When we run TOP it shows all the oninit processes running at ~97% while user sessions etc. are only runn…
Informix 14.10.FC10 onload error occurred: ISAM error: illegal argument to ISAM function. Error building TBLspace.
Informix 14.10.FC10 onload error occurred: ISAM error: illegal argument to ISAM function. Error building TBLspace. After testing, it was found that the reason is because the MAX_FILL_DATA_PAGES parameter is set to 1. If it is set to 0, no error will occur. Even if the DB is empty…
Informix 14.10.FC10 onload error occurred: ISAM error: illegal argument to ISAM function. Error building TBLspace.
Informix 14.10.FC10 onload error occurred: ISAM error: illegal argument to ISAM function. Error building TBLspace. After testing, it was found that the reason is because the MAX_FILL_DATA_PAGES parameter is set to 1. If it is set to 0, no error will occur. Even if the DB is empty…
IBM Informix v.15 is released
After wrestling with some last minute IBM Release gremlins, IBM Informix v.15 is released as of today. From the announcement " We are excited to announce that Informix 15 is now available with its unparalleled scalability for the modern data-driven world. This latest release brin…
Issues with CSDK 4.50.FC11W1
As many of you know, starting around IDS14.10.FC10W1 / CSDK4.50.FC10W1, Informix stopped working for many SSL connections because the Informix libraries weren't working correctly with newer versions of CSDK. If I'm not mistaken, and GSKit newer than 8.0.55.26 would break, giving …
Informix 15 is out! Well sort of...
Hi, Well Informix 15 is out..sort of! https://www.actian.com/blog/databases/hcl-informix-15/ "We are thrilled to unveil HCL Informix® 15" https://en.wikipedia.org/wiki/Informix So we have IBM Informix HCL Informix HCL OneDB So where is IBM Informix 15 then? HCL had their's out 2 …
RFE: Add details when syspurge fails
I've submitted RFE INFX-I-630: Give ISAM/tabid when | IBM Data and AI Ideas Portal for Customers Give it a vote if you think it's worthwhile. ------------------------------ TOM GIRSCH ------------------------------…
Informix HQ v3.0.0
Hi, Searching for Informix 14.10.FC11W1 i found Informix HQ v3.0.0 available and downloaded this HQ version. I went through the README files and it states that if you are already running Informix HQ v2.3.4, which is the version we have, then no upgrade special procedure is requir…
logical, physical & temp chunks location
Hi DBAs, We have legacy Informix database and I am unable to figure out dbspaces & their respective chunk names along with full pathname. Please help me with a query to find the above or any onstat command. Thanks in advance. Syed ------------------------------ Syed Hussaini ----…
MONEY(32) without scale as result of a numeric expression involving two MONEY(P,S) values?
Hello, Normally, an Informix MONEY(P) always gets a scale and cannot be a floating point type like DECIMAL(P). We have discovered that the data type resulting from a numeric expression using MONEY(P,S) produces a MONEY(32) as floating point MONEY. Is this a feature or a bug? The …
IBM.Data.Db2 - not fully supports Informix
Hello, according to offical docs I am using the IBM.Data.Db2 Nuget Package to connect my .net Core Application to Informix Servers, all in all this works, next to some little drawbacks like issues when using short variables in Query, but that was okay, as long as I had a way to f…
Updated utils2_ak package available
Folks: I just uploaded an update to the utils2_ak package to my web site ( My Utilities ) that contains an update to myschema: Fixed handling of NOT NULL constraints with FILTERING! Thanks to David Grove for identifying the issue and JC at HCL for pointing me at the solution! FYI…
Informix HEXTORAW function
I don't see a builtin but should be a trivial UDR. I've written a few UDRs to mimic Oracle builtins Cheers Paul…
Java jvm update
Hi Our IT sec reported us a vulnerability warning about the jvm which is in the $INFORMIX/jvm directory. Our Informix version is 14.10.FC10W2X3. Current Java version is 8.0.7.0. The IT sec warning based on IBM Security Update November 2023 advisory. Recomanded java 8.0.8.15 Can w…
Issues with installing CSDK in Docker container to deploy in GCP
I'm trying to set up a data pipeline from our IBM Informix database to GCP Bigquery. For that purpose, I have been trying to install the ODBC driver (within CSDK) in a Docker image to deploy the container later in Google Cloud Run Function. I am stuck in the Dockerfile developmen…
Good News - Informix 14.10 runs at MacBook Apple Silicon CPU M* - More at TXC Oct. 22. 11:30 PM
Hi Informix folks, we found a cool and serious way to set up and run full Informix 14.10 with shm and tli connections at MacBook with an Apple Silicon M* CPU. My credit on this is to our Senior Developer Jozsef. Come and watch my presentation "Informix for watsonx - your way into…
Informix 14.10 FC11 WE on Red Hat 9.4 X64 - ids_install issues
Hi, I'm installing Informix 14.10 FC 11 WE as root on Red Hat 9.4 with Oracle JREJava 1.8 ( jre-1.8.0_421-oracle-x64 ) but the installer is encountering errors during installation (errors below from ids log) seems an issue with the JRE, also the Informix instance that is created…
12.10.FC15W1AWE Blocked in LONGTX
Hello everyone. How is it possible that 12.10.FC15W1AWE gets Blocked on LONGTX? DYNAMIC_LOGS is set to 2 but the engine was not adding any new logs (although there was more than enough space in ROOTDBS.) onmode -ky was impossible (it just hung) so rebooting the server was the on…
Issues with Integrating IBM Cloud Services into a Packing Website
Hello IBM Community, I'm currently working on a packing website that involves extensive logistics and inventory management. I'm trying to integrate IBM Cloud Services to handle our backend operations, specifically for managing data flow between our packing, storage, and shipping …
Optimization Suggestions for IBM Cloud Services with Drone Data Processing (Drone with Camera 4K)
Hi IBM Community, I am currently working on a drone website that primarily focuses on high-definition aerial footage, particularly from drones equipped with 4K cameras. We aim to process and analyze large volumes of video data captured by these drones with camera 4K . Given the n…
Detecting an exploited bug in 4GL Code
One of our clients is in a quandary as to how to determine where a compiler bug was exploited in about 2million lines of 4GL (their count... I haven't checked) Apparently there was a bug in Informix 4GL 7.50.FC5 whereby, under very unique circumstances, evaluation of a null value…
Creating index stuck forever on an ipl thread
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE A CREATE INDEX statement stuck forever with 'join wait' status. A thread that it was waiting for was named 'ipl'. Its read/write counters were still. Terminating the session got nothing. To abort the dead wait, `onmode -kuy` was…
"Pool Summary" versus "Blkpool Summary" in "onstat -g mem" output
Could someone explain the distinction between these two sections? It's become relevant to a support case, and I can't get a useful answer from the documentation or first line support. For example, on an example idle system, there are just two entries in Blkpool Summary. Showing t…
onsmsync and TSM
Hello, Using TSM to backup Informix (v11.10). I was hoping to do expiration with onsmsync only so configured TSM copygroup to keep things forever unless expired: verexists=nolimit verdel=0 retextra=nolimit retonly=0. I did onsmsync testing and noticed: -It expires backups as expe…
LOB error on a table w/o any blob
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE We have a rather weird error on UPDATE STATISTICS, UPDATE STATISTICS HIGH FOR TABLE ord_l_2 ( c_deliv,deliv_printed,notif_id,ofd_id,ord_id,ord_l_id,pp_status,status_req,time_deliv1) ; 9810: Smart-large-object error. 12014: Smart…
DB/4GL error 1809 from OPENLDAP
Dear Friends. We have 1 OPENLDAP Svr VM ( slapd 2.6.6 (Jul 26 2024 00:00:00) ) for USER management and 2 Clients VMs. One client for INFORMIX DB server ( 14.10.FC11DE ) and other for INFORMIX 4gl ( 7.51.FC3 ) APP and all are having the same REDAHT OS 9. LDAP Authentication fro…
Message:-9272 SQL State:IX000 Unknown error message -9272.
I'm having an issue with our product code running on AIX 7.2 and using CDSK 4.10.UC16W1 to access Informix 14.10 running on RHEL 7. The code successfully connects and issues a rather long SQL statement, that contains many data types. The error returned is: Message:-9272 SQL State…
How to manage Informix optimizer?
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE After daily routine UPDATE STATISTICS a simple query changed its plan, and executes in 5+ sec instead of 0.015: SELECT ret_ban.* FROM item_k_pr, ret_ban WHERE ret_ban.pr_num = item_k_pr.pr_num AND ret_ban.pr_value = item_k_pr.va…
Informix DB2Connection Implicit Transaction
Hello, I'm having a strange issue with a particular use case of the DB2 Informix (DRDA) connection. Looking for suggestions on how to fix or work around. Our code base is C# .Net and we moved to the DB2 driver to avoid some SQLI issues we were having post .Net 4.5 or thereabouts…
onload utility runtime performance issue
Hi We have a problem with the onload utility runtime. We performing a full database load with onload. (the db is ~800 GB). Currently the onload was executed more then 80 hours. I think there is a performance issue. How can I improve the runtime for the onload utility? Adding more…
Informix restore strategy
Hello, I have to prepare restore plans for our legacy Informix system, and I'm new to Informix. In hardware failure case everything is clear - we lose dbspace/chunk, so we restore whole dbspace. In user mistake case things are confusing to me - in other RDBMSes if we lose databas…
onaudit: precision of datetime of audited events?
IDS 12.10.FC14 SOLARIS 10 1/13 The onaudit utility creates audit trail files, as documented here: Audit-record format The second field is the date and time of the audited event. I have enabled auditing with onaudit, and observe the audit trail files, and see that all the timest…
Removing Instance from "onstat -g dis"
Hi Folks Informix 12.1 latest fixed pack AIX I've moved all tghe file related to the instance, but still listed under "onstat -g dis". How could I get rid of it? ------------------------------ Ali Shahnazi ------------------------------…
Defragment sbspace
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Please, how to defragment (repack) a sbspace after plenty LOBs been deleted? ------------------------------ Sincerely, Dennis ------------------------------…
RSS Failed recover
Hi I have HADR set in placed which had stabled since past 2 years. Recently there was IP change in our Prod nodes Pri and Sec. Prior changed we have tested to make sure all nodes including DR able to communicate as usual. All good to go. Unfortunately once changed, the RSS not …
SQLCODE gets access violation
Hi, I'm using CSDK 4.50.UC.11 on Linux to access Informix 14.10 (64-bit) that is running on the same Linux VM. Here's the code: /* * EXEC SQL CONNECT TO :Did AS :Cid USER :Uid USING :Pid WITH CONCURRENT TRANSACTION; */ { ifx_conn_t *_sqiconn; _sqiconn = (ifx_conn_t *)…
RTRT - Rationale test real time
Hi Team, I have a question related to the parameter from the below function -------------------------------------------------------------------------------- static float ComputeFactor(float IAS, float Alt, float Temp) { float dpp, mach, last, p, speed_of_sound, TAS; if (Alt< -10…
ids onconfig
When creating a new instance should there be reset to 0 RAS_PLOG_SPEED RAS_LLOG_SPEED ------------------------------ Rob Kottler ------------------------------…
#Informix, where can I find some examples how to use on* commands
Hello all, I'm new here and new with Informix administration. I search for some examples how to use the on* commands. Esspecially to create chunks with onspaces. can somebody help me with a link to some tutorials? the IBM original documentation isn't helpfully. I didn't understan…
Large memory segment vs smaller ones
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE What is better, one large memory segment or several smaller ones? For now, we have the following, Segment Summary: id key addr size ovhd class blkused blkfree 87031833 52564801 700…
"Bad file number" for an UPDATE command
Hello, Suddenly, without changing the config, OS upgrade or so on (as far as I know) I started receiving an error for one specific SQL. The command is: UPDATE evuknor SET preveden=1 WHERE evuknor.preveden=0 AND EXISTS (SELECT 1 FROM vestnik WHERE evuknor.vestnik=vestnik.vestnik A…
dbaccess starts eating 100% CPU when terminal session closed abruptly on RedHat
Hi everybody, When running dbaccess (in interactive menu mode) on RedHat, if you just close the putty terminal window abruptly, dbaccess process keeps running and using up 100% CPU. Top output shows: The process hierarchy survives pending from process with pid 1,(init) and with n…
Inconsistent dashboard performance for different users
Hello All, I have built a dashboard in Cognos, in the preprod environment I see the standard look of the dashboard and the filters. However when the dashboard along with its underlying data source which is a csv file and a widget was migrated to production the look of the dashboa…
Reuse ER spaces
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE We have some ER settings in onconfig as legacy. CDR_EVALTHREADS 1,2 CDR_DSLOCKWAIT 15 CDR_QUEUEMEM 4096 CDR_NIFCOMPRESS 1 CDR_SERIAL 0 CDR_DBSPACE CDR_QHDR_DBSPACE edr_dbs0…
shared memory not initialized for INFORMIXSERVER but Server is online!!
Hi all, I inherited the management of a windows server 2019 with informix server 10. Informix server is active and correctly configured and working but from the instance.cmd prompt with any user (even informix) the onstat, oninit etc commands all respond "shared memory not initia…
Créer une sauvegarde ontape en multifichiers
Bonjour, La sauvegarde actuelle par ontape -s -L 0 > toto -t STDIO me donne un fichier proche de la taille limite de la partition et donc un probleme en vue. Il ne m'est pas possible de modifier la taille de la partition sur ce serveur, seulement utiliser une autre partition en c…
Dates and times for Sessions at TechXchange?
I cannot see any dates or times in the Session Catalog for TechXchange 2024...does anyone know where I could find those? Tom Ross ------------------------------ Tom Ross ------------------------------…
Unlocking the Power of Advanced Neural Networks: How TopneunetAI's Data-Driven Activation Functions Enhance AI Performance with Input Data
As deep neural networks continue to evolve, the integration of data-driven activation functions in IBM's time series AutoAI deep neural networks represents a monumental leap forward. TopneunetAI understands the critical importance of these functions, likening them to the digital …
HDR Issue
Hello All, I'm doing Informix HDR setup in personal laptop with using vmware. VM - Oracle Virtual Box Linux - RHEL 7.9 IDS - 14.10 I create two virtual machines and accessing those machine using putty in windows. Looks I am missing something in Informix configuration side, As I c…
Informix 12.10FC Migration to RedHat 8
Hello DBAs, We plan to migrate IDS 12.10FC onn AIX 7 to RedHat 8, I have a question: Please let me know if there be any change in any of the parameters in onconfig file for linux 8 after or during migration? Thanks in advance ------------------------------ Syed Hussaini ---------…
Process ended with network broken errors
Hi Support We received a complaint from users claim that their application process ended with network broken / failure while through out monitoring there is no network intermittance. Here few errors inside the application logs : Program error at 'lib_gen.4gl', line number 3124. S…
SESSION_LIMIT_MEMORY
Hi All, I have SESSION_LIMIT_MEMORY set and I'm trying to find out what sql the session was running just before the engine terminates it. On occasion, we encounter a session with high memory usage. I've tried alarmprogram but seems engine terminates the session prior to hittin…
Moving the location of the values inside the filter dropdown
Hello I am building a dashboard in IBM Cognos 11.2.4 version where I have a requirement to move the value LESS THAN 1.0 at the top of 1.0-2.0 inside a filter dropdown, the filter has been created using dropdown list is there any way I can do it ? Please find the attached screensh…
Blue Pages API
Hi Team , Where can i find Blue Pages API .Thanks ------------------------------ SENDHIL KUMAR THANGARAJ ------------------------------…
My database is relational, but my developers want to use NoSQL! Webinar
Summary JSON and other semi-structured data formats present unique challenges for organizations. What to do to integrate semi-structured data with existing structured relational data? Informix is the solution. Webinar agenda: Introduction to watsonx.data and its Integration with …
SQL/SPL Editor apps
Hi I'm looking for an application on windows for our dev team, which can handle execute SQL, create SPL/triggers, load /unonload data. Bonus if it can open the source text files and login to database from command line. (Because we have to preper our SPL-s source code file before …
Changing DBSPACETEMP run-time
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Please, is there a way to change DBSPACETEMP for a session inside 4GL? ------------------------------ Sincerely, Dennis ------------------------------…
Recommended options for setting up SDS in a Linux environment
Hi, IBM documentation introduces the following software and file systems as options for setting up SDS. https://www.ibm.com/support/pages/what-options-are-available-shared-disks-sds-ids * Cluster Software IBM HACMP HP ServiceGuard Sun Cluster Veritas Storage Foundation Red Hat Li…
Informix 14.10.xc11
Hi Folks, there is a new Informix Server Version 14.10.xC11 on fixcentral - but there is no fixlist, no what's new etc... So the question is, what is new, what is fixed ? When will jdbc and csdk 4.50.xc11 is available... ? Cheers, Markus ------------------------------ Markus Holz…
sysadmin DB relocation
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Please, how to relocate sysadmin database from rootdbs to avoid rootdbs overflow during SQL tracing? ------------------------------ Sincerely, Dennis ------------------------------…
Memory block header in pool 'rsam' corruption
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE We got 5 occasions of memory block header corruption in less than 2 hours, all in pool 'rsam'. Two of these occasions generated AFs that emerged in online.log. And these 2 occasions appeared simultaneously with dbs_partn mutex c…
Error -25546 in connection manager 4.50.FC10
Milan Rafaj Unless stated otherwise above: Kyndryl Česká republika, spol. s r. o. Sídlo: V Parku 2308/8, Chodov, 148 00 Praha 4, IČ: 096 28 886 Zapsaná v obchodním rejstříku, vedeném Městským soudem v Praze (oddíl C, vložka 339277) Registered address: V Parku 2308/8, Chodov, 148 …
CSDK installation on Docker linux container (.NET 8)
Hi! Our company are providing Informix maintenance for our client and for a while we started developing microservices using .NET Core. At this point of time we have service that acts as Informix connector. That service is working using .NET 7 docker image ( mcr.microsoft.com/dotn…
How to set up DBSA role or equivalent
Dear All, Informix 14 on Hp-Unix Need to restrict the usage of "INFORMIX" user Id by DBA's. Is DBSA role a good option and can someone help me with how to use it. I checked the documentation but could not figure out myself. Regards, Vikas H ------------------------------ Vikas H …
Call API from INFORMIX 4GL
Dear All, Can we call JAVA/PYTHON API from INFORMIX 4GL new versions? Thanks! Best Regards, Indika ------------------------------ Indika Jinadasa ------------------------------…
Update SMALLFLOAT Larger Than -1.175494351E-38 Works?
According to multiple sources, the ranges of a FLOAT are: Positive numbers: Min Value: 1.175494351E-38 and Max Value: 3.402823466E+38 Negative Numbers: Min value: -3.402823466E+38 and Max Value: -1.175494351E-38 Given that, why can I successfully insert into an Informix SMALLFLOA…
Informix TechTalk: Exploring the Informix Sysmaster Database
Folks, I will be doing the next Informix Tech Talk. Next Informix TechTalk: Exploring the Informix Sysmaster Database by Lester Knutsen Date: Thursday, August 15, 2024, 2:00 pm EST Description: Lester Knutsen will present his Informix Sysmaster Scripts for monitoring and performa…
Informix install and configuration on Google - GCE
I need to do a POC with Informix on GCE to migrate (lift and shift) one of our small database's that is running on AIX / Informix 9.4. I do not see a lot of or any information about installing and setting up Informix on GCE. Has anyone tried this and have some tips and tricks? Th…
webcast of V15 presentation replay?
Hi Folks, I hope everybody is doing well. I was just wondering whether there was a replay of the V15 presentation a few months ago ? Is there any available URL ? Thanks bunches Eric ------------------------------ [eric] [Vercelletto] [] [Founder] [kandooerp.org] [Pont l'Abbé] [Fr…
Informix.Net.Core.dll 64bit
Hey, I am using the Net.Informix.Core.dll to connect my C# Application to the Informix Database, all in all this worked pretty well. But when I published my application to Windows IIS I got the error that I am having a badFormat dll, after researching all my dlls I noticed that t…
Duplicate DBSERVERALIAS
Hi, The Admin's Guide declares, Each database server across all of your associated networks must have a unique database server name. Nevertheless, our primary and RSS are sharing the same name in DBSERVERALIASES. What is a risk of having duplicate dbserver names? BTW, online.log …
ALTER TABLE Error #106: non-exclusive access
Solaris 10 1/13 Informix 12.10.FC14 I have an SQL command file which contains a couple thousand ALTER TABLE statements to create table constraints. It was generated by Art's myexport utility. I copied the intended database (a production database) to another instance for testin…
C++ SDK Thread Safe Connection
Hi, I'm developing an application multi-thread that needs to connect to an Informix DB. I'm working with the CSDK 4.50 and c++ libraries. I'm encountering issues with the connection. I didn't find the way in which initialize a different connection for every thread. here a simple …
C-UDR reusage of prepared statement
Hello community! I need to provide a UDR which internally would need to execute the same statement with one parameter for each invocation. This suggests the usage of a prepared statement. The documentation for this topic is very unclear, but i thought i managed to understand how …
Informix JDBC driver cleanup bug - memory leak
I have a problem when hot deploying our Java service to Tomcat, when the app is restarted getting the following WARNING: 07-Jun-2024 14:18:12.815 WARNING [Catalina-utility-1] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [dashboard] a…
Vote now for : Multi Vector database functionality as Database Extend to Informix ( INFX-I-612 )
We discuss during the leolo Mastermind Conference that will be an exceptional feature if Informix 15 has a Multi-Vector Database functionality (like Milvus). May an additional functionality like time-series or as datablade like geospatial and text-search or as part of the core ma…
LIMIT clause not allows in WITH ... (Common Table Expressions) ?
Hello, Is this a bug or expected limitation? SQL statements should be self-explaining... /* WORKS */ SELECT log_ordinal FROM dbsync_log WHERE log_table_name = 'stkitem' ORDER BY log_ordinal DESC LIMIT 10 ; /* FAILS */ WITH recent_rows AS (SELECT log_ordinal FROM dbsync_log WHERE …
Inspect transactions log
Hi. We use INFROMIX 14. Yesterday we discovered that there was no record in the database for one operation for May 27, in the software logs this operation was completed successfully, but in the database it was completely missing, as if it never happened. Is there a way to see if …
DataPower Backup
Dear Team, We have a DataPower : IDG.2018.4.1.10 , and we want to know how to do an automatic backup for every domain? where the backup is downloadable? also , we have an appliance in DR , we need a way on how to sync the HQ with DR ? Best regards, ------------------------------ …
Is it possible to import the copy made with ontape from one database to another PC?
Dear All: I'm asking you about this because I made a copy of an Informix server with ontape to import it into a PC for convenience and security reasons (avoid working with real data). On the PC I installed Informix 7.31 TD6 for Windows, which is the same version as the server, I …
DB Access for Active Directory users
Hello We are running Informix 12.10 on Linux server and Server Admins joined this server to Domain using samba and winbind for active directory authentication. Now we have requirement to create application users with AD authentication in database. Also users are able to connect s…
Load progress - raw tables
I used to know this, but I'm getting old....whilst loading a raw table how can I watch the progress re: num rows? onstat -g pqs doesn't help, nor does select count(*), etc. I know why the normal methods don't work internally - just wondered if anyone else remembers how? Thanks! M…
Next IIUG TechTalk:
Migrating Databases Under the Worst Conditions – with Fail-back! by Art Kagel Date: Thursday, May 16, 2024 Time: 2:00 pm EDT ••Challenge Migrate a large database to the cloud over slow and unreliable WAN connections. Maintain fail-back strategy: – Keep the target database in sync…
Replicate not starting
Good day I have Replicates that's inactive and when i try to start them it gives invalid replicate change. It is not on all servers just 2 or 3 servers but on other servers it's active. I'm I missing something ------------------------------ Jaco Loots ----------------------------…
Modifying Terminal 3270 View Properties
Would it be possible to adjust the settings of the RPA terminal emulator 3270 in RPA Studio to display 43 lines by 80 columns instead of the current 24 lines by 80 columns, as this default setting obstructs viewing the entire screen required for automation? how can i do it ? ----…
Datalakehouse implementation
Hello everybody! Anyone here with experience implementing a DataLakeHouse using watsonx.data? #watsonx.data ------------------------------ Alexandre Filgueiras Costa ------------------------------…
ほぼテク4月13日もう損したくない！ChatGPTによる経費精算規定の効率化術
ほぼテク4月13日もう損したくない！ChatGPTによる経費精算規定の効率化術 「一撃でわかる！逆説的に効果的な経費精算規定の作成法」では、ChatGPTを活用して経費精算規定を効率的に作成する方法を紹介します。AIを用いた規定作成のメリットや具体的な設定手順、成功事例まで、初心者でも簡単に理解できる内容で解説。財務効率化を目指す企業の経理担当者や経営者に最適なガイドです。 www.growth-japan.com/blog/it-daily-brief-2024-0413 #ChatGPT経費精算 #AI規定作成 #経費精算効率化 #経理自動化 #Ch…
commands not working after moving to smb3
Hi All, We were having filesystem exports from windows fileshare mounted on datastage aix server with cifs protocol, but due to hardening policy cifs was disabled and we then mounted shares with smbc protocol, but post that we started receiving failures in jobs as some commands s…
Migrating BLOBs to the filesystem
Hello everyone. We have a table with a BLOB column and It's size is spiraling out of control. As it stands 90% of the database space is consumed by this one table. It is also impossible to dbexport the database in a timely manner because an unload of this single table takes more …
Connect to legacy Informix Server using .NET Data Provider
I am creating an IfxConnection to connect to the legacy Informix server IfxConnection con = new IfxConnection ( "Host=localhost;Server=myserver;UID=user;Pwd=pswd;Service=9088;Database=sysmaster" ) Connection string with this set of parameters was working with some old Informix CS…
Webinar: Learn to Build with GenAI - IBM Prompt Engineering Fundamentals
Data Management Community! There is still plenty of time to register for our upcoming webinar IBM Prompt Engineering Fundamentals on April 30th. Join this webinar and discover the secrets to crafting compelling prompts that unlock the true potential of AI systems. This webinar se…
Informix using UFS vs vXFS on Solaris or Linux?
Hi, Last time I had problem with corrupted file system on Solaris/Veritas using UFS, there is some suggestion to change from UFS to vXFS I guess it is easier to administrate the cluster. I did some search and found a lot written about using vXFS for databases or other application…
fix pack: IIF.12.10.FC16W1
Checking on passport advantage for fix packs for Informix 12.10 on HP Itanium I get: fix pack: IIF.12.10.FC16W1AWE.hpia64 fix pack: IIF.12.10.FC16W1ADE.hpia64 What are the differences between those 2 fix packs? Best regards, Luis Marques ------------------------------ Luis Marque…
Question of dostats
Hi, Art, We use Dostats to update stats daily. The basic steps of the cronjob are, Step 1) update statistics low drop distributions Step 2 ) dostats -d mydatabase Question, Is step 1 (drop distribution) needed before running dostats? Thanks Frank…
ほぼテク4月4日逆マッチョ革命！最速で体型変化を実現するChatGPTトレーニングプラン!
ほぼテク4月4日逆マッチョ革命！最速で体型変化を実現するChatGPTトレーニングプラン! 「逆マッチョ革命」で、ChatGPTの力を借りて体型を変えましょう！最速でスリムで柔軟な体を手に入れる方法を解説。パーソナライズされたトレーニングプランで、健康と幸福感を向上させるための実践的アドバイスを提供します。 www.growth-japan.com/blog/it-daily-brief-2024-0404 #逆マッチョ #ChatGPT #トレーニングプラン #ボディトランスフォーメーション #パーソナライズトレーニング #健康とウェルネス #ライフス…
HDR to Standard
Hello, We have an HA array with primary, HDR, RSS We'd like to disconnect the HDR and make it standard But depends on this doc the condition is: Database server type can be changed from secondary to standard only if HDR is turned off on the secondary database server. HDR is turne…
Relication Issue
Good day I have run in to this issue with replication on Informix. I'm trying to delete a replicate on all the Informix production servers (9 in total). It deletes on 7 servers but on 2 servers it says it has a shadow replicate. Now i can't find the shadow replicate if i display …
IBM Survey of Informix users's platforms
If you have not done so already, please complete this VERY SHORT survey. Here's the link: https://www.surveymonkey.com/r/QCKHRFV Thanks to the many who have already filled out the survey. ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database…
Best Practice for the inplace change from raw devices to cookfiles
Hi Informix DBA's, what's your best practice experience in replacing raw devices with cookfiles in minimum downtime? Mirroring, ER ...? Thanks for every idea. Henri ------------------------------ Henri Cujass leolo IT, CTO Germany IBM Champion henri.cujass@leolo.com -------------…
Informix Online Documentation?
Is there a known problem? When I try to access it, I am getting no response when I try to drill down to any detail for any topic listed on the left. I tried HCL, too. Get "page not found" when trying to navigate to most commands. A few days ago, I had a response from a tech sup…
Reserved page size in rootdbs
Hi I'm looking for some information about the Reserved pages size calculation method. Our customers upraded/upgrading to 14.10FC9 or 14.10FX9W1 and we want to eliminate the risk of data loss. IT45318: POTENTIAL FOR DATA LOSS OR INDEX PROBLEMS IN TABLES LOCATED IN ROOT DBSPACE WHE…
PRI/HDR/RSS logical recovery from logical log backups using PSM
Hi all, My customer plans to backup MACH11 cluster using PSM. What procedure should be used if secondary server requires logical logs from "tape" using onpsm/onsmsync? Is it possible to export/import only logical logs from PSM using onsmsync or onsmsync -E -p xxx to export backu…
Standard Engine 4GL still available or not?
Hi all, Is the Informix Standard Engine still available or not? If not, what is the nearest thing to it available today? I would like to do some 4GL programming - where can I get a system which allows this? TIA and rgs, Paul... ------------------------------ Paul Linehan --------…
ほぼテク2月29日ChatGPTの隠された機能！？あなたの文章をもっと個性的にする口調変更
ChatGPTを活用して多様な口調の文章を作成する方法を解説します。読者とのコミュニケーションを深める「口調変更」機能の魅力と、それを活用することでどのように文章の影響力を高めることができるのかを紹介。公式文書からカジュアルなブログまで、あらゆるニーズに応えるChatGPTの使い方を初心者から上級者までわかりやすくご説明します。 www.growth-japan.com/blog/it-daily-brief-2024-0229 #ChatGPT文章作成 #口調変更活用法 #読者コミュニケーション #文章の魅力引き出し方 #ChatGPT活用例 #コンテ…
ほぼテク ChatGPTとPythonのModuleNotFoundError！？スムーズな開発フローのためのテクニック
Python開発中によくあるModuleNotFoundErrorの悩みを即座に解消。ChatGPTを活用して、Pythonプロジェクトのエラー解決と効率化を実現する方法を紹介します。初心者から上級者まで、すべてのPython開発者がスムーズなコーディング体験を享受できるようになります。 www.growth-japan.com/blog/it-daily-brief-2024-0223 #Python開発 #ModuleNotFoundError #ChatGPT活用法 #Pythonエラー解決 #プログラミング効率化 #Pythonライブラリインスト…
Informix V15 and better GLS: What about char length semantics?
Hello, GLS improvements have been mentioned during yesterday's presentation about version 15. Several years ago, we suggested to have proper Character Length Semantics (CLS) support, like in other DB engines. Will there be an improvement in this area? Without CLS, it makes charac…
Removing Limits in Release 15
Hi Family. I just finished watching the seminar on release 15. Surprisingly short; Carlton usually manages to fill in the full hour. Also, I could not see where where typed questions were being answered. But all that aside: One question I posted... Well, a bit of a preface: Befo…
SQL command identification/source
I am involved in the operation of a large multi-user system with hundreds of users. The application code is written in Java and Infomix 4gl. I am able to monitor the current traffic and identify possibly suboptimal SQL statements (e.g. using onstat -g ...). However, I often have…
Archecker dumps a core
Hi, Testing archecker to restore a table, I encountered a bug, I believe. A command file is as follows, SET WORKSPACE TO dbs17; RESTORE TO CURRENT WITH NO LOG; DATABASE bluebird; CREATE TABLE bank_st_l ( bank_st_l_id SERIAL NOT NULL, <... more columns ...> ) IN dbs10; DATABASE el…
Support for ON DELETE SET NULL and ON UPDATE CASCADE clauses in FOREIGN KEY statements
New RFE: https://ideas.ibm.com/ideas/INFX-I-603 Please vote! ------------------------------ Doug Lawry Oninit Consulting ------------------------------…
alter table modify lvarchar column length report -136 ' no more extents' error
Hi, experts: I execute the 'alter table table-name modify pexp lvarchar(4096) ' ,the table has about 80M rows, and informix report below errors. 222: cannot write to temporary file for new table 136: ISAM error : no more extents my IDS version is 11.5, the dbspace page size is 4K…
Have latest versions of Informix been officially released yet?
Accord to this IBM technote: https://www.ibm.com/support/pages/node/7114124 which has a date of 11 March 2024, updates for 12.10 and 14.10 should be available. "The APAR is fixed in these releases: 12.10.xC16W1 14.10.xC10W2" The download links point to IBM Fix Central. Informix S…
INT to SERIAL in-place alter
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE My question is, why MODIFY INT to SERIAL does not use in-place alter? ------------------------------ Sincerely, Dennis ------------------------------…
Restoring a table to PIT with archecker fails
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Trying to restore a table to PIT I get an error, AC_RESTORE_FILTER is set. Must do physical restore only. CRITICAL ERROR: Unable to initialize extraction With adding either '-lphys' or 'RESTORE TO CURRENT WITH NO LOG' I manage t…
Information for IBM IDSX EOS
Dear All, Kindly help me to find the IBM INFORMIX product lifecycle-dates similar to HCL/INFORMIX which they have already shared in the following URL ? https://communities.actian.com/s/supportservices/lifecycle-dates/onedb-hcl-informix-lifecycle-dates Thanks ! Best Regards, Ind…
What units do 'buffers' use in BUFFERPOOL?
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE I'm a little bit confused with measurement of buffers of BUFFERPOOL. BUFFERPOOL size=16K,buffers=625000,lrus=500,lru_min_dirty=2.00,lru_max_dirty=5.00 On the one hand, the docs declare it uses the OS page size (4K in AIX), …
IDS 12.X EOS
Hello All, Can anyone tell me, is there any information for IDS 12.X EOS. if EOS is nearby my company will try to upgrade with 14.x. Thanks Amit Patel ------------------------------ AMIT PATEL ------------------------------…
Assert Warning: Memory block header corruption detected in mt_realloc 2
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE We got the following warnings: 17:58:53 Assert Warning: Memory block header corruption detected in mt_realloc 2 17:58:53 IBM Informix Dynamic Server Version 11.70.FC5XE 17:58:53 Who: Session(5284871, sap_xi@pfp-app1, 0, 7000…
14.10.FC10W2 download
Hi there, the IBM Support Fix Central contains the 14.10.FC10W2 for AIX and HPIA only, i was not able to find other ports. Could someone from IBM check why the various Linux/Solaris ports cannot be seen there? Or were they not released? The APAR IT45318 ( https://www.ibm.com/sup…
Find table accessing information
Dear All, Can we get the following details from a TABLE in the DB ? 1. USER who is accessing the table 2. The HOSTNAME of the program where the table is accessing 3. PROGRAM NAME (e.g $INFORMIIXDR/bin/dbacces ) 4. SQL TYPE ( e.g INSERT/UPDATE/DELETE/SELECT etc ) Thanks! Best Reg…
Find
Dear All, Can we get the following details from a TABLE in the DB ? 1. USER who is accessing the table 2. The HOSTNAME of the program where the table is accessing 3. PROGRAM NAME (e.g $INFORMIIXDR/bin/dbacces ) 4. SQL TYPE ( e.g INSERT/UPDATE/DELETE/SELECT etc ) Thanks! Best Reg…
What is dbsname BEFIMAGE?
Hi, Informix Dynamic Server Version 11.70.FC5XE During a Level-0 backup, two temporary tables, named `th_dbs01_1` and `th_dbs02_1`, appeared in one of our temporary dbspaces, `tmpdbs3`. The dbsname for these tables was marked as `BEFIMAGE`. Once the backup of `dbs01` and `dbs02` …
Informix Client SDK 4.10.TC16 Windows 64 only installing as 32 bit
I downloaded Informix Client SDK 4.10.TC16 Windows 64 from the IBM downloads site. I am trying to run this driver with an application that runs on 64 bit. It is installing as a 32 bit, and I cannot figure out what I am doing wrong. I download the file then run the clientsdk insta…
The next IIUG Tech Talk:
The next IIUG Tech Talk: IBM Informix: What's new and what's upcoming Thu, Mar 28, 2024 11:00 AM EDT March 28 @ 11:00 am EDT The IBM Informix database serves as the foundation for thousands of applications and billions of devices worldwide. IBM is fully intent on investing in the…
which OS best for SPSS?
SPSS (Statistical Package for the Social Sciences) is compatible with multiple operating systems, including Windows, macOS, and Linux. The choice of the best OS for SPSS depends on your specific requirements and preferences: Windows: Windows is a popular choice for running SPSS d…
Syncing data using cdr sync
Hello, I need to clarify how to use cdr sync cdr sync sends always ALL rows and apply them on target using conflict resolution Alway - to speed up we can truncate target table, in order to not update existing rows by sync process can we use normal transaction activities during th…
Anyone using Informix 4GL Web Services ?
Hi community, evaluating functionality for a customer, I was just wondering whether Informix 4GL Web Services has ever been used anywhere in a production system / real life. Any comments and recommandations about it? Thanks Eric ------------------------------ [eric] [Vercelletto]…
Aruba ClearPass Policy Manager error messages in Qradar
Hi Guys, Kindly need support in blew issue: We have aruba clearpass manger integrated with Qradar and we are receiving stored error we contacted support aruba support and there are no issues form auba side today i made a change [changed in aruba side the protocol from udp to tcp …
sqlhosts entries For standard Engine
Hi Family. I have taken some amusement that this forum has designated me a "party starter". So I've decided to start a new one, although it's been a few weeks since I booted to Linux. I recently had an interview with an agency that is still using SE and is considering migrating t…
IDS IE License Dowload
Hi all, I am trying to download the ie edition installer for IDS14FC10. But there seems to be an issue with this download. If I select http download, I get a 404 page. If I use the download director (very old, java 8 needed), I am getting a download file, but for IDS 14.10FC5. Th…
DIfferent uptime from Informix and OS
Hello, This is not an issue for me now, just a question if anybody has already seen that and what your experience is... I was playing a bit with the Informix server, and because I expected the Informix would have been destroyed, I created a VM snapshot. After some time I restored…
E-book - The CEO's Guide to Generative AI
Generative AI is a defining moment. In the next industrial revolution, making the right investments in this emerging tech can create a multiplier effect for businesses. As applications-and risks-evolve at an unprecedented pace, the IBM Institute for Business Value brings you The …
Announcement: Informix TechDays, Munich Germany, March 13 & 14
I am passing this on from the organizing committee IBM TechXchange: Informix Technology Days 2024 on March 13 and 14, 2024. After a few years of Corona-related break, Informix Technology Days will take place again in 2024 at the Watson Center in Munich. All types of (potential) I…
ほぼテク1月26日AIが切り開く新時代！小さな書店の顧客満足を高めるChatGPT活用術！？
ほぼテク1月26日AIが切り開く新時代！小さな書店の顧客満足を高めるChatGPT活用術！？ ChatGPTと小さな書店の未来を再定義。AIを活用した顧客ロイヤリティプログラムの実践例から、書店が顧客満足度を高め、ビジネスを拡大する方法まで。技術の進化がもたらす革新的な顧客体験と書店の変革について探ります。 www.growth-japan.com/blog/it-daily-brief-2024-0126 #chatgpt #小さな書店 #顧客ロイヤリティプログラム #AIと書店 #パーソナライズされた読書推薦 #顧客満足度向上 #テクノロジーと小売り…
Why is `onbar -v` so slow?
Hi, While `onbar -b` takes 22 hours, `onbar -r` completes for 30 hours, `onbar -v` runs 7+ days. What is wrong with it? ------------------------------ Sincerely, Dennis ------------------------------…
Logical logs backups acting weird after upgrade from 12.10.FC13 to 14.10.FC10
IDS 12.10.FC13 to 14.10.FC10 NAME="SLES" VERSION="15-SP5" Our ERP finally released IDS14 for us to upgrade to. I ran the upgrade on our test/dev vm and the upgrade went well. However the logical log backups are just acting weird. We use the alarmprogram (BACKUP_CMD="ontape -…
ほぼテク1月25日ChatGPTで説明が難しいことを分かりやすい比喩で説明しよう！ネットワークのDMZ編
ほぼテク1月25日ChatGPTで説明が難しいことを分かりやすい比喩で説明しよう！ネットワークのDMZ編 この記事では、ChatGPTというAI技術を分かりやすい比喩を用いて解説し、その仕組み、使用例、人間との関係、限界と課題、倫理的考察、そして未来展望について深掘りします。ChatGPTの「魔法」のような能力を理解し、責任ある使用方法と共存の未来について考察することで、読者がAI技術の持つ可能性と課題について考えるきっかけを提供します。 www.growth-japan.com/blog/it-daily-brief-2024-0125 #chatgp…
Connection Manager error messages
Am I the only one annoyed by this? When an SSL connection to the CM fails, you get messages like this: 09:27:34 listener accept new fd failed:network error = -28014 cannot initialize GSKit secure socket/GSK_ERROR_SOCKET_CLOSED (GSKit:420) 09:33:17 listener accept new fd failed:ne…
Update and revert from 12.10.FC4 to 12.10.FC16
Hello, my customer plan to update to latest version 12.10 because of ER problems in version 12.10.FC4. And uses SDS server for HA (no HDR nor RSS). Is it possible to perform this update/revert as simple engine stop with no transactions, direct INFORMIXDIR to new version, copy onc…
Need to remove old information
We get these messages in the online.logs daily. We want to remove them, but I cannot find them. One of the issues is that in the directory $INFORMIXDIR/extend does not exit. Here is the diredtory for the extend directory. drwxr-xr-x. 2 informix informix 138 Nov 16 13:54 binaryud…
sysmaster/systabnames not refreshing
Hi all, We have a strange situation here. Out admins constantly are monitoring the systabnames table for tables in the instances with many extents. We ran into the extent warning a couple of days ago for a temporary database which was not created correctly, resulting in a table w…
ほぼテク1月17日ChatGPTが解き明かす？酒造業界の最新トレンドとは？
ほぼテク1月17日ChatGPTが解き明かす？酒造業界の最新トレンドとは？ ChatGPTが解き明かす酒造業界の最新トレンド。AIと伝統の融合がもたらす革新的な変化とは？データ分析からマーケティング戦略、未来予測まで、ChatGPTが酒造業界にもたらす影響を深掘りします。 www.growth-japan.com/blog/it-daily-brief-2024-0117 #chatgpt #酒造業界 #AI技術 #データ分析 #トレンド分析 #マーケティング戦略 #未来予測 #革新 #持続可能性 ----------------------------…
How to keep IP address and hostname/FQDN during server migration.
Hello, I would like to know your opinion. We are migrating a single Informix server (no HA, just one server instance with 2 databases on one operating system/server). The customer asked us to keep the server's IP address and hostname (FQDN) because they are not sure who (users or…
Support for TLS 1.3 with Infomix ODBC Driver
We are using the Informix ODBC Driver to connect to an Informix 14.x Database. We need to support TLS 1.3. We can't find any information stating that the Informix ODBC Driver supports TLS 1.3. We have the lates version of the driver installed (Product Version 4.50.FC10W1 Dated 9/…
Unable to connect to Informix DB using SSL from Informix.net.core.IfxConnection
We have a .NET Core application that was written quite a while ago that targets .NET Core 3.1. It is using the Informix.net.core.dll package to connect to the Informix database.The server database system is an Avaya CMS system, which I believe is running Informix version 14.x and…
Smart Blob errors 9810/12048
Greetings. When selecting a Smartblob (SELECT lotofile(blobcol,'/tmp/xxx.tmp','server') ... I get these errors: 9810: Smart-large-object error. 12048: Smart Large Objects: unique ID does not match. Smart large object probably deleted. In this particular case 877 records that poi…
clone: SMX failed to create pipes for clone restore
I am running IDS 12.10.FC13XACAEE on AIX 7.2. For the first time I wanted to use the clone utility. I created a small instance of IDS (just rootdbs and tmpdbs. From the target server I ran: ifxclone -S my_serv -I <ip_source> -P <port_source> -t ifxclone -i <target_ip> -p <target…
CSDK - what am I missing?
server IDS 14.10.FC10WE RHEL 8.9 client Windows 10 CSDK 4.50 64-bit CSDK 4.10 32-bit Using Genero Studio to try to debug a 4GL program, I am getting a -25596 "The INFORMIXSERVER value is not listed in the sqlhosts file or the Registry." There is a section where you can specify e…
Need access to work on watson orchestrator.
Hi Team, I don't have access to the Watson Orchestrate. When I try logging into this link https://dl.watson-orchestrate.ibm.com/ it says "We couldn't find you. No account is associated with these credentials." Can anyone please guide me on how to get the access. Regards Ullas M B…
IBM Informix 14.10 vs HCL OneDB 2.0.1 sysmaster schema
Should there be any differences between the SMI tables contained in the sysmaster database under IBM Informix 14.10 compared to HCL OneDB 2.0.1 ? Of particular interest are the ReadAhead related tables: sys_ra_act_queues sys_ra_act_daemons sys_ra_ptn_stats sys_ra_thrd_stats Whils…
SKIP and LIMT statement in SQL take long time to execute
Dear Friends, For a business need, we need to get 20000 records from the table every day . A table has more than 38 million records . When it reaches to higher value similar to below, SQL running time is too long and the query execution terminated due to timeout. e,g -> SQL 1 (qu…
Find currently executed/running sessions
Hi! We have a select to get the currently running statements: SELECT syssqlstat.sqs_dbname ,ROUND (systcblst.cpu_time, 1) ,syssqlstat.sqs_statement ,systcblst.state ,systcblst.statedetail ,systcblst.tid ,systcblst.name ,sysopendb.odb_dbname ,syssessions.feprogram FROM sysmaster:s…
Informix CSDL 4.50 on Linux ARM dependency to libcrypt.so.1 + building with esql => libcrypt.so.2
Hello, We have a Linux RedHat 9.2 ARM (aarch64) with CSDK 4.50.FC6 installed: [f4gl@pisano lib]$ cat /etc/redhat-release Red Hat Enterprise Linux release 9.2 (Plow) [f4gl@pisano lib]$ uname -a Linux pisano.strasbourg.4js.com 5.14.0-284.30.1.el9_2.aarch64 #1 SMP PREEMPT_DYNAMIC Fr…
getting serial key inserted from .Net Core Informix Provider
I've spend a couple days searching the documentation and I can't find how to get the equivalent of sqlca.sqlerrd[2] out of .NET Core Informix connector. I can find sqlcode, I can get number of rows inserted/updated/deleted but I don't see anywhere that this critical information…
Informix Upgrade to new version
| view attached hi team currently we are using SQL Server Management 12 and Informix Client version 4.10 and Java 6 so ,To Remove the Vulnerabilities and to upgrade the Informix to higher version and know the Compatibility for the higher version to which it has to be updated , c…
IBM VS.NET SE Integration & Extensions package did not load correctly
VS 2022 ver 17.8.4 send me error "IBM VS.NET SE Integration & Extensions package did not load correctly " "The problem may have been caused or by the installation of another extension. You can get more information by examining the file '..\\activylog.xml' in activylog xml "Setsit…
Changing RSS IP
Hello We need to change IP on our RSS server. Is it possible to reconnect with the main server without resetting informix (main server) ? Thanks ------------------------------ Samuel ------------------------------…
Enterprise Replication: not sure which options for cdr define replicate
Hi Folks, first of all, a Happy New year to all the ones I didn't say personnally in our beautiful community. Back to business: here is my case I am in charge of a migration from an old 11.50 Windows 32 bit instance which is a nightmare of performance and stability etc., to a lin…
IDS 14.10 Download
Hello everyone, Happy new year to All. Can someone please let me know how can I download IDS 14.10 from IBM passport advantage site? I'm not getting information/option to download. Thanks Amit Patel ------------------------------ AMIT PATEL ------------------------------…
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 …
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…
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…
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…
ALTER TABLE removes it from audit trail
Hi. Ran into a strange situation. ALTER TABLE xxx ADD AUDIT; Do a dbschema and the WITH AUDIT clause is present. ALTER TABLE xxx ADD (c int); -- or whatever Do a dbschema and the WITH AUDIT clause is gone. Surely a bug? Newest version I tried this with is 14.10.FC7W1 Best regar…
Potentially Serious HDR Failover Bug
All: Over the weekend, we hit a serious issue that created a huge mess from which we're still recovering. 14.10.FC8. We have a three-node HDR cluster (I still want to call it "Mach 10" because I'm An Old) with one node as PRI, one node as HDR and one node as RSS. HA_FOC_ORDER is …
Potentially Serious HDR Bug 14.10.FC7W1
All: I wanted to make you aware of something we've hit a couple of times and also find out if someone else has encountered it. Twice in the past few months, I've had DR Ping faliures on our HDR primary which seem to have left the cluster in an unstable state. It's as if the prima…
archecker error with PSM
Hi, Level 0 and log backups are being made using psm on an AIX system for testing. I tried to recover the table with archecker using psm's backup, but I get an error as below. command) archecker -bdvs -f schemafile onbar backups or restores are performing fine. I also tried slibc…
New Informix Webinar from IBM!
This Thursday at 2PM EDT IBM will be presenting a new Webinar entitled "Informix - The Future is Now!" Register here: https://ibm.biz/BdPBWP ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------…
Repack/Shrink With In-Table BYTE Columns
All: I have a couple of tables that have millions of records and each of which has one BYTE column stored in-table. I've deleted over a million records from each of them (probably accounting for about 35% of the total records in the table) and then did 'table repack shrink,' whic…