IBM IDS TechSupport

Syndicate content Information Management - Informix Dynamic Server (ID
Customer subscriptions from IBM My notifications
Updated: 3 hours 8 min ago

Terms of Use

3 hours 8 min ago
Terms of Use

IDS install returns: lax.nl.message.vm.not.loaded=The installer either could not find a Java VM, or the Java VM on this system is too old.

Fri, 2013-05-24 02:01
While installing IDS on a Linux host, a non fatal error is displayed in the install.log file: lax.nl.message.vm.not.loaded=The installer either could not find a Java VM, or the Java VM on this system is too old. The installer requires Java 1.1.5 or later. It can be downloaded from http://java.sun.com/products/jdk/1.1/jre/lax.resource.dir=Linux

WARNING:If you intend to use J/Foundation or GLS for Unicode feature(GLU) with this Server instance, please make sure that your SHMBASE value specifies in onconfig is 0x700000010000000 or above.

Fri, 2013-05-24 00:40
When bringing up the Informix instance a message will be displayed in the Online.log file indicating the value of the SHMBASE (shared memory base address ) is to small.

IC92503: POPULATING FOT INDEX MAY END UP WITH ASSERT FAILURE IN PTMAP IF THE TABLE WAS TRUNCATED BEFORE THE DATA LOADING

Thu, 2013-05-23 02:00
You are inserting data into a table with unique FOT index shortly after the table was truncated. The insert fails with

IC90795: PERFORMANCE PROBLEM AFTER UPGRADE FROM 11.50.FC5 TO 11.50.FC9 CAUSES QUERY PLAN CHANGES IN ORDERING OF TABLES

Wed, 2013-05-22 02:00
Performance problems encountered when upgrading from 11.50.FC5 to 11.50.FC9. Query plans are changing causing queries to go

Do Secondaries Have to be Exclusively Read-Only or Updatable in High-Availability Systems?

Tue, 2013-05-21 16:28
I can create mixed replication systems, combining high-availability data replication (HDR), remote stand-alone (RS), and shared-disk (SD) secondaries, I can also have more than one RS or SD secondary in a system. Can I configure some as read-only and some as updatable?

oninit: Fatal error in initializing ASF with 'ASF_INIT_DATA' flags; asfcode = '-28014'.

Mon, 2013-05-20 12:47
Trying to bring up informix server after configuring Secure Socket Layer connections (SSL setup), server fails to come up with following error: Initialization of Encryption...succeeded oninit: Fatal error in initializing ASF with 'ASF_INIT_DATA' flags; asfcode = '-28014'. Initializing ASF...FAILED WARNING: server initialization failed, or possibly timed out (if -w was used). Check the message log, online.log, for errors.

IC92018: THE CONNECTION MANAGER FOC ATTRIBUTE PRIORITY IS SHOWN, BUT NOT EXPLAINED

Mon, 2013-05-20 02:00
If you check the connection manager configuration parameters documented here:

IC91961: DBSCHEMA AND DBEXPORT RETURNS A WARNING MESSAGE WHEN TABLE NAME,PROCEDURE NAME OR COLUMN NAME HAS MULTI BYTE CHARACTER A TO Z

Mon, 2013-05-20 02:00
dbschema and dbexport return a warning message below when table name,

IC92288: VIEWING THE ON-BAR ACTIVITY LOG IN OAT CRASHES THE SERVER WHEN SYSBARACT_LOG DOES NOT EXIST

Mon, 2013-05-20 02:00
Viewing the onbar activity log in OAT crashes the server when SYSBARACT_LOG does not exist.

IC92381: WRONG RESULT RETURNED FROM ANSI JOIN QUERY WHEN IFX_FOLDVIEW IS SET TO 1 AND SQL_DEF_CTRL IS SET TO 0X4

Mon, 2013-05-20 02:00
IFX_FOLDVIEW is set to 1 and SQL_DEF_CTRL is set to 0x4 an ANSI join query returns the wrong result set. Setting SQL_DEF_CTRL to

Finding the slowest SQL queries on IBM INFORMIX instance

Fri, 2013-05-17 16:59
The following query is to identify the 10 slowest SQL queries from syssqltrace. Note : SQLTRACE in $ONCONFIG need to be enabled in order to trace the SQL Queries.

Configuring the Connection Manager for PAM Authentication

Fri, 2013-05-17 11:42
How do I configure so that PAM (pluggable authentication module) is used for authentication when I connect to an informix server using a Connection Manager SLA (service level agreement)?

How to avoid the delimiter from being written at the end of each row, when unloading a column from a table ?

Thu, 2013-05-16 11:48
How to avoid the delimiter from being written at the end of each row, when unloading a column from a table?

MQ BLADE setup

Wed, 2013-05-15 11:55
How to setup MQBLADE for use with IDS?

IC92019: VIEW WITH JOIN ON SMI TABLES AND AGGREGATE COLUMNS RESULTS IN MEMORY CORRUPTION THAT LEADS TO DIFFERENT ASSERT FAILURES

Wed, 2013-05-15 02:00
While querying a view with SMI tables and aggregate columns, memory corruption leads to different assert failures like:

IC91530: MESSAGE LOG DOES NOT FLAG A 'NO MORE PAGES' SITUATION AS WARNING

Wed, 2013-05-15 02:00
Documentation states: "messages are sent to the online message log when storage spaces

Publications for the IBM Informix 12.10 family of products

Tue, 2013-05-14 11:02
This document contains links to publications, including online information, PDF files, release notes, and more, for the IBM® Informix® 12.10 family of products, including client products and Informix DataBlade® modules.

Publications for IBM Informix Warehouse Accelerator 12.10

Tue, 2013-05-14 11:01
This document contains links to publications, including online information, PDF files, release notes, and more, for IBM® Informix® Warehouse Accelerator 12.10.

A scheduler task runs past the defined stop time

Mon, 2013-05-13 15:37
What happens to a scheduler task that will run past the defined stop time?