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…
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 -----------…
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…
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. …
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…
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…
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…
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 …
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…
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…
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…
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…
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 …
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…
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…
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…
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 …
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…
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 …
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…
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…
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 --…
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…
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…
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…
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…
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 ------------------------…
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…
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_…
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 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…
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 …
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…
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…
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. …
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 …
how to manage comments for tables and columns?
Hi All, The customer asked how to use the comment function to describe tables and columns in Informix. I explained that Informix does not provide the ability to write comments for tables and columns. How do other customers using Informix manage specifications on tables or columns…
Informix client address sanitizer heap-buffer-overflow with 16 bytes in user name of CONNECT TO
Hi all, Just found what looks like a bug in Informix ESQL/C... (detected with gcc address sanitizer) With the CONNECT TO instruction, when providing a user name with 16 bytes, I get a heap-buffer-overflow. When user name is 15 or 17 bytes long, no issue... quite strange. Are HCL …
ESQL/C: DESCRIBE, DESCRIBE OUTPUT and DESCRIBE INPUT
Hello! I get a bit confused when reading the ESQL/C doc about the DESCRIBE, DESCRIBE OUTPUT and DESCRIBE INPUT statements... What is fully supported and what is recommended today, to get fetch buffer information (SELECT list) as well as input parameters (INSERT/UPDATE/DELETE, and…
gTA cannot be killed
Hallo, IBM Informix Dynamic Server Version 12.10.UC12W1 SUSE Linux Enterprise Server 11 (x86_64) VERSION = 11 PATCHLEVEL = 4 My problem: onstat -x shows this row: 548c29c 8 -TB-G 0 12 152835:0x1581128 152835:0x1581768 DIRTY 00:00:00 0 onstat - k shows: 4729d818 0 (…
ALTER TABLE to change CHAR/VARCHAR/LVARCHAR to TEXT
Hello, I am looking for a pure SQL (or maybe using some stored procedure code) to change a CHAR / VARCHAR / LVARCHAR column to a TEXT column, with data inside. I know there is a CLOB type but we want to use TEXT. It must not use dbaccess (LOAD/UNLOAD): It must be pure SQL or SP t…
Reading functional index from systables
Hi! I´m currently trying to read the information of an functional index from the systables. The only way I find out, was to use the indexkeyarray_out(sysindices.indexkeys) - Function. But I found no official documentation for this (only errors after upgrade). Only this page here:…
Table and index defragment
Hi, I am having some problems with fragmented tables over several customers, as I have several indexes and constraints is there any way to achieve this problem without having to reconstruct everything? Is there a procedure in sysadmin for this? Has anyone had similar problems tha…
Who is BeMyApp? Targeting members of IBM forums?
Hi Y'all. I just got an email from no-reply@bemyapp-mail.com , informing me about a new question posted. The lead text reads: [IBM USER GROUP DAYS] NEW QUESTION NOTIFICATION With a button inviting me to [SEE THE QUESTION]. I foolishly failed to notice the unfamiliar "from" line…
Promoting RSS nodes
Environment: IDS 12.10.FC12 running on CentOs 7.6.1810 Picture this... PROD | DR | ifxdb01 ifxdb02 | ifxdb03 ifxdb04 Pri Sec | RSS RSS | PROD site is Lost …
DELIMIDENT
All: We have a[n ancient] app that has a bunch of special characters in object names, which requires DELIMIDENT to be set. The problem is, if it's set at all , even to empty string , it's considered "set" and double-quotes are taken to signify identifiers rather than constant str…
Long Running Purge Script
Hi, A purge program is submitted nearly 48 hours ago and is still running, probably deleting huge data (not run for some years). IDS is 11.50 and client program is in 4GL. Some of the parameters are: LTAPEDEV=/dev/null LOGFILES 42 LOGSIZE 3000 (KB) #BACKUPLOGS=Y (commented) LO…
IDS 12 Bug
Discovered a bug in IDS 12.10 this week that may also exist in 14.10. If you have any tables that start with "aqt," they will be ignored by dbaccess (when getting a table list), dbschema and dbexport. There are special "aqt" views that are apparently used by the warehouse acceler…
Table Recycle Bin?
Greetings, Family. One of my users is asking about a feature he claims exists in Oracle: A sort of recycle bin for table recently dropped tables so that after the initial OhNo!second when you realize what you've just done, the table can be quickly restored. Well, I've editoriali…
Informix NUMA shared memory access
Are there anyone running Informix on VMWare, and also on HP SuperDome Flex? Or any NUMA architecture at all? I'm interested in shared memory access patterns across the NUMA nodes. We are running an instance with approximately 400GB of shared memory on an HP SuperDome Flex, Intel …
Informix and Hyper-threading
Just curious about people's experience with Hyper-Threading. Despite what the vendors say, I have yet to test a dedicated Informix server and find hyper-threading active to be a good thing. Currently battling with sysadmins who refuse to believe me, the documented results or te…
Undocumented feature: DIRECTIO enabled for temp dbspaces
Apparently, temp dbspaces with cooked file chunks don't have DIRECTIO enabled from the get go. And so there is an undocumented feature that allows you to turn that feature on: starting with 12.10.xC13, 14.10.xC1 you can enable DIRECT_IO for temp dbspaces as well. - just not doc'd…
Informix v14.10.FC3 & client csdk versions
A while back I upgraded one of our development servers to IDS 12.10.FC7. on AIX 7 OS. The bundle I downloaded from PAA site included the client sdk/esql and after the 12.10.FC7 install & upgrade the csdk version showed : IBM Informix CSDK Version 4.10, IBM Informix-ESQL Ver…
down chunk
Informix 11.50.FC6 on HP-UX 11.31 PA-RISC We're working toward upgrading to 14.10 on Linux, but until then, we're running the environment shown above. Since 11.50 is way past EOL, we're kind of out of luck for support from IBM/HCL. If it was a production system, I might try to …
Partitions numbers at beginning of onstat -g ppf
Hi folks This is a completely non-critical question, of no consequences to my current client. But the curiosity is just nagging at me! Consider the following query on sysmaster:systabnames: select hex(partnum) partition, dbsname[1,18], owner[1,18], tabname[1,18] from systabnames …
DBACCESS_COLUMNS environment variable
Hi, The DBACCESS_COLUMNS environment variable doesn't seem to be found in the knowledge center. Does anyone know what the maximum value is? ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------ #Informix…
Defect related to using the lpad function of version 12.10.FC14
Hello All, I would like to share the defects found in the Informix 12.10.FC14 version of the customer's development environment. If the source string of the lpad function is an empty string, -202 error occurs as shown below. So was the rpad. If the locale of the database is en_us…
RE: Table or index partition? Flags in sysptnhdr
I was also thinking about how to separate tables and indexes through sysmaster, but I gave up because I couldn't identify the flag value. That's a good tip! ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of -------------------------…
Table or index partition? Flags in sysptnhdr
Hi folks. Back in my usual form, verbose as all get-out, for fear of being misunderstood. (I wouldn't mind so much being a misunderstood genius, but I'm missing a vital attribute to fit that designation. :-) Bottom line at the top: How can I tell from the sysmaster "tables" alon…
What are the changes to InformixHQ?
Hello All, Informix 12.10.xC14, which was recently released, contains version 1.1.1.2, and 14.10.xC3 contains version 1.1.1. Does anyone know about the documentation plan for changes made to each version of InformixHQ? ------------------------------ SangGyu Jeong Software Enginee…
RE: I'm looking for Informix training materials.
Hi SangGyu, Using our virtual training system of WebEx, ssh, and VOIP, as Art mentioned, we have taught classes around the world. All our classes have been upgraded to 14.10. I recently taught an Advanced Informix Performance Tuning class for a group in India using our virtual …
RE: I'm looking for Informix training materials.
Hello friends. Some time ago we had Informix in a box, used on Informix On Campus. They had a very good material for a course. But seems after Developerworks migration, all went away (I cannot find it anymore). Maybe somebody from IBM might know where it is...? Alexandre Marini -…
RE: I'm looking for Informix training materials.
Hi Saradhi, I don't know if it's ok to upload bootcamp resources to the community. Please let me know your e-mail address and I will send you the material attached to the e-mail. ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ---…
I'm looking for Informix training materials.
Hi All, I would like to provide Informix technical training to my team. Are there any Informix 14.10 training materials? I have 12.10 version of Bootcamp Presentations but I want to train with the latest version. ------------------------------ SangGyu Jeong Software Engineer Infr…
fallocate function during create dbspace
In the IIUG2019 presentation (B01~Geib~Whats_New_in_Informix.pdf), I read about the posix_fallocate () system call and ran a simple test scenario. Testing was done on CentOS 7.6, Informix 14.10.FC3 Developer Edition, Informix 12.10.FC10. As explained, it should be created immedia…
Informix DNS Warning
Hello everybody, I have an Informix 12.10.FC13 server running and lately I have been seeing the following message on my online.log: "02/24/20 13:31:02 WARNING: Detected slow or failing DNS service response 1 time(s)." Does anyone know what is this message about? Thanks, Regards …
RE: User Defined Routine (UDR) example required - OSAD Array
Hi Paul, I don't know how to answer your question about the stack. I guess you are asking for the debugger's data. I'll try again to see if I can make that debugger to show something I can understand following your instructions. So far I have the feeling that the engine fails wh…
sysblobs.spacename: partition, dbspace, or family
Hi Y'all. My current client has a fair number of tables with text and binary blob columns. However, no blob spaces; all blob column are in the TBLspace with the row. (Of course on pages separate from the row.) So I got curious about the way they are tracked and I ran this quer…
RE: LIKE and Regular Expressions AKA regex in SQL
If the scheduler is not running you will have to install the REGEX blade manually using the API function for installing datablades. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer:…
RE: LIKE and Regular Expressions AKA regex in SQL
Theo, Is this documented or valid for release 12.x? I cannot find it in either of the Informix Guides to SQL. Still, I will test the syntax and see if it flies. ------------------------------ Jacob Salomon --- Nobody goes there anymore, it's too crowded. --Attr: Yogi Berra ---…
LIKE and Regular Expressions AKA regex in SQL
Hi Folks. I have need for SQL that will match strings like sbstemp1 or sbstemp13. That it; my whole question in one sentence. Lest you suspect that I'm an impostor posing as Jacob, here is some commentary n wht I have tried: The Guide to SQL Syntax tells me all about a single-di…
RE: How to get open cursors by session
Check out the s yssdblock table in sysmaster. The sdb_name column contains the cursor name which you should be able to relate back to the application: > select * from syssdblock; sdb_sessionid 71 sdb_sdbno 0 sdb_iscurrent Y sdb_name slctcur sdb_id…
How to get open cursors by session
Hi, I was investigating about how to get current opened (active) cursors in server. Preferably, getting a SQL query to sysmaster will be the best but also onstat command would work. Reason for this question is to make a quality assurance of a program and we're not sure this progr…
RE: 14.10 installation blues
I know you did but did you bounce the engine – this should just work. I can install the license in flight but you need a bounce to activate – at least in my experience ------Original Message------ Call support. It sounds like it should be working. Art #Informix…
14.10 installation blues
Hi. I'm trying to install 14.10 on RHEL 8. I have had numerous problems and have opened two cases with tech support.I'm posting here because they have been silent for a couple of days. :( 14.10 on RHEL 8 is supported according to this: https://www.ibm.com/support/pages/informix-s…
RE: User Defined Routine (UDR) example required - OSAD Array
Thanks for your answer, I found a book in Amazon (ISBN 978-0130137098 ) entitled "Informix Dynamic Server.2000: Server-Side Programming in C" by Jacques Roy from 1999. It seems to me too old. Do you think it would still be a useful book?. I have the routine in 4Js Genero, I wil…
User Defined Routine (UDR) example required - OSAD Array
I need your guidance, please. I am looking for an example code for a User Define Routine (UDR) made in C or C++ in order for me to create one to be used in stored procedures and SQL statements. I've found none in the internet and none in github. I need to implement the Optimal S…
Repeat or Kill a stalled operation
Hi Family. My current client seems to be doing something strange in their web-based application servers. First the intuitive way I would do it at first instinct: If DEADLCK_TIMOUT (spelling?) is set to 60 seconds, it seems perfectly legit for my own database access to be set wit…
RE: Upgrade IDS
Thanks Art and Luis for the competent and quick answer. Now I know what happened and what I have to do. Have a good time. Heinz WESTFLEISCH SCE mit beschränkter Haftung, Hauptsitz: Brockhoffstr. 11, 48143 Münster Amtsgericht Münster: Gen.-Reg. 448 Aufsichtsratsvorsitzender: Josef…
Upgrade IDS
Hello everybody, during inplace upgrade of the database IBM Informix Dynamic Server version 12.10.UC4 to IBM Informix Dynamic Server Version 12.10.UC13 the following error -530 is written to the log file: ===========================================================================…
RE: What is the maximum number of pages for an index in Informix 11.70?
Art: Until Informix 11.7, I thought that the maximum number of pages for an index fragment was 16,775,134(2^24). But it was totally wrong! I think I need to study the storage architecture again. Thank you for answer. ------------------------------ SangGyu Jeong Software Engineer …
What is the maximum number of pages for an index in Informix 11.70?
Hi All, I read a post on Informix's Index fragment page limit on Ben's blog. https://informixdba.wordpress.com/2014/04/22/index-fragment-page-limit/ According to the Informix 12.10 knowledge center document, the maximum number of pages per index fragments is 2,147,483,647. The da…
RE: IBM Informix Dynamic Server Version 12.10.UC4W1
Hello SangGyu, many thanks for your response. I also believe that it is the defect you indicated. Your information will help me decide what to do. Have a nice day. Greetings Heinz WESTFLEISCH SCE mit beschränkter Haftung, Hauptsitz: Brockhoffstr. 11, 48143 Münster Amtsgericht Mün…
IBM Informix Dynamic Server Version 12.10.UC4W1
Hi there, operating system: SUSE Linux Enterprise Server 11 (x86_64) VERSION = 11 PATCHLEVEL = 4 We occasionally have the following problem with a database: 02/07/20 11:51:44 rowalter: PTOCOPYVC: collen (0xb4) > max_vc_len (0x33) (cmpoff: 0x22, uncmpoff 0x22 02/07/20 11:51:44 …
YIKES! 12.x documentation for onstat -g opn does not match the output
Hi Folks. I'm tyink I've managed to work around my ignorance of the sysmaster tables in relation to onstat -g opn. However, I have another hurdle here. Not critical, I think, but someone need to update this. Here's the sample output in the 12.0 Administrator's Manual: Even Pau…
When will the 12.10.xC14 Fix Pack be released?
Hi, I looked at the Informix Roadmap last year and expected the 12.10.xC14 fix pack to be released in 4Q 2019, but it hasn't been released yet. Will 12.10 take 10 years from GA to EOS, like 11.50 or 11.70? For 11.50, the official Fix Pack 11.50.xC9W3 was released in 2Q 2013 and E…
WATCH NOW: New Remote Encryption Key Storage in Informix Database Server 14.10.
Hey Everybody! Thank you for attending my webcast New Remote Encryption Key Storage in Informix Database Server 14.10. If you have any additional questions that we did not get to in the Q&A, please leave them below. For those who were unable to attend, watch the full webcast here…
Automated HDR/RSS Failover
Good Morning Informixland, IDS 12.10.FC9AEE AIX 7.2 We typically have failover exercises between data centers and I have a set of manual procedures that work quite well (saving the secondarieshowever it is time to automate. I amwondering if anyone else has done this and how. The…
remove nonprintable character
Hi My client had a problem extracting data from the Informix database and opening it in Excel. When the customer extracted the data, special characters like chr(10) or chr(13) had already been removed, but still displayed incorrectly in the cell. (A few cells are pushed away, or …
onstat -g opn: What sysmaster tables will get me this info?
Hi y'all. I have a situation here where we are trying to track down high-impact users and what tables they are hitting. I already have a query on sysptprof that tells me (if crudely) what tables are getting hit the most but that doesn't tell me who's doing it. Here's a sample o…
RE: The rowid column does not exist in the user table.
onstat -g cfg full AUTOLOCATE You might inadvertently have got a (signle-fragment round-robin) fragmented table -> check 'oncheck -pt' or query systables/sysfragments for table in question. BR, Andreas ------------------------------ Andreas Legner ------------------------------…
The rowid column does not exist in the user table.
Hi, I noticed that since the 12.10.xc13 version, no rowid columns are created for user-created tables. When I try to query the rowid column I get an 857 error. So if you need a rowid column, you should use ifx_row_id. Catalog tables such as systables had a rowid column. Of course…
Informix 14.10 documentation
In versions 11.5, 11.7, and 12.10, when you would go to the Informix documentation website, there was a link to download the entire library of books as a zip file. For example, if you go to the 12.10 documentation page , you'll see a "More information" block, and the first link …
New utility: fcopy-table.pl, Perl application to copy/extract one table or view to another table
Hi Family. As Art knows, I've been fighting with github and sourceforge, trying to get my new utility into the SQL-Tools section of the repository. While that issue gets resolved, I figured I could share it with my community by posting it in a shared folder in my Google Drive. T…
Can I request Case Open for Informix 11.50?
Hello. The following documents describe the options for users to receive support from IBM after End of Service. Informix Continuing Support Offering https://www.ibm.com/support/pages/informix-continuing-support-offering IBM Analytics new support option- Continuing support after p…