IBM IDS TechSupport

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

Terms of Use

3 hours 47 min ago
Terms of Use

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?

IBM Informix Enterprise Hypervisor Edition 12.10: System Requirements

Mon, 2013-05-13 12:41
This document describes the system requirements for IBM® Informix® Enterprise Hypervisor Edition for Red Hat Enterprise Linux (RHEL) Server and IBM Informix Enterprise Hypervisor Edition for AIX. These products contain a virtual image of IBM Informix 12.10 and a guest operating system.

Error "User informix does not exist" during install

Fri, 2013-05-10 18:22
Installation of the product stops with the error "User informix does not exist"

IC92213: VALUES IN THE SYSMASTER:SYSRSTCB.IOWAITTIME COLUMN CAN BE INCORRECT

Fri, 2013-05-10 02:00
When you run a query against the sysmaster:sysrstcb table to analyze the wait statistics of a particular thread, you can see

IC90449: UPDATE STATEMENT AFTER AN ALTER TABLE CAUSING ASSERTION FAILURE WITH "BUFFER MODIFIED IN INCONSISTENT CHUNK"

Thu, 2013-05-09 02:00
Alter table followed by an update statement on the same table causing assertion failure.

IC92021: DBLOAD FAILS WHEN ATTEMPTING TO LOAD UTF-8 CHARACTERS REQUIRING 4 BYTES FOR ENCODING

Thu, 2013-05-09 02:00
When using the dbload utility to load data into a database defined with a UTF-8 locale an error similar to the following

oninit: Cannot open chunk <chunk_path> errno = 24

Wed, 2013-05-08 16:50
You execute oninit to bring your IBM Informix Server into online mode. The process generates an assert warning that it cannot open a primary chunk and returns OS error 24. 18:08:53 Cannot Open Primary Chunk '/db_infx_wwp01/links/wwp01_2514', errno = 24

IC90981: GENONCFG CAN FAIL WITH INAPPLICABLE ERRORS OR GENERATE UNUSABLE ONCONFIG

Tue, 2013-05-07 02:00
While genoncfg is designed to generate an onconfig file based on an input file with certain parameters,

IC92022: SDS NODE GETS REMOVED PRIOR TO EXCEEDING THE SDS_TIMEOUT WHEN HEAVY WORKLOAD TRANSACTION IS RUNNING

Tue, 2013-05-07 02:00
The SDS server node is getting removed prior to exceeding the SDS_TIMEOUT value.

IC91565: MESSAGE "ERROR IN FIELD" WHEN ENTERING DATE WITH HYPHENS

Mon, 2013-05-06 02:00
When DBDATE is set to mdy2/, entering a date value with hyphens in a date field gives "Error In Field" message.

IIF-11.50-Windows-x86-64-Group

Fri, 2013-05-03 17:37
This group lists recommended IDS 11.50 fixpacks and interim fixes for the operating system Windows running on x86-64 hardware.