Informix Advanced Enterprise Edition V12.10

Program 5725-D14
March 26, 2013

		Service & Support for IBM Database Systems

		Administration and Monitoring Administration of IBM databases adapted to customer requirements. Analysis, monitoring, support, up to 24x7 support for systems with high availability requirements.

		Service Services for all data management requirements. Booking via service packages or individual agreement of services.

		Support IBM database support request. Support tickets, also without IBM product maintenance, directly bookable via webshop.

		Release Newsletter Don't miss a bugfix or update for Informix. Register for our Release Newsletter. Up-to-date information about updates within 24 hours via E-Mail.

		Product Lifecycle View product lifecycle information on Informix directly here. Detailed information about availability, end-of-marketing (EOM) and end-of-service (EOS) dates. IBM Announcement or Product Withdrawal announcements, with information on product replacements.

		Bug Research Bug research of the CURSOR Service Distribution for Informix databases. Powerful full-text search for problems and solutions. Problem description, identification, processing status, solutions and workarounds.

Zufriedener Administrator, Informix Support mit CURSOR

Informix Monitoring - References and Examples

Here you will find special problems and their solutions - get an idea of our services!

We support customers who are active in security-relevant areas or customers who use Informix as a central and sensitive part of their data infrastructure. In this context, all examples were made anonymous.
For a personal reference, we will be happy to arrange direct contact for you - please contact us!

Informix 271 could not insert new row -
downtime prevented

For our customers, we monitor existentially important and time-critical database systems.
For comprehensive monitoring and alerting, we naturally use our own tool, the Admin Scout for Informix.

In this real-life example, a parameter has reached the defined alarm threshold.
The Admin-Scout sends an e-mail to CURSOR Informix Support:

**************************************************

Notification Type: PROBLEM
Service: informix-checkalert
Alert color: RED

Message:
database: tablename has 16777215 pages, free are 1248744 pages
pagesisze is 2k maximum is 16.7 Mio pages

**************************************************

Meaning of the alarm

A table has allocated the maximum number of pages and the free pages are less than 10%.
As soon as the free pages are already used, all attempts to write to this table are aborted.