Informix I-Spy

IBM® Informix® I-Spy is a smart data warehouse monitoring and optimization tool designed for IBM Informix databases.

Helps warehouse administrators and architects increase the business value of enterprise data warehouses through enhanced utilization efficiency, design improvements, and lower maintenance costs.

• Sits transparently between the database and the client, helping the administrator monitor and adjust database resources and client query usage, including: viewing executed SQL; viewing the accessed data; obtaining reports on execution time; determining quantity of data returned; identifying inefficient or long-running queries.
• Maximizes data warehouse investment by providing information on how the warehouse is being used.
• Improves the efficiency of data warehouse design by allowing the data warehouse architects and developers to prototype the data and queries required.
• Reduces CPU requirements.
• Enables customers to be better prepared for data warehouse expansion over time.