Threads from 2019
Browse by month: Jan · Feb · Mar · Apr · May · Jun · Jul · Aug · Sep · Oct
Database dafault dbspace
Hi, I want to know the default dbspace of all my databases, i used to check it out with the onmonitor utility, but now it's gone. Is there any query to sysmaster to know this data?. Thanks in advance.…
Connection Manager using SSL
I am trying to connect connection manager (conman1) to the IDS (mambaps) using SSL. I have configured the IDS correctly and tested through dbaccess from the connection manager server and from a windows machine with ODBC and it connects with no problems. My issue is when I try to …
TOP 50 SQL Queries by CPU/Memory/IO
Informix Version : 12XC12 Operating System : Linux Hi all I am looking for tools or script that can give the the top X queries that utilize the most 1) CPU 2) Memory 3) I/O on daily basis. Talking to a support engineer for advise, the only recommended tools is InformixHQ whic…
ADO - activex data object
What do I require, to connect "ado activex data object" to Informix ? AIX 7.2 IBM Informix Dynamic Server Version 12.10.FC9W1 Regards Dirk…
Connection Manager Redundancy with DRDA Connection
I have two Connection managers configured with two SLA entries using REDIRECT, one for the native SQLI connection (onsoctcp) and one for DRDA connection (drsoctcp) connection to just on IDS for testing. Everything looks good between the connection managers and the IDS. When I tes…
Get largest table in database
Hi all, I need to get the largest tables in terms of size/ rows from informix database. Do we have any query or any specific procedure that we can get the tables list? Thanks in advance…
PDQ mixed with OLTP
Hi, First of all good morning to all of the members just want to ask if anyone had done mixing PDQ with OLTP on their database? Our database is mostly OLTP with a batching process running every 12 MN of weekdays up until 3AM, I am wondering if I can use PDQ for the batching proc…
How to get the hour of a DAY TO MINUTE interval?
Dear colleagues: I have to get the total hours worked by "N" employees for a year. I have the entry and exit records of each of them, which I obtain from an electronic clock. The date format is a DATETIME YEAR TO FRACTION (3). When I subtract the entry from the exit, I get an I…
Problems with LOAD FROM
Dear colleagues: I ask for your help with a topic as trivial as it is to import data from a plain text file, but that is driving me crazy. I need to import data from a SQL Server 2005 to Informix. Just working with SQL Server is an odyssey, but I managed to generate a .csv file…
Downgrade informix client tools
Hi All, We are having issues with running sperform tools on informix client. It seems that these servers have a higher version of sperform than ISQL. We are not able to execute some forms on these servers. IBM INFORMIX-SQL Version 7.51.FC2 <-- 7.51.FC2 This higher version on …
InformixHQ - Backup sensor
Hello. I have set InformixHQ Backup Sensor to notify me whenever Backup Level 0 is greater than 24 (hours). But is always notifying me, does anyone know the exact value for this metrics in InformixHQ?…
RSS over SSL
Hi, I am trying to setup one RSS server using SSL, can someone give some help about this? Thanks in advance, SP…
Problem with backup
Hello, every time we release a copy with onbar , the Database server gets blocked one to three minutes. Is this normal ? Our version is 12.10.FC3WE and the command is onbar -b -w Thanks…
RE: how to pass char parameters into C UDR.
Dear All, I can write a C UDR which containing the parameters of the integer data type. The C UDR can get the value of parameters of the integer data type. But when passing the parameters of the char data type, the C UDR gets the x00 of those parameters. Please show me the code…
Auditing?
IDS 12.10.FC12 Solaris 10 1/13 In the past, we have not been very concerned about auditing. But, things are changing, and it seems that some managers now want to "take it to the limit", auditing-wise. Having poked at onaudit briefly, several months ago, I have limited experienc…
Trigger order
Hi, We are running Informix 12.10.FC9W1 on Solaris. We have multiple insert triggers on a table. Is there a way to enforce that the triggers should get executed in a particular order? Thank You, --Dave…
Phys Log Size Inconsistency?
IDS 12.10.FC12 Solaris 10 1/13 I am working on a test platform, and, while importing a database, I'm getting messages in the online.log suggesting an increase in the physical log size. Here is an extract from the log: [BEGIN LOG EXTRACT] 09/05/19 10:57:14 Performance Advisory: …
Informix 14.10 Innovator
Hi I am trying to activate the Innovator edition of Informix 14.10. After installing the developer edition I run ie_edition.jar and it finishes without any error. But oninit -version gives me Build Version: 14.10.FC1DE Is there something I am missing? Best regards…
SSO (Kerberos) on Informix / ODBC
Hi all, Using Kerberos 5 authentication on AIX for standard domain user logon is working fine already. Now I am going to implement Kerberos for Informix to use remote ODBC connection. This causes troubles. Some details on the current system and configuration: OS: AIX 7.1 Infor…
Physical Log size
IDS 12.10.FC9W1 AIX 7 I am trying to calculate if our Physical Log size is big enough. My reason: Checkpoint Completed: duration was 171 seconds. Sometimes we get hit by large checkpoints. From the manual: ---------------- To ensure that you have an abundance of space, set the …
Partition Blob page warning
Hi all, I m new to informix, kindly correct me if am wrong. our environment is linux and informix version is IBM Informix Dynamic Server Version 11.50.UC6WE Recently we had a table corruption in our database, so we ran "oncheck -cDI -y datbase:schema.tablename" for that partic…
"hits" reported by 'onstat -g prc'?
IDS 12.10.FC12 Solaris 10 1/13 I run 'onstat -g prc' and examine the output for a particular SPL. I observe a number (12) reported under the "hits" column. I believe this indicates that the particular SPL I am interested was accessed from the cache 12 times. Since when, though…
PC_POOLSIZE?
IDS 12.10.FC12 Solaris 10 1/13 How does PC_POOLSIZE get changed? In our ONCONFIG file, the PC_POOLSIZE parameter is entered as: PC_POOLSIZE 127 The first few lines of 'onstat -g prc' are as follows: informix@ifmx-prod-anc>onstat -g prc|more IBM Informix Dynamic Server Versio…
Re: Monitoring SPL Executions?
"I simply pull from "onstat -g prc" ... my watcher runs constantly and picks up any and all SPLs (seen before or new), tallying them so I always have a datetime|procname|executions_at_that_time record. This actually came in handy recently to find most used SPLs - never thought it…
BTS-Query on RSS Secondary
informix:IBM Informix Dynamic Server Version 12.10.FC12 OS:SUSE Linux Enterprise Server 12 (x86_64) VERSION = 1 PATCHLEVEL = 3 Problems doing a BTS-Query on RSS-Secondary after INSERT/DELETE on Primary. I have created a Sbspace(-Df "LOGGING=ON") and also a temporary Sbspace. B…
memory monitor
HI, I use informix version 12.10, How to monitor below memory through SMI? dictionary cache; table statistics cache; ...... thanks for your time. Lu chuan…
Spaces and Spindles: Thought Experiment
IDS 12.10.FC12 Solaris 10 1/13 Consider a new Informix instance with db/sbspaces (all 1 chunk) as follows: 1) dbspace for the database catalog and data tables; 2) dbspace for indexes (16K pages); 3) sbspace for sblobs (photos-- relatively infrequently accessed); 4) root dbspace …
Load from external table issues
Dear All, I am doing unload/load to external tables in order to speed up the process of dbexport/dbimport for huge tables. However, I get an error 26168: Conversion err:(file,offset,reason,col)=(xxxx) so my assumption is that we have some data in the char fields in the tables t…
AggregateRange with unamed type
hello everyone, i'm working on IDS 14.10 and I'm trying to collect the results of aggregaterange on certain fields of my timeSeries but not all of them. I have found the following which works: create row type elemval2 ( tstamp datetime year to fraction(5), tstamp2 datetime year …
enumerate contents of sbspace?
IDS 12.10FC12 Solaris 10 1/13 How might it be possible to exhaustively enumerate all objects within a given sbspace? That is, for each object in the specified sbspace, list the database, table, and column which is associated with that object? Thank you. DG…
Moving the logs, or not?
IDS 12.10.FC12 Solaris 10 1/13 Consider an instance in which the logical and physical logs are retained in the rootdbs. Do you think there would be any benefit in moving the logs to their own dbspaces, IF those spaces were still on the SAME SPINDLE as the rootdbs? DG…
14.10 Apparently Not Supported on Solaris 10
IDS 14.10.FC1 Solaris 10 1/13 I learned something that completely surprised me, today. During the last few days, I installed IDS 14.10.FC1 on a Solaris 10 (Jan/13) platform. It had a prior instance of 12.10 installed, so I was trying an in-place upgrade. At first, 'oninit' fai…
Where oncheck -pt information is stored
Hi, I'm trying to find out the date a fragment of a table was created, it's easy to see with oncheck -pt, but i want to query any table to get the same results. Does anyone know where i can find it?…
RSS_NONBLOCKING_CKPT?
IDS 12.10.FC12 Solaris 10 1/13 We are preparing to install 14.10 on a test platform. There are a few new ONCONFIG parms to consider. One of them is RSS_NON_BLOCKING_CKPT, which, according to the documentation, enables or disables non-blocking checkpoints on an RSS. The documen…
BTS/C-Lucene issues
Hi All, Informix 12.10.FC4, on AIX Solaris 10. My issue concerns an index utilizing BTS. At some points, it returns zero rows found for every search.... and then some time later, simply starts working again. I have tested enough to know that the problem is most likely related …
thread soctcplst in ready state
Hi, Environment: Informix 11.70.FC8W1 HP-UX 11.31 Today a large number of errors -25582 and -27001 have been reported on one of our instances. In the online log: listener-thread: err = -25582: oserr = 0: errstr = from <host.domain> to server <informixserver> : Network connect…
Informix 7.30 failed to start
I am maintaining a legacy system using informix 7.3. The system has crash recently. At the start of oninit, the logs file shows that there is an error after logical recovery process. Also from oncheck -cR there are invalid entries in the logical log. Is there anyway to skip logi…
Error -742?
IDS 12.10FC12 Solaris 10 1/13 Recently we tried to add a DELETE TRIGGER to a table. Got a -742 error (foreign key with cascade delete cannot coexist with a delete trigger) because the table had a FK with cascading delete. Might anyone explain why a delete trigger cannot coexis…
RSS over SSL
Hi, I have done some installations of RSS solutions. I use to connect the RSH servers, but now I want to use SSL. Are there any special requirements? Can someone give me configuration examples? Thanks for any help, SP…
LAST ACCESS control
Hi, I am having some problems to identify last access on my databases; I am trying with: oncheck -pT to know last disk access; or with select max(ustlowts) form systables. But, I have some doubts about these results, is this correct? is there any other way to know when the l…
JDBC ENCCSM problem
Hi, I have a problem with JDBC and ENCCSM (only with aes(xxx). First i explain my environment: Informix server: * IBM Informix Dynamic Server Version 14.10.FC1 (linux) (Test server) * concsm.cfg: net_sec("/aplicacions/informix/lib/csm/iencs11a.so", "cipher[aes256:cbc], mac[l…
CDR Sync for ER
Hi All, Well, it's been a bit of a journey (thanks to those that I've reached out to privately for assistance), but I finally seem to have ER/GRID established between IFMX v12.10.FC4 on Solaris and IFMX v12.10.FC12 on RedHat! However, I came across something that has me absolute…
sysadmin task control
Hi, Can someone give some help about managing tasks over sysadmin? In the past I have used OpenAdminTool, but now I don't know how to do it. thanks for any help, SP…
Fragments and Extents
Hi, I am facing some problems with some tables that are growing fast and getting fragmented. I have looked for some kind of procedure to identify and correct this. Can someone give me some help to solve this problem? Thanks in advance, SP…
informixHQ automatic start over systemd
Hi, For automatic start of informixHQ on CentOS 7, I have created 2 daemons with this content: sudo vim /etc/systemd/system/informixHQ.service #**************************************************** [Unit] Description=Informix HQ Server After= informix [Service] WorkingDirector…
Publications for the IBM Informix 14.10 family
Hello, Does anyone know Where I can find pdf documentation for Informix 14.10 version ? I have only found 12.10 version in https://www-01.ibm.com/support/docview.wss?uid=swg27023505#Pubs Thanks a lot,…
New version Informix 14.10
We are IBM business partners, some clients have the Informix Advanced Workgroup version that includes the Informix Warehouse Accelerator product. In the new version of Informix 14.10 there is no Informix Advanced Workgroup version. My question is what happens with this licensing?…
Join Char and Serial
Hi, We are running Informix 12.10.FC9W1 and have a scenario that we need to join 2 tables and join on columns where 1 column in table_char is a char(13) and the other column in table_serial is serial. Based on certain flags in table_char we know that the values in char(13) will …
Number of logical logs growing ?
Hi all, I'm doing some tests on ( new for me ) old 12.10.FC9IE I have configured it on a small machine, and created a couple of small ( less than 1G ) databases. I've then moved logical log from rootdbs to a dedicated chunk, and so far so good. What I'm noticing is that the numbe…
RSS: Different # CPUs?
IDS 12.10.FC12 Oracle T4-1 Solaris 10 1/13 We are contemplating new hardware purchase. Specifically, several Oracle/Fujitsu M12-1's. Initial purchase would be with 3 cores activated (out of 6 available on machine) for our production server. Wondering about using one of them fo…
Identifying types of temporary tables
Hi gurus, I want to catch de application that is consuming a lot of space of temporary dbspaces. I know there is no direct way to associate sessionid with use of temporary space. Moreover, there are temporary tables that are created internally by the engine. Do you know when is…
Fri May 24 08:27:36 CEST 2019 Hora Con Data Con
Hello, everybody. We are preparing the migration from Informix V12.10 to V14.10. We have created a test environment and we are seeing some drawbacks in the migration that make us doubt. From the beginning we have observed that if you don't recreate the statistics the performanc…
Windows server informix perfomance 12.X vs 11.X
Hello, i have a strange behaviour, maybe somebody can help. Short: Windows Server 2008R2 x64bit with 2 Informix installations. Installation are "default" no changes on parameter. One Installation Informix 11.7, the other 12.10. Created "demonstration database" for 11.7 and 12…
Change to Forum email submissions
Folks: The IIUG Board of Directors has moved out email service to a new platform. As a consequence you will no longer be able to submit Forum posts and responses to Forum posts via email and will have to use the web interface. Note that the Board is working with IBM to replace …
New IIUG Software Repository
The IIUG Software Repository has been moved to Softforge. You can navigate there from the IIUG main page <Resources> menu or use this direct link: http://www.iiug.org/en/iiug-software-repository/ Art…
4gl not ending FOR loop thru file for IDS ver 12.1
Question, we are using a 4gl program code that reads a file, which contains email addresses. In IDS 11.50, we do not have to add a blank line at the bottom of the list file. We are having to add a blank line to the bottom of the list file while using IDS ver 12.10. Otherwise the …
Need some help with INFORMIX/IREACH
Hello everybody, I known it is very long time since Ireach is not supported by IBM any more, but still there ara some customers who use it, and one of these is mine. I am looking for somebody who can help me in solving the following issue: This is the message: Error Code: -937 …
prevent automatic generation of sbspace
How can I prevent automatic generation of SBSPACE and automatic registration of BTS-Modul ? IDS 12.10.FC12 My Instance has no SBSPACE and no datablade is registered in any database. If a 'normal' user with connect right runs (can be accidental) a SQL-Statement like 'SELECT xxx FR…
FYI: ALL the informix latest drivers in one post
You have been looking for the most up to date Informix drivers and spent too much time on your research? here is the one-stop-shop for the Informix drivers! Please not the existence of the R language driver, which is more and more visible language. Make your choice: #ODBC, #JDB…
for sysmaster masters:syssqlstat Vs previous query
Hi, is there a table in sysmaster that will catch the query that has been running just before the current query ? I would like to query the last query that has been running for MY session (i.e this query must run in the same session), but syssqlstat, but if I run such query, th…
Error in SQL Linked server to Informix DB
Hi, I have a Linked Server pointing to Informix DB. Using this linked server I am writing query SQL to fetch the data and load in SQL table. But there are some tables exist which is throwing datatype overflow error. For a table I identified the column and the record which is caus…
User access control
Hi, I have problems to identify witch databases aren't used, I also think that is a feature missing on informix. I have created two functions and replicate them over my databases, but sysdbopen don't create any information about application that appears empty, sysdbclose don't r…
Connections over SSL
Hi, I have configured SSL for my informix server, now I would like to configure my clients to connect to him, but I am facing some problems. As I have windows clients to connect to my database, I don't found some concrete information/examples about how to do it. Can someone help…
Repliction Checking
IDS 12.10.FC9 AIX 7.2 Morn'n Folks, I want to be able to assure that my HDR/RSS replication is healthy and in sync. My idea was to create a table with one datetime year to second column, insert 1st systables.sysdate into that table on the primary then query on the HDR & RSS fro…
Cross-Server Query permissions
Hi, I have 2 servers on same machine, running under different users(auser,buser). On bserver i have: grant connect to auser; REVOKE SELECT ON btable FROM auser; Still i can make Cross-Server Queries, i think this should not be possible. [auser@test]$ echo "SELECT FIRST 1 bcol1…
configure sds with raw device
Hello all, I am looking for advice on how to configure Informix SDS. We are using Informix 12.10.FC10 Workgroup and are running on AIX 7.1. No Informix secondary server or cluster software is configured. And DBSPACE consists of raw device, not cook device (file system). I woul…
Checkpoint statistics
Hello all, I am posting the checkpoint statistics output below onstat -g ckp IBM Informix Dynamic Server Version 12.10.FC6 -- On-Line -- Up 2 days 07:38:02 -- 5318400 Kbytes AUTO_CKPTS=On RTO_SERVER_RESTART=60 seconds Estimated recovery time 23 seconds Critical Sections Phys…
temp table - get columns name
Hi, I'm looking a way to get the column name and number of columns from a temporary table inside of SPL. I need to get this columns name into a variable to use in a dynamic SQL. Does anyone know if is there any way or an internal procedure which can help me with that?…
dbspace encryption and upgrade IFMX in-place
Hi, did anyone experience this migration path: 12.10 FC10 to 14.10 WITH ENCRYPTED DBSPACES I have seen nothing in the migration guide on the IBM site regarding ENCRYPTION requirements. When my customer launches oninit in the new 14.10 environment, he gets and assert failed cle…
Creation on read only user.
Hello, 1. I have 2 user in my instance i.e. 'USER1' and 'USER2'. 2. 'USER1' and 'USER2' can Execute SELECT, INSERT, UPDATE, and DELETE statements as they gave got 'CONNECT' database level privilege, that comes with default 'PUBLIC' role. 3. I want to create 'USER3' that should…
dbexport/dbimport question
Hi, We are running informix 12.10 FC8 and setting up a dbexport/dbimport for database backups would like to ask th following. 1. Does dbexport includes the dbspace where the db resides? We have multiple dbs that are created on different dbspaces. 2. If #1 doesn't include the d…
12.10->14.10 with EaR
Hi I have a problem with migration from 12.10 to 14.10 with encryption at rest Main steps are: I have Informix 12.10FC12 with DISK_ENCRYPTION parameter Install Informix 14.10 in the different directory (install gsk8_64 too). Set correct INFROMIXDIR... Copy corresponding …
Informix 11.70: Stored Procedure SQL exceptions
Greetings, I've written an extensive stored procedure that has some dynamic SQL. I have an exception handler defined with the "With Resume" clause to continue processing if an error occurs. The trouble is, when the code is in a FOR loop and incurs an error, it drops out of the l…
EXTERNAL table read
Hi, How can I read one external table as an usual table, is it possible? Can I do select from one external table created by another program? As I only have seen operations over external table after create...??? Thanks for any help, SP…
Connections made to RSS are visible on PRIMARY
Dear All, Informix version 12.1FC10 on HP Unix and application running on RHEL 7 SET up has a PRIMARY, SDS and RSS We have a read only application that is pointed to RSS servers (direct connection to RSS server and NOT via Connection manager) When we start this application whi…
Django Framework Informix
Hi everybody, Does anyone how to connect Django Framework on Linux to an Informix 12.10.UC7WE server on Linux? My client reports the folowing error: Exception: [IBM][CLI Driver] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Comm…
ONCHECK & checkpoints
IDS 12 AIX 7 Can this command cause large checkpoints ? oncheck -cDI eppix:"informix".my_table my_table = 455 million rows…
TERMCAP dbaccess Ubuntu
I'm having trouble with dbaccess (12.10 & 14.10) running on Ubuntu 18.04.1 LTS under the Windows Linux subsystem. I have been unable to find a TERM/TERMCAP combination that allows the arrow keys and enter key to work. Please advise.... Walker…
Onlog - logical logs
Version 12.10.FC9W1 AIX 7 We had a session yesterday, we only caught it after the fact ... that did a lot of inserts and deletes - Checkpoint Completed: duration was 3216 seconds. We normally have 10 second checkpoints, maybe. So I started just looking into that logical log, an…
Blade issue?
IDS 12.10.FC12 Solaris 10 1/13 I have a database that previously had two blades registered. I unregistered both of them. When I use myexport and myimport on that database, I get a -9628 error identifying "sysbldsqltext" as a missing data type. "sysbldsqltext" is the data type fo…
Limit User Connections
Hi, We are running Informix 12.10.FC9W1X1 on Solaris. Is there a way to limit the number of DB connections based on User ID? Each user connects to the DB using their own user ID so we are not using connection pools. We want to limit on the Informix side and set a max number of c…
Log table change dbspace
Hi, I have one table for log that grow a lot, I would like to move it to another dbspace. But that table have several indexes and relations to another tables. How can i do it? Thanks for any help, SP sergio.peres@airc.pt…
Possible EAR issues on Informix 14.10FC1DE ARMv8
Hi, just noticed an issue with EAR on armv8. Setup consists of Fedora 29 on raspberry pi 3b+ and 14.10.FC1DE. During instance init: Initializing encryption-at-rest if necessary...succeeded Initializing encryption-at-rest structures (part 1)...FAILED Message log: 11:30:18 ICC …
dbexport failure
IDS 12.10.FC12 Solaris 10 1/13 On March 31, a contract we had with some software developers expired. I am taking down some resources, including an Informix database, that we supplied for their use during the contract. I intended to do a dbexport of their (experimental, developme…
Newbie: how to restore dumpfile on windows server
Hi, I don't know informix. I need to restore an Ontape dumpfile on my windows based pc. I have installed Informix server, but I do not know which is the correct procedure to use. Can anyone help me?…
4gl version 7.2 connection to ids 11 ?
Hi all, I was wondering if there is a chance to use old rds environment towards a newer database. I have some old 4gl programs, that actually runs on 7.2 version: informix@MyHost:~$ fglgo -v INFORMIX-4GL Version 7.20.UD7 Pcode Version 602 and was experimenting with an ids 11.x l…
Informix 14.10 Innovator-C
Informix 14.10 Innovator-C no available for download, why?…
Procedure to unregister a blade?
IDS 12.10.FC12 Solaris 10 1/13 I performed the following to unregister the BTS blade: informix@ifmx-prod-jnu>blademgr prodjnu2tli>list acoms DataBlade modules registered in database acoms: excompat.1.0 bts.3.11 prodjnu2tli>unregister bts.3.11 acoms Unregister module bts.3.11 o…
Determining blade usage (BTS)?
IDS 12.10.FC12 Solaris 10 1/13 I'm having some issues with the BTS blade that would go away if BTS were not installed (duh). I think that no BTS functionality is actually being used... But, is there some way I can determine, for sure, whether it is "safe" to get rid of BTS? Tha…
Transactions blocked in output of online log
Hi, I wonder what does it mean "Txns blocked" in output of online log. For example: 16:47:53 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 1, Plog used 1731, Llog used 1214 If Txns blocked=1 and Txn Block Time = 0.00 this info should really be called a tran…
Informix CSDK 4.50 download link - working
Hi friends. Just sharing, after searching a lot, found a working link: https://www-01.ibm.com/marketing/iwm/iwm/web/preLogin.do?source=ifxdl&S_PKG=410F C8dewin&lang=en_US HTH Best regards Alexandre Marini…
New release of utils2_ak
Folks: The March 16, 2019 release of utils2_ak is available for download from my website (www.askdbmgt.com/my-utilities.html). This release contains support for new features in Informix v14.10 notably the CREATE OR REPLACE syntax for procedures, functions, triggers, and views. …
onstat -g dis gives bad info
Hi All, Where does 'onstat -g dis' gather its information from? We have a server that is reporting an instance that should never have existed on that server. Server : legacy_tcp Server Number : 9 Server Type : IDS Server Status : Down Server Version: IBM Informix Dynamic Server …
Help with Delete Trigger
I need to write a trigger and procedure so that if a user sends a DELETE for a record in a table (not a view) then instead of deleting the record the action will update a field (a delete flag we're using) in the record. I have used the "CREATE TRIGGER xxx INSTEAD OF DELETE ON tab…
HQ over 14.10
Hi, I am trying to start informixHQ over 14.10 version but I am having some problems, I only make the agent start running the wizzard on setup option. The server show that is not working and I don't found any information about the setup process. Can someone help me? Thanks in …
More durable query
Hi, Is there any way to see how is the more durable query in informix between thousand of querys?. I mean, i want to know if one query is lasting for 5 minutes, other 3...and i can not enable any trace. Regards.…
Informix 14.10 out
Everyone - I was looking for the latest version of OAT, and realized this morning that the IBM Passport Advantage section has 14.10 Developer Edition available. There is also now an Informix Edition Installer as a separate download - appears to be a utility that you use to switc…
OAT latest
Does anyone have a link to or copy of the latest OAT? Thanks - Mark Scranton The Mark Scranton Group…
SET GLOBAL Variable in SQL Select?
Hello, All of the examples I can find show how to set a global variable inside SPL functions. Can values be assigned to global variables from within a dynamic SQL statement? I'm using Server Studio and have tried SET/LET but all I get is syntax errors. Thanks.…
One doubt
In Informix IDS 7.31 for Windows, the PSORT_NPROCS environment variable not exists or not works? Thanks in advance…
myimport Problem
IDS 12.10.FC12 Solaris 10 1/13 I am likely doing something blindingly obviously wrong... I am trying to use Art's "myexport" and "myimport" to speed up the export and import of a database. I tried the following experiment. First, I used myexport to export a database using exte…
Not sure if I have a problem with CKPs
IDS 12.10.FC12 Solaris 10 1/13 I sometimes observe a period of very frequent checkpoints. The system is a primary and there is one RSS. Here is an example of what I observe: informix@ifmx-prod-anc>onstat -g ckp IBM Informix Dynamic Server Version 12.10.FC12 -- On-Line -- Up 1 …
SQLServer to Informix conversion
Are there tools to convert SQL Server 2016 data into Informix version 12.10.FC6 on HP-UX 11.31. Ideally, this would be a conversion of a SQL Server archive (bak file) to a new Informix instance. If not, at the database object level. The current database size is 500 Gb.…
ER extent sizes
Hi all, Replicating: Informix 12.10.FC4 Solaris 10 --> Informix 12.10.FC12 RedHat I am setting up Enterprise Replication using OAT and running into an issue: the new tables created on the secondary server are created using 16/16 as the extent sizes instead of the defined values …
use of exists
Hi, I am trying to develop one query over databases to look for the existence of one table. I am using the exists clause but I am receiving error 206. My query is: select * from tableforsearch where exists (select * from tableforsearch) Is this the correct way to do it? How can…
-951 trap
Folks, IDS 11.70 AIX 7.4 Is there any way/method etc. to trap for the following authentication error and send out an alert to security admins ? (other than greping the msg log ) 951: Incorrect password or user is not known on the database server. Preferably would like to have…
column addition in er replication
We are planning to use er replication. During testing phase we created the replica using template but found that column addition is not being replicated. We did not find any switch/flag in defining or realizing the template that enforce the schema synchronization as we can do in …
Stored Procedure RFE
Hi, If you work with Stored Procedures and fell they are lack of resources, please check the RFE about. https://ibmanalytics.ideas.aha.io/ideas/search?project=INFX&query=procedure&utf8 =%E2%9C%93 https://ibmanalytics.ideas.aha.io/?project=INFX&sort=recent Vote to help them to…
Invalid Pool Name error
Hi All, I posted a question previously about a "bad file number" error I was receiving when issuing this command, "ism_op -mount /backups/txlogs". I haven't had any luck resolving it. Today I decided to try a work around. I Dropped the device "ism_rm -device /backups/txlogs" and …
SQLlines Converter Tool
Hi Folks, I have been tasked to convert an Informix database to PostGres using the SQLlines tool. Has anyone used this tool or performed a like conversion? I could use some help here. Thanx, Dan…
INH mutex
Hi, Does anyone know what area of the engine the "INH list" mutex protects? I am seeing a large number of waiters on this mutex under heavy load. I suspect it may relate to access to the in-memory lock table but I am really only guessing. I can't find any reference to this onlin…
Re: Open tables and threads
There is any query to get the same results like the "onstat -g opn"?…
ISM question on ism_op
Hi folks, Can anyone point me in the direction of which forum can help with this ISM error. I tried to mount my txlogs today on a backup server, the command I used was "ism_op -mount /backups/txlogs" I got the following error, "nsrmm: error, cannot open for reading: Bad file numb…
IBM Mysupport Page?
A few days ago, we stopped being able to get to the IBM Mysupport page (so we can login to our tech support cases). We get a page that says: "Sorry, something technical went wrong and the page is currently unavailable Please check back soon Go to IBM.com Reference ID: 18.15d…
Problems with archecker restore
Hi, i'm tried to restore some tables to file with archecker, but i always receive the same message: Scan PASSED Control page checks PASSED Table checks PASSED Table extraction commands 1 Tables found on archive 0 Tables not located on archive 1 LOADED: TABLE produced 0 rows -----…
select over another database
Hi, How can I do one external select to another database on the same server? I have looked over documentation and tried several forms but always get error. the form database:table it returns error on : I am using informix 12.10.FC12W1 version. I also would like to use one vari…
Moving SLOB columns to another sbspace
Hello everybody! We want to move several SLOB columns(CLOB-BLOB) from different tables whom reside in a same sbspace to a new sbspace for each table for backup purpose (to launch parallel backups and reduce the time takes the backup), for this goal, we want to know the approxima…
onlog output
Greetings, I am currently dumping logical logs for transactions related to a specific table to research an issue with missing data. In reviewing the output I have noticed a lot of entries for a given user id that just have 'BEGIN' to signify the start of a transaction and 'COMMI…
New release of utils2_ak
Folks: I have uploaded an update to the utils2_ak package to my web site (www.askdbmgt.com/my-utilities.html). This is the February 6, 2019 release package. I contains the following changes: dostats_ng.ec: Fixed issues with routines that have OUT and/or INOUT parameters and imp…
sql_runtime in sysmaster:syssqltrace
I am making some test for logging long running statements. very simple sql: informix$ time echo 'set pdqpriority 0; select count(*) from \\\\ systables,syscolumns,sysindexes' | dbaccess stores Database selected. PDQ Priority set. (count(*)) 7106352 1 row(s) retrieved. Database…
Performance Tuning
I am busy going through Mike Walker's slide show for Performance Tuning Basics. From this I created a script to display the long running queries on my system. Are there any other links related to this that you can point me to please ? Dirk…
creating transitory table
Hi Everyone, I have an requirement to use a temporary table which have to be created globally and need user level access to that table to view only particular user data. Same concept like GTT(Global temporary table) table. Is this possible in Informix, or any other way to fulfi…
collect user access
Hi, I have used one procedure to collect all access to my instance, but I am veryfing that there are to many duplicated records. Can someone help me to do it in the correct way, to have one record with the information about session, process, program, hostname and database. My pr…
raw device usage tracking
Hello, To avoid dealing with offsets, I create separate lvols for every dbspace and one of my instances is reaching > 1500 chunks/lvols (22TB). Thinking it would simplify disk usage management, I built a couple of large lvols of 1.2TB ea. and allocated them to the storage pool.…
myexport problem
IDS 12.10.FC12 Solaris 10 1/13 I am attempting to try myexport/myimport in hopes of getting faster export/import times, compared to dbexport/dbimport. I ran 'myexport -ss <database> -E >out 2>err'. But, it does not run to completion. Stops (although seems to be waiting for inp…
EXTERNAL TABLE issue?
Informix 12.10.FC12 Solaris 10 1/13 Consider the following SQL: CREATE EXTERNAL TABLE ext_tbl( data_row CHAR(978) EXTERNAL CHAR(978) ) USING ( FORMAT 'FIXED', DATAFILES ("DISK:/home/informix/ext_tbl.file") ); It executes with no error reported. Now consider the following S…
HDR simulation and docs
Hi, I am developing one project to have several HDR replicas over version 12.10.xC12 from customers, as I have seen over ONCONFIG there are several new parameters concerning replication Where can I find recent documentation about this and also any step by step guide to follow? Th…
Connection Managers not forwarding connections
Hi, We had an upgrade for the whole informix cluster and after bringing up all the servers , couldn't resync HDR with primary because it was always causing checkpoint blocked on the primary. Afterwards, I noticed that the connection managers aren't forwarding traffic, restarted t…
Fastest export/import?
Informix 12.10.FC12 Solaris 10 1/2013 I have been searching back posts, and I think I understand that the absolute fastest export/import is achieved by using Art's myexport and myimport with -E option (external tables). So, neither sqlcmd nor myonpload is necessary for this spec…
Unused space inside a Table
When you delete records from a Table, the empty space is not released / free'ed up. My question is: If you now insert records again, will the unused space be used first, to add the new records, or will it be added "at the end of the table" (for lack of better words), and new ex…
Reading logical logs of informix
Is it possible to find what was being written in database at a certain point of time by reading logical-logs?…
Error -243 ISAM -154 with Select sentence
Hi, We have a program esql/c that has the following sentences: set isolation to dirty read; set lock mode to wait 30; The program makes several select, update and insert operations Recently these error messages came out when executing a select statement: error -243 (Could not…
Informix csdk download?
Hi, I need the ODBC driver for Informix. Where can I download the Informix csdk? I searched all over online and IBM just keeps taking me in circles. Can anyone assist with the right place to download it? Thank You, --Dave…
Number and size of chunks
Hi, I have an instance with 528 chunks running on IDS 11.70 The server is a HP-UX 11.31 with KAIO enabled and with raw devices and lvols. The disk are SAN, aprox 25 LUNs in a combination of 30, 60 and 90 GB in size. All chunks are 2 GB in size. The CLEANERS parameter is 120. I …
Windows User Authentication
Hi all I need help with user authentication with an Informix Server 12.10.FC12 on windows 2016 server. I wonder why I do _not_ need a windows user to connect to a database on that informix server. I have granted the user, let's name him "xxx", connect to the on and only databa…
IBM Informix RFE gone?
Hi, Where we should request new features? Informix just vanishes from IBM RFE pages. There is no option to filter or submit new RFE. Regards…
Maximum of 16,777,215 pages per Table
What happens when you reach this limit ? maximum of 16,777,215 pages per table Does that table stop working (no more inserts allowed) .... so basically your DB "goes down" ? IDS 12 AIX 7 Dirk…
rootdbs full
Hi, I have rootdbs full with sysmaster, only 4% free. There is anything I can clean? Or I have to increase rootdbs size? Informix version 12.10.FC10, OS CentOS 7 Thanks for any help, SP…
25582 error on high volume of short live trans
Hi IIUG, Trying to find why my DB blows up to high CPU. it has 62 physical cores (x4 smt) on AIX machine P8 running 11.70 IDS. We are getting -25582 error after putting significant load of transactions. The volume of transactions is big but short live. Here's the config below:…
Informix Page Lock
Hi, I know this is somewhat a newbie question but may I ask how do you measure whether or not the table must use Page lock? I mean do you compute the number of rows? number of pages? How can one definitively say that his/her table should be page locked? Thanks,…