IBM® Informix® I-Spy is a smart data warehouse monitoring and optimization tool designed for IBM Informix databases.
Informix I-Spy 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 to monitor and adjust database resources and client query usage.
- Enables tasks such as viewing executed SQL and the accessed data, obtaining reports on execution time, determining quantity of data returned, and identifying inefficient or long-running queries.
- Maximizes your data warehouse investment by providing information on how the warehouse is being used.
- Improves the efficiency of data warehouse design by allowing the architects and developers to prototype the data and queries required.
- Reduces CPU requirements.
- Facilitates data warehouse expansion over time.
- Runs on AIX, HP-UX, HP Tru64 and SunOS.