Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [informix]

This tag is appropriate for questions about IBM's products in the Informix family - or any predecessors to those products. Such products include: Informix Dynamic Server (IDS), Standard Engine (SE), Extended Parallel Server (XPS), OnLine, ESQL/C, I4GL, ISQL. It also includes questions about the Informix implementations of generic interfaces to the Informix databases, such as ODBC, JDBC, .NET, OLEDB, ADO, etc.

1
vote
0answers
131 views

Importing data from Informix DB to SQL Server

Configured Informix drivers (32-bit) ODBC on my local machine and trying to import the data to SQL Server using SQL Server IMPORT and export wizard. I selected source tables and views(steps in SQL ...
3
votes
3answers
452 views

Informix HDR failover doesn't work when primary DB server and Connection Manager/ICM are terminated simultaneously then ICM is brought back online

Automatic switchover is configured in a primary/secondary HDR server setup. The HDR cluster would be connected and replication is on. If the service is stopped gracefully on the primary server (NODE-...
1
vote
1answer
514 views

How to backup and restore informix db using Onbar tool with ONPSM cloud storage device?

I am having a hard time using the Onbar tool (which relies on Onpsm primary storage manager for Informix db (server 12.1) using the cloud device (AWS s3). https://www.ibm.com/support/knowledgecenter/...
1
vote
1answer
4k views

Installing 32 bit and 64 bit Informix drivers on same machine

Currently trying to setup a development environment which can handle both 32-bit and 64-bit ODBC Informix Drivers. I'm was unsuccessful at finding any sort of guide or walk through online, however I ...
0
votes
0answers
111 views

Slow I/O rhel 5.1 on hyper-v 2012 r2

I have RHEL 5.1 server with informixDB is virtualized on Hyper-V 2012 R2 when i make request on database it's very very slow and my disk host database is 99% use.... Here iostat result during request ...
1
vote
1answer
884 views

Why am I getting a syntax error using Informix dbaccess?

I'm getting this syntax error in IBM Informix using the dbaccess utility: root@guava:/opt/informix# bin/dbaccess - - Your evaluation license will expire on 2015-12-22 00:00:00 > show databases; ...
0
votes
1answer
937 views

CUCM Nested SQL query to link devicepool and licensing

Cisco's licensing manager has a shortcoming in that it provides licensing data per enterprise instead of per cluster. I am attempting to utilize SQL queries to produce this data. Currently, i have two ...
5
votes
1answer
1k views

Is there a Informix command to repair database?

We have a Sun Solaris system running Avaya CMS software. The software uses an Informix database. We have a single drive in the server. The drive began to go bad, corrupting files. We sourced a new ...
0
votes
1answer
398 views

Activating Informix variables on Apache2/Debian

I'm working on adding PDO for Informix on my Debian server. I have a strong set of instructions from a gentleman who has set this up to run on suse, I'm trying to figure out how to add these ...
2
votes
2answers
8k views

informix + Fatal error in shared memory creation

please advice how to solve this problem I have linux with informix DB its fail on - Fatal error in shared memory creation su - informix -sh-2.05b$ oninit -v ONCONFIG /usr/informix/etc/onconfig....
0
votes
1answer
371 views

linux + Informix cant startup + external EMC storage

I have Linux machine with Informix DB from the Informix log I see the following please advice what could be the problem ( my Informix cant startup ) 13:40:45 Warning: ONCONFIG dump directory (...
0
votes
2answers
856 views

Informix snmp sub agent with net-snmp

Has anyone succesfully configured informix 10 snmp subagent to work with net-snmp in linux or windows?
1
vote
2answers
15k views

Informix “Database locale information mismatch”

I have informix 11.5 running in my Win-2003 box and few databases running in it. System databases have locale en_us.819 My custom databases have locale en_us.57372 (UTF8). There is also application ...
0
votes
1answer
2k views

Informix top command?

Is there a top operator for informix like there is in SQL Server? I want to run a delete that will just delete the top say 1000 records based on a ordered select. e.g. delete from table where id ...
0
votes
2answers
768 views

Informix to MySQL Conversion

We have a old Informix Database at my place of employment and are looking for a solid solution for migrating all of the data from Informix to MySQL. Does anyone have knowledge of a proven solution ...
0
votes
2answers
86 views

Why is Informix showing numeric errors?

In a Windows 7 64 bit development machine, a .NET application is getting numeric error messages from Informix. The very same application xcopied to other machines shows the correct error message ...
0
votes
1answer
988 views

Informix 11.50 over onsoctcp, dbaccess as root, not trusted

I have two SLES 11 servers. One has my Informix 11.50.FC6 database. I installed the IDS engine on my other server so I could get dbaccess. I have entries in /etc/hosts.equiv and I can use dbaccess as ...
1
vote
6answers
267 views

What DBMS' have tight integration with a dedicated OS'?

It has always been my strong conviction that a large-scale multi-user DBMS should reside, stand-alone, on a dedicated server or clusters, with no other unecessary apps, processes or services which ...
1
vote
2answers
252 views

Dedicated hard disk for Informix SE dbname.dbs files & dedicated ramdisk for /tmp files

INFORMIX-SE 7.2: I would like to dedicate a hard disk, exclusively for my dbname.dbs directory which holds all the .dat and .idx files, and create a ramdisk for my /tmp temporary files in order to ...
1
vote
1answer
5k views

How to install INFORMIX (IDS) 11.50 in CENTOS 5.4

Getting ERROR: The wizard cannot continue because of the following error: could not load wizard specified in /wizard.inf (104) Solution: Uninstall everything related with java and jre. Then, ...
0
votes
1answer
649 views

informix odbc connection slow to open in asp.net

I have an application that takes a long time to open odbc connections (like 20 sec) also takes forever using arcmap and arcsde but when I try the connection on the odbc data source administrator, it ...
2
votes
1answer
410 views

optimizing operating systems to provide maximum informix performance

Are there any Informix-specific guides for optimizing any operating system where an ifx engine is running? For example, in Linux, strip-down to a bare minimum all unecessary binaries, daemons, ...
4
votes
2answers
4k views

How do I install Informix ODBC on Windows Server 2003/2008?

I installed the Informix Client SDK on my PC (32 bit) and on the server. I could create an ODBC connection on my PC easily, but on both Windows 2003 and 2008 (64 bit) I can't. I don't know if there ...
1
vote
1answer
792 views

informix stores date with a 2 digit year instead of 4, how do I correct this?

How do I make informix handle 4 digit years? I have both windows and suse servers using informix Thank you.