Threads from 2020
Browse by month: Jan · Feb · Mar · Apr · May · Jun · Jul · Aug · Sep · Oct · Nov · Dec
Setting a user to Read only access
Hi, We have been asked by a client who is using IDS 12.10 to set a particular user to have read only access to the database. Just a bit of background - this is the user they will use to access the database using ODBC for reporting. The ODBC driver is a read-write driver. By defau…
DBINTERVAL
Dears, What will happens if set DBINTERVAL value to -1 . As I know default is 30 seconds and if 0 , then no Replication. But no idea of -1 value. Thanks Amit Patel ------------------------------ AMIT PATEL ------------------------------ #Informix…
Increasing BUFFERS
Hello All, Please let me know, if need to increase BUFFR parameter , then How should I calculate how many buffer I need to increse? And how it referenced with SHARED MEMORY? If Increasing BUFFER parameter, then need to change any of the SHARED MEMORY parameter also? Kindly assist…
Spot the difference
> onstat - IBM Informix Dynamic Server Version 14.10.FC4W1DE -- On-Line -- Up 10 days 04:18:20 -- 334828 Kbytes > > onstat - IBM Informix Dynamic Server Version 14.10.FC5DE -- On-Line -- Up 00:01:54 -- 185996 Kbytes 2020-12-22 18:08:01 > Is this feature or bug? Hrvoje -----------…
Informix + PAM + AD + CentOS Samba Update Issue
OK, kids, here's an esoteric one for you, which I've recently run across. For years now, we've been using PAM authentication to allow our domain users (in our case, MS Active Directory) to access certain databases with their domain credentials, saving us the trouble of separate a…
CPU Utilization and Performance Tuning
Dears, Please let me know what steps should be taken in case of CPU Utilization high and Performance Tuning Scenarios. As few Steps I know , please correct or add your opinions. Performance Issue : Check for Index Field on Table based on SQL Running Check for Last Update Statisti…
Update Statistics on Non index field
Dears, Please let me know if I add new field in table with NON INDEX field , so Do I need to run Update Statistics? Thanks Amit ------------------------------ AMIT PATEL ------------------------------ #Informix…
Informix OLTP benchmark
Hi, is there any tool available for benchmarking / comparing different servers? I'm reading about BenchmarkSQL used by the fasted DBA contest... But i can't find the fork that supports informix. Thx. ------------------------------ Josef Albert ------------------------------ #Info…
Compatibility
Hi Can a version of Informix work with anterior clients? for example a existing parameter on the informix engine to deal with these clients , or do we have to upgrade also the client part (cdsk) to a compatible version also Thanks in advance ------------------------------ John S…
Sporadically onstat fails with Cannot attach to shared memory. errno = 22
Hi, i've the problem that sometimes (random) onstat commands fails with following error: 14:53:31 shmat: [22]: operating system error 14:53:31 Client could not attach server shared memory segment, use IFX_XFER_SHMBASE. MapViewOfFileEx: w32ec=487 at nt_shm.c:735 onstat: Cannot a…
trim error under heavy load (14.10.FC3WE)
Hello, we´re using RHEL8 64bit and 14.10.FC3WE - under heavy load running the same SPLs on different databases, we notice: DataError: SQLCODE -879 in EXECUTE: 22027: Trim error If we run the same SPL under non heavy load, the error does not occure - with same data and same SPL. o…
Limits in Informix
Hi Please where can i find Limits on Informix, first on 11.70 and also on other posterior versions 12.x 14x i only found on a 32 bits system Thanks in advance ------------------------------ John Smith ------------------------------ #Informix…
Informix JDBC demo folder does not exists?
Hello, all. Informix JDBC 4.10 (or even 4.50) does not contain any demo folder mentioned in manuals? https://www.ibm.com/support/knowledgecenter/SSGU8G_14.1.0/com.ibm.jdbc.doc/ids_jdbc_514.htm I was looking for IfxBSONObjectDemo.java file. If somebody knows how can I get that sam…
Foreign Data Wrapper(s)
Throwing this out there for some help. I am doing an ETL from SQLServer into IFX (versions are irrelevant). Because IFX has no foreign data wrapper option (AFAIK), I need to use PostgreSQL as the intermediate engine to stick things together. With this, I can set up a FDW to SQL…
DRDA w/SSL
Has anyone here had any luck getting a client connected to Informix using the IBM DRDA protocol over SSL? I opened a case on this some months ago and the DB2 and Informix sides of the fence just kept punting back and forth. Setting up a drsocssl listener on the engine side is sim…
How to stop Defragmenter cleaner thread on startup ?
Hello, how can I set Informix to NOT run Defragmenter cleaner thread on start ? I was disable all ph_task in sysadmin, bounce instance, but it was run automatically again on startup. My Issue is, that on startup, Informix engine add to much share memory segments (12GB) , and afte…
Startup Sequence
Hi What is the exact informix Startup sequence, faced a fast recovery for several minutes and didn't find any explanation in informix log Thanks ------------------------------ John Smith ------------------------------ #Informix…
12.10.FC4 known bug on shared memory/physical log/ontape?
Hello everyone, Is anyone aware of a bug or have come across unusual behavior with version 12.10.FC4 engine on Linux where, usually when an ontape is running, sometimes the shared memory usage jumps exponentially, sometimes physical log keeps growing exponentially? These issues o…
Light Append Buffers
I thought back in the day we could increase the number of light append buffers. Anyone recall that option? I get 4 buffers know matter how any threads are running or fragments involved in source or target. Thanks! ------------------------------ Mark Scranton mark@markscranton.com…
Is there a size of row function for rows with varchars?
Hi Folks. I have a new situation where there are tables with varchars and lvarchrs so that their maximum row size is in the area of 2300 or 2500 bytes and some tables pushing 5000. But all the DBspaces are 2K page spaces. I'd like to average the actual row sizes of each table. …
GL_COLLATE & GL_CTYPE
Hi, Currently we used default setting for GL_COLLATE & GL_CTYPE en_US.819. We plan to convert this database to GL_COLLATE & GL_CTYPE to en_US.57372, How to do this? Right now, look like we need to used dbexport data and dbimport back data using environment setting export DB_LOCAL…
How to know what edition is installed ?
Hi to all onstat -v shows the version but not the édition, how to find out the edition please ? thanks ------------------------------ John Smith ------------------------------ #Informix…
New folder in the IIUG Software repository for functions/stored procs
Hi All, after some discussion in another forum, I came to the following conclusion: Many of us are requesting to have a number of very handy SQL functions or Stored procedures that are included in other popular DBMS. THis might be the right time to gather requirements for future …
index datakey issue after an onload restore to a similar server 14.10
Hi, We have some issue after we restored the database server to our test server with onload utility. We get some error from oncheck -cix database. Validating indexes for database:ownere.table1... Index 1013_4917 Index fragment partition datadbs in DBspace datadbs ERROR: Bad key i…
'myimport -C'
Greetings, I apologize for being such a Neanderthal, but might anyone offer a fuller (than the "usage" output from 'myimport') explanation of what the "-C" option does? In my (alleged) mind, it looks like it might be similar to the "-i" option. But, that doesn't make sense, sin…
New release of utils2_ak
Folks: I just uploaded an update to my utils2_ak package to my web site ( My Utilities ). This release includes a new option to myschema: --alter-checks as well as a couple of bug fixes. Art ------------------------------ Art S. Kagel, President and Principal Consultant ASK Data…
Wait on buffer log
We have a situation where we are storing PDF files in a table each file size is more than 100mb and log buffer size is 1mb. We are observing wait on buffer logs and slow response on other OLTP transactions. We have also HDR and two RSS nodes . ------------------------------ Khur…
ALLOW_NEWLINE
Hi. I'm on 14.10.FC4W1. I have ALLOW_NEWLINE set to 1 in my onconfig file. But after I execute execute procedure ifx_allow_newline('f'); I still can insert strings with new line chars. Is this the expected behaviour? This runs without an error: drop procedure if exists check_nl()…
Space free , sysmaster and onstat_d output are different !!!!!
Hi on 11.70.FC8 (i know i have to upgrade , it s ongoing :) ) i calculated the space free with onstat -d and the statement below, but the output are different with onstat -d (free column * page size), each dbspace has different pagesize and on sysmaster database sysmaster; select…
GC errors
One of my long standing frustrations with Informix ER is that when the global catalog has issues, it gives errors that are pretty close to useless. Example: CDR GC peer processing failed: command: start replset, error 37, CDR server 3905 $ cdr finderr 37 37 undefined server OK,…
Bytes per row
Hello All, I need to know how many bytes 1 row will consist? Will btch_name varchar( 80 , 50) take 80 Bytes ? And if this field has only 30 character then also it will space 80 bytes only? And if we have decimal (10,2) and decimal(2,0) then how many bytes both will have? creat…
Use Smart Triggers with .NET
Can you use Smart Triggers with .NET? If so does anyone have examples on how to do that? Thanks, Jeff ------------------------------ Jeffrey Filippi ------------------------------ #Informix…
Webinar topics for 2021
We are planning the webinar lineup for 2021 and welcome your suggestions for topics of interest. Also welcome any client or partner wishing to present on their Informix deployment successes. Please post here or contact me direct at tamaskar@us.ibm.com Thank you! -----------------…
Table Extent Size calculation
I have to create a new table and need to calculate the extent size. If I don't have data growth forecasting , but customer has given the reference table and as per the reference table below are the data: Row size 133 Number of rows - 52655123 Number of column - 29 Can this be u…
Informix CloudPak webcast replay is now available
The replay of yesterday's IIUG sponsored webcast on Informix and CloudPak is now available in the Library / Webcast replay section. Thank you to Scott Pickett and Jan Musil for their time and effort in preparing and presenting some excellent materials. ---------------------------…
SMART TRIGGERS IFX14.10
Hi, Anybody have already try using Javascript with Smart Triggers ? Sample ? Regards ------------------------------ Garcia Benjamin ------------------------------ #Informix…
IFX14 - Smart Triggers
Hello, I'm looking for samples of using Smart Triggers with "Javascript" Can anyone help me ? Thank you ------------------------------ Garcia Benjamin ------------------------------ #Informix…
Informix 14.10 Benchmark on linux intel x86.64
Hello guys, Do you know any website that talks about 14.10 version performance compared to 12.10 ? I need to send 14.10 benchmark to convince my customer. He has 12.10 on Linux currently Thanks a lot. Juan ------------------------------ juan luis roca ----------------------------…
session from "::ffff:2"
Hello to All How to find the host that is connected (IP Adress) for a session with hostname = ::ffff:2 ? Thanks ------------------------------ John Smith ------------------------------ #Informix…
DR: Cannot connect to secondary server - After secondary server restart
Hello, Everything was working well, but after restart my secundary Informix 14 Server, the replication stopped working. I don't know why, because i don't have network problems. I'm getting the following log on the secondary server: 11:23:25 Started 1 B-tree scanners. 11:23:25 B-t…
Using the right SQL parameter type
Hi all, I try to convince my colleagues about this: No matter the SQL API (we do ESQL/C), to me it's always better to use the right program variable data type for SQL parameters, that corresponds to the SQL column type. For ex in ESQL/C, use a date/int for a DATE column... dec_t …
IDS EE in Docker
I'm playing around with Docker (podman) on Centos. I've installed IDS 14.10.FC4W1 in the container and when I run I get: $ $INFORMIXDIR/bin/onstat -V IBM Informix Dynamic Server Version 14.10.FC4W1DE I used the IFMX_ENT_ED_LIC_INSTAL14.10.FC4W1.zip to install the enterprise edit…
onstat statement
Dears, Kindly let me know if I run onstat - g stm command to check current sql statement which give the Session ID but sometimes if I try to kill the session by onmode -z <id> , it doesn't kill the session. So do I need to connect the session id with onstat -k session id ? kindly…
Composite Indexing strategy
Hi all, New to the group. Does anyone knows any reason for redundante composite indexes (multiple-columns) by just changing the field's order ? Like partitioning and whatever or legacy reasons on older versions of informix ? The reason is I came across this situation on a frequen…
Schema DIFF needed for big databases
Hello, I need to find all changes between two databases that have the same origin but "alter table", "create table", "create index" could have appeared on one side in development. The databases are very big (230'000 tables), so what is the best tool to find out all changes that a…
Composite Indexing strategy
(Possible duplicate post, sorry if it is the case) Hi all New to the community. I've stumble to a situation where I see multiple composite indexes with same fields, but changing order of the fields. Do you have an idea on any situation that this could make sense , like for ex for…
ODBC error 23101
Greetings and salutations! I'm trying to setup an ODBC connection from my Windows 10 client to a Linux Informix DB Server. Having setup the appropriate server and host information in the Setnet32 app I'm getting an "Unspecified System Error = -23101" when trying to get the databa…
a script to monitor Informix sessions
| view attached Hello I would like to share a script that I have created and used since some years to have some consolidated performance information on Informix sessions. I already tried to share it via iiug toolbox a long time ago but I never have been able to understand how to …
Shared memory segments are not removed with the onmode -ky command
Hello everyone. I would like to ask for advice on the problem of restarting after stopping Informix. Below is the order in which the instances were created. 1. Compress the entire Informix directory $INFORMIXDIR of the existing host (host1) with tar 2. Copy the tar file to anothe…
Sync schema in two databases
Hi. I need to sync the schema in two databases. Any tools you know of that can achieve that? Found dbdiff2 in the repo (old 4GL code). Anything else? Thanks in advance, -Snorri ------------------------------ Snorri Bergmann ------------------------------ #Informix…
ODBC Driver - Keep Alive
Hello everyone, There is still no keep alive setting on the * client side * of Informix ODBC connections (i.e. driver or registry setting) is there? Thank you, Hal Maner M Systems International, Inc. www.msystemsintl.com #Informix…
GSKit to OpenSSL replay now available
A big "Thank you!" to Sunil for this morning's Chat with the Labs session on GSKit and OpenSSL. The replay is now available in this forum's Library under "webcast replays." GSKit Replay link ------------------------------ Carlton Doe ------------------------------ #Informix…
unused tables
Hi Is there a way to identify unused tables on a database , not accessed for a while ? thanks :) ------------------------------ John Smith ------------------------------ #Informix…
Using HQ ?
Hi to All Can we use Informix HQ on production without testing ? what precautions should we take ? Thanks in advance ------------------------------ John Smith ------------------------------ #Informix…
IDS 14.10 - RSS with Windows Server
Hi, im trying to create a RSS instance with ids 14.10 following this guide: https://www.ibm.com/support/knowledgecenter/SSGU8G_14.1.0/com.ibm.admin.doc/ids_admin_1000.htm With 12.10 this steps are working fine, but with 14.10 i'm not able to bring the rss instance online. It fail…
Job posting - Product Development Manager
Job Title: GS Product Development Manager Job Summary: Manage the SMILE Product Development and IT Infrastructure teams, to build and maintain the Financial systems for State of Georgia's DFCS. Manage people, projects, processes, technology, and organizational change to support e…
ODBC connection to group (of connection managers)
Hi, I have somewhat limited experience with ODBC (or Windows, for that matter). We have two connection managers providing access to our cluster of Informix database servers. From Unix and/or JDBC we are using sqlhosts to create groups of connection managers for this setup. I am s…
14.10.FC4W1 Windows installation problem
Any experience here with 14.10.FC4W1 on Windows - before I contact support. I have developer installation media (ofc) and I put e_edition.jar (express installer) file on the same media. After installation onstat -V shows IBM Informix Dynamic Server Version 14.10.FC4W1DE Next I mo…
pb with Indexes on temporary tables
Hi I have a sql statement that lasts more than two hours, it contains 2 or 3 temporary tables with some indexes for better performance but i noticed that the indexes are not used (sqlplain), it always do a seq scan on the wholes temps tables !! is there a solution or must i creat…
Control of CLIENT_LOCALE and DB_LOCALE at connection (doc issue?)
Hi all, I know by experience that when your DB_LOCALE does not match the database locale you connect to, you get the error: -23197: Database locale information mismatch. This is all fine and good to be a strict checking and avoid any misusage. But the doc seems to describe that t…
Reclaim dbspace without shrinking/repacks capabilities
Hello dear IIUG members, i have a database without shrinking/repacks capabilities. I have a couple of huge tables with lenghtly records. I have a couple of dbspace that i could use but with limited space (it won't be a long term solution; and there are IO issues if i put all heav…
Adequate host specs to host InformixHQ
Howdy! Just wondering what would be the adequate specs (CPU, memory, disk, etc) for a RHEL host running InformixHQ exclusively. This instance will be keeping tabs on 25 Production servers initially, and we want to save 6 to 12 months worth of metrics in the repository. Planning t…
long checkpoint
My customer changed the server a few days ago and modified the Informix onconfig parameters vpclass and cleaners. Perhaps because of that, the checkpoint duration has increased to around 30 seconds. Before, it usually took 1 or 2 seconds. Is the parameter change related to the ch…
Unable to get session latch.
Hi. I'm running on 14.10.FC3 / Linux. Just saw a few occurrences of these in online.log: 10/08/20 16:45:22 Performance Advisory: Unable to get session latch. 10/08/20 16:45:22 Results: This can happen during high connectivity periods where sessions are allocated and freed frequ…
Sequential scans issues
Hi, I have a high number of sequential scans in tables, as I have more than 3000 tables it is difficult to identify the SQL that originates them. Can anyone had experience with similar situations that can give me some help? Is there a way to identify the instructions that origina…
High availibity on same storage
Hi, for informix replication technology, like HDR, RSS, we need a a copy of the db (dbspaces, chunks) what informix replication technologies we don't need a db storage for ? SDS ? maybe others ? the need is similar to Oracle RAC thanks :) #Informix…
need some help with onbar Veritas Netbackup (informix 7.31)
Hello guys, IHAC who wants to restore his informix instance with onbar. He uses Veritas Netbackup as SM. When restoring the folloging error appears in the bar_act.log file 2020-10-08 10:49:55 8486 8484 /opt/informix/bin/onbar_d -r -w -p 2020-10-08 10:49:55 8486 8484 WARNING: Logi…
A quick leave of a newcomer
Hello community, It's not a technical topic, but I write with a frustrated mind. My company hired a new employee for database technical support this time, and the newcomer says he will leave the company for the second day of work. As a member of the database technical support tea…
Replacing block device to character device
Hello All, I found that a block raw device is being used in chunks on a customer's Informix server. Is it okay to use the device by replacing it with the character raw device path? The chunk is using symbolic links, so we plan to create a new symbolic link pointing to the charact…
Any way to cast SET into VARCHAR?
I want to convert an SQL output, a SET value, into a VARCHAR in order to use the string functions to remove the SET word, the brackets, and the quotes, to only leave commas separating each item. I tried a cast but Informix complain it cannot be done, but perhaps you guys know a t…
Onbar backup issue : XBSA Error (BSAInit): An unspecified XBSA error has occured: 610
Hi to all i face an issue with onbar on Informix 12.10.FC14, the xbsa seems not compatible with TSM !!! any help ? 2020-10-02 12:57:33 7930316 8912924 Using IBM Corporation's TSM version 5.3.2.0 as the Storage Manager. XBSA API version is 1.0.3. 2020-10-02 12:57:33 7930316 891292…
Update statistics info for temporary tables
Hello, can I get from somewhere update statistics info on temporary table this info is not available in systables, sysindexes and sysdistrib Thank you ------------------------------ Milan Rafaj ------------------------------ #Informix…
RAID6?
I'm lazy. So, when I make a decision on some things, I stop making explicit efforts to continue following or researching it. An example of this is the whole RAID thing. Years ago, I read much of Art's material, and decided that RAID10 was "it" for the systems that I am responsi…
CDR_QHDR_DBSPACE
Hi all, I am (re-)building an ER set up and realised I don't really understand what CDR_QHDR_DBSPACE is used for. I have to look in the 11.50 documentation to find: "Specifies the location of the dbspace that Enterprise Replication uses to store the transaction record headers spo…
BTS config and space estimates questions
Hi all, our developers plan to implement fulltext functionality using BTS in the application and I have a couple of questions and I did not find the answers in docs: Sizing of sbspaces - is there any estimate formula or rule of thumbs on bts_index size? - is there any estimate fo…
External table reject file
Hi I migrating a table with external table from IDS11.5 to IDS 14.10FC3. The table contains a blob column and I get some rejected record msg. ODD_NUM_HEX_DIGITS. I couldn't find an explanation to this problem. How can is check /repair this problem in the source DB? The field can …
EAR & KMIP Remote Key Server
IDS version 14.10.FC3 Having a problem configuring KMIP on a remote key server using SKLM. When I got to run onkstore I get the following: EAR ERROR: (-82964): Cannot retrieve the encryption key from (kmip:...). ERROR: KMIP RESULT REASON : 1. KMIP RESULT MESSAGE: 'CTGKM3040E Obje…
Dbspace contents
Hi to All, how to list what a dbspace contain ? thanks :) ------------------------------ John Smith ------------------------------ #Informix…
performance issue on Table
Hi All, We had a table of 260GB which was round robin fragmented with 4 partitions. It hit the pages per fragment limit and we have added 4 more new fragment. Since then application team is complaining about slow performance. Any idea what could be the issue and ways to troublesh…
CREATE DATABASE and DB_LOCALE
Hi all, Normally, when DB_LOCALE is not defined, a CREATE DATABASE will use by default the ISO8859-1 encoding. I know also that when setting a DB_LOCALE that does not match the database locale, you get the following error at connection: 23197: Database locale information mismatch…
HQ on 14.10 FC4W1
Hi folks, I am finally looking at HQ on 14.10FC4 (W1). So I stopped my agents, then the hq server running on FC3, and restarted all of them on 14.10 FC4. Am i supposed to see any difference at once, (which I don't) or do I have to perform additional steps ? Or even should I consi…
JDBC driver download
I have seen this sentence in the JDBC documentation previously, and it is still in the latest (14.10) documentation: https://www.ibm.com/support/knowledgecenter/en/SSGU8G_14.1.0/com.ibm.jdbc.doc/ids_jdbc_021.htm "You can obtain the IBM Informix® JDBC Driver from the IBM Informix …
"Breaking out" a database
IDS 12.10.FC14 Solaris 10 1/13 Background: I have a legacy database that was laid out based on the Oracle S.A.M.E. (Stripe And Mirror Everything) strategy. It has served us well for many years. We have had no problem with performance, and there has been nearly zero admin effort…
IBM Watson Integration with Node js?
I am thinking about making a chatbot with IBM watson. Is it a good idea to make it with node js? ------------------------------ KA Cooler ------------------------------ #Informix…
Autolocate
I have written a deep-dive blog post, which you may be interested in reading, on the relatively new AUTOLOCATE feature. It is a lot more far-reaching than it seems from just reading the manual. (With thanks to HCL Support for initially pointing out its use.) https://informixdba.w…
storage optimization feature
Hello. I have a question about the storage optimization feature. IBM Informix Storage Optimization Ferature for Enterprise Edition was detected as a result of an Informix license check from my customer through IBM License Metric Tool (ILMT). It seems that the use of the storage o…
SELECT output to SETs and from SETs to Regular tables
I have not been able to completely understand how SETs work. I want to create SETs from not-singlet results of SELECT statements and I want to do the oposite, from SETs to regular table-like outputs. DROP TABLE IF EXISTS persMergeExcl_tmp; CREATE TEMP TABLE IF NOT EXISTS persMerg…
Send-only and Receive-only nodes
I'm just a font of intriguing issues lately. In our environment, 12.10.FC14, I have a send-only ER server that supports multiple receive-only nodes. One on of the receive-only nodes, I found this: $ time cdr check repl -R -r myrepl -d -e delete -m gprim__sendonly gtarg__recvonly …
Table and index rebuild
Hi, I am having some fragmentation problems due to changes in some tables fields an indexes, as I have some system constraints and the only way to identify that I know is through dbschema, I do an export and import to optimize. Is there any way to optimize the process? Thanks for…
AUTO_STAT_MODE - from where it calculates % changed
Hello, I would like to know from what source update statistics calculates if should run or not if AUTO_STAT_MODE is set to one based on STATCHANGE? Is it also dependent on sysadmin mon_table_profile as AUS or uses some other source? Thanks a lot. ------------------------------ Mi…
LTAPEBLK influence on backup size to disk
Using IBM Informix Dynamic Server Version 12.10.FC13, on HP-UX ia64 , on a lab instance, I notice a strange behavior when using "ontape -a" to backup the logical logs to disk ( a file system directory visible by the informix instance ). Onconfig: LOGFILES 49 LOGSIZE 10000 DYNAMIC…
Asserts on sysconblock
Hi. I noticed I have got some asserts in the last few days and all are because of queries to sysmaster:sysconblock. In some cases InformixHQ triggers this, in others our application does. Has anyone experienced this? 10:05:18 IBM Informix Dynamic Server Version 14.10.FC3 10:05:18…
Informix Enterprise Gateway Manager Error
Hi All, I am testing connecting to the mssql server through egm. When connecting to the mssql data source using dbaccess directly as shown below, sql runs fine. Instead, when using in the form of distributed query as shown below, a 908 error occurs and the egmd process crashes. I…
Informix 14.10 FC4(W1) on Red Hat 7.2
Hi Community, I have a customer considering moving from 12.10 FC12 to 14.10 FC4(W1) He runs on Red Hat 7.2 here are his details Version RedHat : 7.2 Version Kernel : 3.10 Version compiler : 4.8.5 Version Libc : 3.17 compiled with GCC 4.8.3 https://www.ibm.com/support/pages/inform…
How to check some information of onstat -l
Hello All, I see Log Space Used for each Subsystem entry (OLDRSAM / SBLOB / HA / DDL) in onstat -l, does the same information exist in the sysmaster database? IBM Informix Dynamic Server Version 12.10.FC12W1XC -- On-Line -- Up 55 days 01:50:25 -- 4490888 Kbytes Physical Logging B…
It installed (Informix 14.10 C ed. on Ubuntu 20.04) but now what? A unfamiliar understanding.
Greetings, ZZzzZap! "Er' please take me to your leader"? I hope the following would not be too much to ask for as I am real nervous about asking such questions to such a technical crew, but sadly I am going to have to. So, I installed Informix on Ubuntu 20.04 (Pop_OS) but have be…
We're back!
The original IIUG Forum history is back online and available for searching! You can get there from the Members' Page Menu or, once you have logged in as a member, this URL will also work: International Informix Users Group We are working with IBM and the third party that manages …
Overloaded Stored Procedures
Does anyone here have a handy-dandy script that will drop all versions of an overloaded stored procedure? e.g., DROP PROCEDURE myproc(CHAR); DROP PROCEDURE myproc(INT); DROP PROCEDURE myproc(CHAR,INT); ------------------------------ TOM GIRSCH ------------------------------ #Info…
Link to xC4 replay information
Thank you to everyone who participated in the IIUG Informix v.14.10.xC4 webcast series. As you saw and heard, there's some great features in this release. For those who missed it, here is the link to the event replays: https://ibm.box.com/s/31kss5vpz28ev6d6c0uf5i2zwz8xs01y The re…
Upgrade or remove obsolete datablade
Somehow, several of my databases got munged somewhere along the line, such that spatial.8.21.FC5 is registered there. The current version (for 12.10.FC14) is 8.22.FC2. However, in blademgr, I'm unable to unregister 8.21.FC5: ids__chaos_dev__b1>unregister spatial.8.21.FC5 eurorese…
Dropping temp table throws -242/-106
Hello everyone. We're on 14.10.FC3 I ran today into a problem that has happened before (on 12.10.Fxx) but it is sporadic and impossible to reproduce. Basically, a running program with one connection to the database creates a bunch of temp tables and later drops them. These table…
IDS 14.10: Automatic dbspaces/chunk creation?
Hello! I have recently played with server re-initialization using oninit -i with IDS 14.10.FC1 and 14.10.FC4W1 ... I wonder if IDS does automatically create chunks and dbspaces: Is this the case? Note: At some point I have created my own chunks/dbspaces, but then I wanted to re-i…
Informix 11.7 db migration to oracle 12c RAC database
Hi Team, I am planning to migrate my current informix 11.7 database to oracle 12c database RAC. Could you please help me out to start this migration. Kindly note, i am very new to informix database. Thanks, Srinivas. ------------------------------ Srinivasarao K -----------------…
ER Connection issue
Hi All, I am trying to link an Informix 14.10.FC3 instance running on a RHEL7 server to an Informix 12.10.FC4 instance running on a Solaris 10 server. (I previously had both servers connected, but using the same Informix 12.10) IBM Informix Dynamic Server Version 14.10.FC3 -- On…
Using datafiles in 12.10.xC13, that were updated by 12.10.xC14
I have a 12.10.FC1 4 install which I'm going to downgrade to FC1 3 (reason is in earlier thread related to APAR IT32236). Does anyone know of any potential issues with datafiles that were written to with FC14, then being used with FC13? TIA. #Informix…
char_length() behaviour between 12.10.FC11 vs 12.10.FC14
Greetings, So, have upgraded to 12.10.FC14 (from 12.10.FC11), thanks to Andreas' suggestion to deal with the ALTER TABLE to ADD column issue I posted about earlier. However, now I have bumped into this strange behaviour (which I'm really hoping is simply a provisioning issue at m…
Old IIUG Informix Forum?
I can't seem to find the old IIUG IDS forum, any more. Does anyone know how to access it? Thank you. DG ------------------------------ David Grove ------------------------------ #Informix…
Ifmx Nosql and key name: impact of the length of the 'key' name
Hi Friends, Interesting ( according to me at least) question about best practices on NoSQL implementation in our beloved HDBMS (hybrid DBMS) When you handle a NoSql Document, you have inside it a number of key/value pairs. OK Now when it is time to give names to the 'keys': what …
Informix 14.10 Partial Indexes
You may have seen our article here (as publicised in LinkedIn Informix groups): https://www.oninitgroup.com/faq-items/informix-14-10-partial-indexes @Roland Wintgen sent me feedback regarding a quirk he found if there are mixed page sizes: see "Caveats" at the end of the article.…
Get Explain over JDBC-Connection
Hi! I try to get the explain-file over JDBC (because not all developers have access to the db-servers). Following commands: "SET EXPLAIN FILE TO '" + fileName + "' " <Execute the explain-statements> "SET EXPLAIN OFF" "SELECT FILETOBLOB('" + fileName + "', 'server')" --Read the …
Authentication Methods
Hi, I have been trying to figure out methods to cover off a couple of security requirements but cant seem to come up wioth anything workable. So I was wondering if anyone else had resolved these types of issues without emptying their wallet or chewing of their arm. Apart from 3 t…
Alter fragment attach performance
Hi, I am trying to make ALTER FRAGMENT ATTACH as seamless as possible, ideally to the point that given the right conditions the attach will just involve updating system tables and no data movement. Therefore it will take a matter of seconds no matter how large the tables involved…
Odd Index Issue
I have an existing table in 12.10.FC14, about 1.8 million records, that has three indexes on it: - A unique index on a serial key - A composite, six-column unique index - A three-column composite index that allows dups This table participates in ER in a send-only/receive-only rel…
New RFE: Improvement in the check for high serial values
Hi, I have raised new RFE: https://ibm-data-and-ai.ideas.aha.io/ideas/INFX-I-383 --> updated link It's hard to check if you reach the upper limit of your serials. This improvement would make it much easier and is certainly easy to implement. Please vote for this RFE to be realize…
IBM links to InformixHQ documentation are broken
IDS 12.10.FC14 Solaris 10 1/13 We just upgraded to 12.10.FC14 from 12.10.FC12. We'd like to use InformixHQ, which became available in 12.10.FC13, I think. The Informix documentation on this page: https://www.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.sa.doc/sa.htm has…
Table minversion??
IDS 12.10.FC14 (newly upgraded today) Solaris 10 1/13 I observe this strange message in the online.log: 08/11/20 08:50:25 DR: Warning: The table minversion DBA feature is enabled on this secondary (flag with value 0x400000 of the SQL_DEF_CTRL onconfig parameter). Please ensure th…
Restarting replication
IDS 12.10.FC14 Solaris 10 1/13 I guess I took too long between starting the primary, and starting the secondary. Got this in the log: 08/11/20 07:43:42 The SMX connection between high availability servers was closed because the peer server was unresponsive for the timeout period…
Benefits of being IBM Business Partner
Hi All, What are the advantages of being IBM Business Partner? Is it true that being IBM business partner, I can download Informix Enterprise Edition in my development/testing environment for testing purpose ? Regards, ------------------------------ Muhammad Ale -----------------…
Upcoming Informix Technical Webinars
It's not too late to register for this weeks webinar! The IIUG and IBM are pleased to continue the series covering the features released in Informix v. 14.10.xC4W1 , including some that didn't make it into the documentation! The events will be held through a WebEx training sessio…
Informix HQ Unable to load locale categories.
I have running IDS 14.1. I would like to run Informix HQ. I followed the instructions https://docs.deistercloud.com/content/Databases.30/IBM%20Informix.2/InformixHQ.xml?embedded=true I have started the server, but I'm not able to start InformixHQ agent due to error: 2020-08-08 21…
column level encryption and SQL performance
Hello We are being asked about encrypting SSNs and see that a simple sql such as select id from t_contact where ssn = '350507267' goes from lightning quick on returning a result and using an existing index to becoming very slow and doing a table scan to return a row after encrypt…
New meeting information for the Technical Deep Dive webcasts
Just a quick message to let you know the meeting information for the last two Informix v.14.10.xC4 webcasts has changed. The original ID and passcode no longer work. Yes, I messed up! :) New meeting codes have been created and will be distributed by the IIUG to everyone who's alr…
Migration from 11.70 to 12.10 and outstanding page versions
Hello, do we still need to sort out outstanding old page versions when migrating to 12.10 or this is necessary only when reverting from 12.10 back to 11.70? Thanks a lot. ------------------------------ Milan Rafaj ------------------------------ #Informix…
Major Issues with Windows CSDK4.50.FC4W1
All, a warning. I installed the latest release of CSDK for Windows, 4.50.FC4W1, and it's got a few problems. The default install path changed, and not everything seems to have picked up on that change. So when you fire up, e.g., ConnectTest or any other ODBC configuration deal, i…
Pipes & light appends
IDS 12.10.FC12W1; AIX. Working on a large reorg and testing with disk and pipes via the ploader (external tables). As expected, I see light appends when using disk during load, but not when using pipes. Using pipes, the unload/load data never hits the ground as it's cloning rows …
New release of utils2_ak
Folks: I have uploaded a new release of the utils2_ak package on my web site ( My Utilities ) The July 20, 2020 release fixes two problems in myschema. One to help users of myexport/myimport who have spatial data types and another to improve the --infrastructure output. It also a…
Upgrade from 12.10.FC12 to 12.10.FC14
IDS 12.10.FC14 Solaris 10 1/13 (current patch) We recently upgraded a test platform from 12.10.FC12 to 12.10.FC14. From previous upgrades, I was expecting to observe messages in the online.log indicating successful upgrades of all the databases. There were four user databases …
BLOBs in blobspaces
I have a database in which is a several dozen tables with such a schema: create table t1 i int, c char(20), some byte in xyzbls ); The BLOBs are located in a special (different) spaces than the rest of the table. I am able to find out how full the xyzbls is. but I would like to k…
ontape error
Hi, I am doing one RSS installation over version 14.10.FC3 and getting some strange errors. Using and old command that I used before: ontape -s -L 0 -t STDIO -F | (ssh informix@10.0.11.113 '. ~/.bashrc ; ontape –p -e –t STDIO ; onmode –d RSS cmsantar01_net') I am receiving syntax…
172: ISAM error: Unexpected internal error
Hi all, I have an existing table, which is populated. When I attempt to ALTER TABLE to ADD a column (a simple CHAR(1) with no constraints) I get the following error: 959: The current transaction has been rolled back due to an internal error. 172: ISAM error: Unexpected internal e…
Registration for Informix v.14.10.xC4 webcasts now available
Hello again. As teased earlier, the IIUG and IBM are pleased to announce that registration is now open for the Informix v.14.10.xC4W1 webcast series. Three separate webcasts are being held: July 29, 2020 at 10 am Central (July 29, 2020 15:00 GMT) Topics: CSDK and IHQ August 12, …
Is it possible to perform onbar backup/restore between heterogeneous platforms?
I would like to know if it is possible to restore to Solaris or AIX with an onbar backup taken on Informix in an HP-UX environment. I answered my customer that it was impossible... Is it possible? The Informix version is 11.5 and the backup software is EMC Networker. In the docum…
New Utility Announcement: partitions[.pl] and supporting package (.pm)
Hi Family. Quite some years ago, waaaaaay before the SourceForge conversion, I uploaded a set of shell scripts under the name partitions . It is still there, under the DBAdmin-tools section. I later converted the same algorithms into Perl and I guess I never got around to uploa…
RFE: Clear Indication when RSS_FLOW_CONTROL or SDS_FLOW_CONTROL is actively applied
https://ibm-data-and-ai.ideas.aha.io/ideas/INFX-I-380 When RSS_FLOW_CONTROL or SDS_FLOW_CONTROL are set to a value other than -1 Informix will try to limit log activity on the primary server so that the secondary servers do not fall too far behind. There is no easy way to know or…
Undocumented "stuff" in 14.10.xC4w1? Answers coming . . . . .
Hey all. I see some of you are hitting features that were released in xC4.w1 but didn't make it into the documentation. Like MSG_DATE. Starting 7/27, there is a series of 3 webcasts with a deep dive into all the features. Look for an announcement soon from the IIUG with registrat…
Can the autoindex feature be disabled?
Hi, I would like to know if there is a way to prevent autoindex from being constructed when executing a query. ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------ #Informix…
New Utility Announement
| view attached Hi folks. I have been working on a few utilities at the same time but there is one I thought had been posted loooong ago. I called it fcopy-table[.pl] (Yeah, written in Perl.) The copy-table part of the name makes it kinda obvious that this is a utility to copy t…
alternative way to skip installation of DBMS_RANDOM package ?
Hello everyone, i´d like ask if you know a good alterantive to install the DBMS_RANDOM package to get a "random" function in informix 14.10FC3 Is there any out of the box way to get a random integer ? How do you solve it ? Thanks! ------------------------------ Marc Demhartner --…
New RFE entry
I have entered a new RFE: IBM Data and AI https://ibm-data-and-ai.ideas.aha.io/ideas/INFX-I-381 If you think that this would be useful to you, please vote for it! Art ------------------------------ Art Kagel ------------------------------ #Informix…
onstat -g top is great, on a primary
But run it against an HDR secondary and you get this: $ onstat -g top IBM Informix Dynamic Server Version 14.10.FC4W1 -- Read-Only (Sec) -- Up 18:56:54 -- 960512 Kbytes Changing data structure forced command termination. Changing data structure forced command termination. Changin…
Issue: shared memory not initialized for INFORMIXSERVER 'informix'
This error occurs sporadically during Informix startup. I am using the current official docker image of Informix. ================================================================================IBM Informix.-------------------------------------------------------------------------…
Index Placement for PK and FK
Running Informix 12.10.FC10 in a Linux environment. I've looked through a lot of documentation, but haven't found anything about index storage with this specific situation: fragmented table, different page size than database, and implicit index on PK and/or FK. I have something…
MSG_DATE in 14.10.FC4W1
Hello everyone. Just installed 14.10.FC4W1 for testing and one of the new features is listed as: MSG_Date Parameter enhancement MSG_DATE configuration parameter is enhanced to support insertion of a date in different formats at the beginning of each message printed to the online …
dbload with "datetime year to second" datatype
Hello, we have some issue loading a flat file via DBload. Problem is a column with this date and time format: |2019.10.03 05:24:24| Error message with 14.10FC3 is: (dbload): Non-numeric character in datetime or interval. We´re using DBDATE env: "Y4MD." - and the data type is "dat…
Fixed Defect List
Does anyone else have trouble getting to the defect fix list for 14.10? I click on the link included in the release notes, and it just takes me to an abstract page that describes the fix list document but doesn't actually list any fixes or provide any obvious link to get to them.…
Associate a container partition with its table
Hi again (Twice in one day! Oh NO! :-) More enlightenment sought, though this is of more practical application. Another discovery I recently made is that a container is a separate TBLspace/Partition. I have partitions named raw_container and mult_container (and possibly a few …
1410.FC4W1 No Longer Allows Solaris 10
Just an FYI... A few months ago, I successfully installed and (very briefly) ran Informix 14.10.FC3 on our Solaris 10 SPARC platform. The installation process ran successfully, and when I executed oninit, the instance started up just fine and converted all the databases from the …
Partition number for external tables?
Hi Family. Enlightenment requested: I am working on a far better version (a considerable rewrite) of my FragmentList.pm package and fragments.pl utility tha tI had put up on IIUG some years ago. In the process I have made an interesting discovery in the sysptnhdr table in sysmas…
Informix in AWS Environment
Hi All, I have seen a few announcements about Informix on Cloud, for example, AWS. I like to understand: - Is AWS a different operating platform like HP-UX, AIX, Linux and Windows? or - AWS provides a virtual instance of one of these popular OS Platforms for IDS to operate? From …
Informix 12 or 14 on Centos 8
Hello everyone, Centos 8 operating system does not appear on the "supported" operating systems list (for Informix 12 or 14) yet. Will this change soon? Do you have any production implementations already running this combination? Thank you, Hal Hal Maner M Systems International, …
534 error occurs when executing set explain on
Hi All, My customer is using Informix 12.10.FC6WE and when they try set explain on statement they get 534 error. Below is a screenshot that reproduces the error. The set explain statement worked fine a few weeks ago. A customer has been checking query plans with InformixHQ recent…
Adding primary to a table having duplicate rows
* Problem: * I have a table which has multiple duplicate records since very beginning, now the table is in production and we cannot remove those duplicate records because they are partially duplicate. And we cannot also move those records to new table as we don't know in how many…
Informix 11.50 system requirements
Hi, My customer plans to migrate Informix 11.50.FC7W3 on HP-UX to the same Informix version on AIX. My customer doesn't want to upgrade Informix. Can I install 11.50.FC7W3 on AIX 7.1? Thanks, ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Re…
Informix Innovator-C Edition - License - Cores Limit
Hello All, I know that Informix Innovator-C Edition (since xc2 versions) has a limit of 2 cores. But can I have, for example, a Windows server with 6 cores and 2 Informix instances on the same server, with Innovator-C license? Does the number of cores have to be physically limite…
New RFEs
Hi, I have raised new RFEs: https://ibm-data-and-ai.ideas.aha.io/ideas/INFX-I-376 - Add readahead per sessions/sql counters https://ibm-data-and-ai.ideas.aha.io/ideas/INFX-I-377 - Make onstat -g rss log buffer(s) size configurable. https://ibm-data-and-ai.ideas.aha.io/ideas/INFX-…
InformixHQ
Hello, I have installed informix 12.10.FC14 and created informix instance in windows 2016 server. This setup is to be used for InformixHQ Tool. I have logged into informixhq and tried to add same machine. After providing Informix server name, host name and port, the server statu…
Slow running backup
Hello everyone, If the backup is running slow thru ontape command , how can we check that and what could be the reason for slow backup? And what could be the resolution? Thanks Amit Patel ------------------------------ AMIT PATEL ------------------------------ #Informix…
IDS Bug of the Day: DBINFO
Consider the following query: SELECT dbsname, tabname, DBINFO('dbspace', partnum) FROM systabnames ORDER BY 1, 2; In 12.10.FC13 and earlier, this query works fine. But starting with 12.10.FC14, it fails: 727: Invalid or NULL TBLspace number given to dbinfo(dbspace). Error in line…
KAIO: out of OS resources, errno = 11
Hi, The following message continuously occurs in online.log and a service delay occurs. KAIO: out of OS resources, errno = 11, pid = 4784150 Below is the onstat -g sql result. My customer is using Informix 12.10.FC6 on AIX, can setting the IFMX_AIXKAIO_NUM_REQ environment variabl…
Upgrade with Success from Informix 11.70 to Informix 14.10
Customers who are running Informix 11.70. They need to upgrade/migrate to 14.10 as we are reaching EOS for 11.70 by sept'2020. Please register on below URL and get yourself registered. Upgrade with success from Informix 11.70 to 14.10 YouTube remove preview Upgrade with success f…
Creating new server from existing one
Hi, I need to stand up a 2nd Informix server on the same host, but, with a different name. I plan to use the same exact dbspaces/chunks as the source server, but, obviously with a different server name. The existing server hosts a large database instance which cannot be recreated…
Where can I download 14.10.xc4?
Hello All, Where can I get Informix 14.10.xC4? It seems that the developer edition of the version has not yet been released. The video below describes the onstat command based on version 14.10.xC4. HCL Informix - Checking Informix Server Status ------------------------------ Sang…
Default Database Location?
IDS 12.10.FC12 Solaris 10 1/13 The default location for new databases is the root dbspace. I would like to be able to change the default location. It appears that the "Autolocate Database" SQL Admin API argument applies only to a single, specifically named database (that you mus…
Release 14.10xc4
Just in case you were wondering, this release was planned for June 11 but has been delayed by a few days. New release date will be known early next week. ------------------------------ MILIND Tamaskar ------------------------------ #Informix…
Pages show as "used" in empty chunk
IDS 12.10.FC12 Solaris 10 1/13 Folks, A tutorial question... I was playing around with dbspaces during the past few days. I created a brand new dbspace (a single chunk). So, it is completely empty (except for 53 pages [reserved pages, I presume]). I then dbimported a database …
Informix Cluster Pro Tip!
When dropping a chunk from a DB cluster that includes an RSS node that has DELAY_APPLY set, it's a really good idea to wait until after the delay window has passed before removing the link/chunk from that node. It's an even better idea to not reassign that chunk to a different db…
filetoblob error with /dev/null
Greetings, The following statements: create temp table foo (x blob) with no log; insert into foo values ( filetoblob('/dev/null', 'server') ); Throw a "22: Invalid argument" error on one of our servers. However, I can run the same statements on a simple server (dev licensed), wit…
IDS and Kafka
Hi Folks, an interesting question today: does anyone in the community have experience in connecting IDS with Apache Kafka ? If yes, can you please share your experience. Thanks a lot and have a great day Eric ------------------------------ [eric] [Vercelletto] [] [Founder] [kando…
onkstore keeps crashing when configuring KMIP
| view attached Hi All, I am trying to configure KMIP Keystore in Informix. But the onkstore keeps on crashing. Not sure how to troubleshoot this. Any suggestions? ======= Creating a 'kmip' type keystore. *** Error in `onkstore': munmap_chunk(): invalid pointer: 0x00000000004afed…
Non Critical DbSpace drop
Hi Team, If I need to drop a non critical dbspace , do I need to drop all its tables first? If yes , how to see how many database and table inside particular dbspace and how to delete all tables at once from that dbspace? Please suggest. Thanks Amit Patel ------------------------…
Shared Memory Allocation
Dear Informix group user, Greeting from Amit Patel , hope all are safe and healthy in Covid-19 Era. I need a suggestion . In my new project , my customer has 1 TB of RAM and using only 38 GB as SHARED MEMORY with having 10 TB data size and they are feeling Server slowness. So far…
Upgrade with Success from Informix 11.70 to Informix 14.10
Are you running IBM Informix Dynamic Server (IDS) 11.70? Join this session to help with your plans to migrate from Informix 11.70 to Informix 14.10 with ease. Please note that Informix 11.70 will reach End of Service (EOS) on September 30, 2020. Upgrade with Success from Inform…
Storage Optimization Question
IDS 12.10.FC12 Solaris 10 1/13 Is doing a dbexport & dbimport of a database comparable to doing a repack, shrink, and defragment on every table? Thank you. David Grove ------------------------------ David Grove ------------------------------ #Informix…
Are there hidden gotchas w.r.t. moving sysadmin tables?
IDS 12.10.FC12 Solaris 10 1/13 I would like to drop a rootdbs chunk that is no longer needed... Except that it still contains a sysadmin table (happens to be ph_run). Is there any danger in using ALTER FRAGMENT to move that table to another dbspace, then DROP the (now empty) root…
Modernize your Data Warehouse and Analytics platform with Netezza Performance Server
Built on Cloud Pak for Data, the Netezza Performance Server is an all-new cloud-native data analytics and warehousing system designed for deep analysis of complex data volumes scaling into petabytes with minimal administration and tuning delivering smart insights at the speed of …
Logical Logs/Physical logs
IDS 12.10.FC12 Solaris 10 1/13 If you had to choose having a separate dbspace for logical logs or physical logs, but not both, which would you choose? I'm uncertain which is likely to generate more I/O. Thank you. Regards, DG ------------------------------ David Grove -----------…
Best practice to insert CLOB/BLOB with generic ESQL/C code
Hello, What is the best solution to insert CLOB/BLOB values from ESQL/C code, when you don't know the storage options of CLOB/BLOB of the SQL columns, because you write generic code that can execute any kind of SQL statement? To insert a CLOB/BLOB, you create / initialize an ifx_…
New RFE entry
I just posted a new RFE entry. Please vote for it if you think it may be useful: https://ibm-data-and-ai.ideas.aha.io/ideas/INFX-I-375 Here's the description: Allow specifying a normal dbspace for a BYTE or TEXT column to isolate IOs for the blob data from main row data for the t…
Informix storage limits
Hi community, I am trying to raise the profile within HCL of a couple of issues related to how Informix stores data on disk and get them on the Informix roadmap. If you have a large system you will be familiar with them already I am sure. They are the Informix data pages per frag…
Define ifx_lo_t as NULL to insert or query for NULL BLOB/CLOB
Hello, CLOB/BLOB columns can be NULL, if created without NOT NULL constraint... (tested with dbaccess/SQL) But in ESQL/C, how do you specify/check that an ifx_lo_t is NULL? I mean something equivalent to ifx_loc_t member loc_indicator set to -1 (null) or 0 (not null) Is this just…
Smart Blob Metadata Queries?
Can anyone let me know how to determine the metadata defaults for an SBSpace in code? I know that I can get that from "onstat -g smb" but I want to be able to query the info using SQL or UDR API functions. Anyone? ------------------------------ Art Kagel -------------------------…
Informix Mirroring?
IDS 12.10.FC12 Solaris 10 1/13 Is it possible to generalize and say that Informix mirroring is better than using 3rd party LVM mirroring? I raise an issue in this related thread: Solaris Volume Manager I presume that using the builtin Informix mirroring would avoid any such probl…
Write Problem w/ Solaris Volume Manager Mirror
IDS 12.10.FC12 Solaris 10 1/13 I have been using Solaris Volume Manager raw mirror metadevices for several years without any problems. But, today, I was looking over the documentation and read something I had never noticed before. It was a caution in the SVM documentation that w…
informix@IP: Incorrect password or user informix@IP is not known on the database server.
Hi Members, just joined 'cos I can't seem to work this one out. Been searching the Internet, but no solution that works for me. We are running Informix 10 on windows server 2003 in an AD domain. Yes, I know it is old, both Informix and Windows, but we cannot upgrade just yet. For…
CSDK 4.10 32bit on Windows Server 2019
Hello, do you have some experience with using 32bit CSDK 4.10 (32bit connect at all) on Windows Server 2019 Standard? For this server is specified CSDK 4.50 but this is released as 64bit only. Thank you. Leos #Informix…
Execution of Long Restores Remotely
Hi, As part of a Disaster Recovery Exercise, need to restore large instances (about 80GBs) remotely. Now there are multiple issues here: 1. The remote connection may time-out due to terminal session time limit, 2. VPN time limit; or 3. Some Internet issue. What are the best ways …
WATCH NOW: Informix 14.10 Now Supports Common Table Expressions!
Hello Everyone! Thank you for attending the webcast " Informix 14.10 Now Supports Common Table Expressions!". If you have any questions that we did not get to in the Q&A, or are watching On Demand please leave them below. For those who were unable to attend, watch the full webcas…
Informix Wingz?
Hi All, It's not a question about Informix, but I stumbled across a post introducing Informix Wingz. From that article, today I got to know that Informix created spreadsheet software a long time ago. Wingz had some powerful features like hyperscript, an internal scripting languag…
myimport error - "sqlreload: not found"
Greetings, I'm currently evaluating Art Kagel's myimport tool, mainly for performance reasons. I'm using an export generated via dbexport. AFAICT, I can run myimport against the export. However, when I run myimport, it fails when attempting to run the sqlreload script/utility, be…
Automatic conversion of ifx_loc_t (TEXT/BYTE) to/from ifx_lo_t (CLOB/BLOB)
Hello, We have legacy ESQL/C code using ifx_loc_t to handle TEXT/BYTE columns. Customers want now to replace TEXT/BYTE by CLOB/BLOB columns... and we would avoid to touch our ESQL/C code. Informix can support simple type conversion. For example, when binding an (int) C sqlvar to …
IFX_LARGE_PAGES experiences?
According to the documentation, IFX_LARGE_PAGES can have " significant performance benefits in large memory configurations". What is considered "large" here? We have around 400GB shared memory, but some small testing did not show any gain. Is this still too small to have a benefi…
Bizarre CM/Connectivity Issue on 12.10.FC14
All: I've opened a case on this behavior, but I'm wondering if anyone else here can replicate it. We recently updated our production cluster from a patched version of 12.10.FC12 (W1X1) to 12.10.FC14. After the upgrade, I noticed that certain queries were hanging. The common eleme…
how to grab the update statistics sql statements of a database
Hi folks as you know, dbexport generates the UPDATE STATISTICS sql statements of the exported database, at the end of the dbname.exp/dbname.sql file, which is obviously useful for the import phase. as you would have noticed, dbschema does NOT generate those UPDATE STATISTICS stat…
Decrease Size of Root Dbspace
IDS 12.10.FC12 IDS 14.10.FC3 (upgrading very soon, so if it can be done in 14 that would be great) Solaris 10 1/13 Consider the following scenario: Many years ago an experimental Informix instance is created. The Oracle S.A.M.E. (Stripe and Mirror Everything) method is adopted, …
HQ blues
Hello everyone. Just started to use Informix HQ. Before contacting support, I wander if you have encountered this problem. When trying to list Tables & Indexes in our main database (others work fine) HQ displays the error: Could not get the data. {{suffix}} In the HQ server log I…
Bad news for informix...
Just sharing... Very bad news for Informix here in Brazil. -- One of the biggest ERP here decides to abandon Informix support for one of the most popular modules. As far I know, this company ERP born and reaches his success with 4GL/Informix and now begins to kill it in their pro…
New feature request: A tmp database analogous to /tmp
https://ibm-data-and-ai.ideas.aha.io/ideas/INFX-I-372 Hi Y'all! My recent (and still ongoing tribulations) with another thread inspired me to com up with this idea for a new feature: A tmp database where public has resource privilege and all tables created therein are permanent t…
Block during checkpoint
Hi I need some input advise what could be wrong on my configuration. The users reported slow / hang performance during their processes. Is it normal during checkpoint there are blocked? By refer to online log , i got some weird situation which i never encounter at other places. …
Fast Recovery after correct shutdown
Hello, using IBM Informix Dynamic Server Version 14.10.FC3IE on Windows 10 Pro 64bit. I am a little confused reading my Informix log: 16:33:34 IBM Informix Dynamic Server Stopped. ... means, I hope, that instance was correctly stopped. I started the instance again... ... 16:35:4…
Strange message in online.log
Hi. I'm upgrading from 12 to 14 on new hardware and I have a SDS setup. On the secondaty, I get this in online.log when starting the server: 05/20/20 10:07:14 DR: Warning: The table minversion DBA feature is enabled on this secondary (flag with value 0x400000 of the SQL_DEF_CTRL …