Server Fault Stack Exchange
Server Fault 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.

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, OLE/DB, ADO, etc.

This list is not exhaustive; there are other esoteric products which it would be legitimate to tag with 'informix'.

25 questions
5
votes
1 answer

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 drive and were able to duplicate the data from the…
Joshua Pack
  • 153
  • 7
4
votes
2 answers

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.active is not owned by user with id 4000. …
Eytan
  • 611
  • 6
  • 13
  • 27
4
votes
2 answers

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 is a 64 bit SDK; maybe this is the issue. But I…
sergiogx
  • 335
  • 3
  • 15
3
votes
3 answers

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-A) or the VM is terminated, failover happens and…
gbaz
  • 141
  • 1
  • 5
2
votes
0 answers

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 import): When I click on preview I'm getting the…
aditya y
  • 21
  • 2
2
votes
1 answer

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, utilities, tune kernel parameters, optimize raw and…
Joe R.
  • 155
  • 5
2
votes
0 answers

32-bit support on 64-bit Linux - getpwuid(), getpwnam() - sssd - MS AD

I have IBM Informix SE DBMS running on 64-bit RedHat 8.7 Linux. This is a 32-bit product. It works well for a locally defined user such as Username billd with UID 505. For example they can run dbaccess stores7 sel_order and get the correct results…
RedGrittyBrick
  • 3,832
  • 1
  • 17
  • 23
1
vote
1 answer

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.
sergiogx
  • 335
  • 3
  • 15
1
vote
1 answer

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/SSGU8G_12.1.0/com.ibm.bar.doc/ids_bar_526.htm On…
gbaz
  • 141
  • 1
  • 5
1
vote
1 answer

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 did find bits and pieces which could lead to the…
MPaul
  • 141
  • 2
  • 6
1
vote
1 answer

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; 201: A syntax error has occurred. Error in line…
John Elliot V
  • 333
  • 2
  • 10
1
vote
2 answers

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 deployed to JBoss 4.0.2 which has few datasources…
lmmortal
  • 13
  • 1
  • 1
  • 3
1
vote
6 answers

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 could steal resources from the DBMS. I also believe…
Joe R.
  • 155
  • 5
1
vote
2 answers

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 improve performance. I would also like to strip down…
Joe R.
  • 155
  • 5
1
vote
1 answer

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, download the lastest version of jre for linux x86 or x64,…
Gaston Morixe
  • 263
  • 1
  • 3
  • 9
1
2