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 ...

learn more… | top users | synonyms

0
votes
1answer
101 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
208 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
0answers
156 views

Final stage of configuring Informix PDO with Apache - stuck :(

I've been working on configuring a server to connect to a remote Informix server to perform queries from Debian/php/apache2. I've been able to successfully install and configure the Informix Client ...
0
votes
1answer
84 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 ...
1
vote
0answers
413 views

INFORMIX - listener thread err 25582

I´ve been digging different forums in the last 7 days looking for a possible solution.... Our database is based on informix running in a Linux server (LINUX SUSE 11). Suddenly, last saturday informix ...
0
votes
1answer
2k 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 ...
0
votes
1answer
205 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
354 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
5k 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
1k 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
346 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
72 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
570 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
181 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
205 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
4k 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
520 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
300 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
1answer
3k 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
381 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.