System administration
These topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning IBM® Informix® database servers.
External resources for administration
- Customizing Informix Dynamic
Server for Your Environment (IBM Redbooks® publication)
This IBM Redbooks publication provides an overview of some of the capabilities of version 11 of IBM Informix that enable it to be easily customized for your particular environment. The focus of this book is on the areas of ease of administration and application development. - Recovery of a Down
System (Best practice)
This presentation provides best practices you should follow to bring a down system back into production as soon as possible. It discusses planning for and recovering from a critical situation that impacts your Informix database. - Knowledge Collection: Informix Data
Compression and Storage Optimization (Support document)
This document helps you find the available resources that are related to the storage optimization feature. - Using data file abstraction with external tables
in Informix Dynamic
Server (IBM developerWorks®)
This article describes how to use the external table feature to easily load and unload data. - Logical Logfile monitoring using SMI Tables (blog
entry)
This entry provides SQL statements that query system monitoring tables to monitor logging activity, log-backup status, and event alarms for logical logs. - SYSDBOPEN: A flexible way to change session behavior
in Informix (IBM developerWorks)
Database administrators can use the sysdbopen() and sysdbclose() procedures to set environments to activate user tracing, handle short-lasting locks on data records, or change the reading behavior of sessions. This article shows how to create a sysdbopen() procedure that can be dynamically changed without re-creating the procedure to avoid downtime if session environments must be adjusted. - Understand the Informix Server
V11.70 defragmenter (IBM developerWorks)
You can defragment a table, a fragment, or an index, including system catalogs. Defragmenting reduces the number of extents in the partition. In this article, you can learn about the defragmenter through usage examples.
External resources for performance tips
- IBM
Informix on POWER7® (White
paper)
This technical white paper discusses best practices for using Informix on POWER7 systems to optimize performance for mission critical databases. - Optimizing Informix database
access (IBM developerWorks)
This article explains how to improve the performance of your Informix database application by interrupting an SQL or connection request that requires more time than expected. - Tune your Informix database
for top performance, Part 1: Tuning the data model and the application (IBM developerWorks)
This article explains some basic principles of how to tune an IBM Informix database application to get the best possible performance. In Part 1 of the series, see how the data model, the application, and updated statistics affect performance. - Pushing IBM
Informix Innovator-C
to its Limits (magazine)
This article describes performing a TPC-C-based stress test with IBM Informix Innovator-C edition.
Main resources