IBM IDS TechSupport
Terms of Use
Terms of Use
Finding the slowest SQL queries on IBM INFORMIX instance
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
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 ?
How to avoid the delimiter from being written at the end of each row, when unloading a column from a table?
MQ BLADE setup
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
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
Documentation states: "messages are sent to the online message log when storage spaces
Publications for the IBM Informix 12.10 family of products
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
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
What happens to a scheduler task that will run past the defined stop time?
IBM Informix Enterprise Hypervisor Edition 12.10: System Requirements
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
Installation of the product stops with the error "User informix does not exist"
IC92213: VALUES IN THE SYSMASTER:SYSRSTCB.IOWAITTIME COLUMN CAN BE INCORRECT
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"
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
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
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
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
The SDS server node is getting removed prior to exceeding the SDS_TIMEOUT value.
IC91565: MESSAGE "ERROR IN FIELD" WHEN ENTERING DATE WITH HYPHENS
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
This group lists recommended IDS 11.50 fixpacks and interim fixes for the operating system Windows running on x86-64 hardware.


















