Overview
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.
