What performance metrics does InfoScope collect?

InfoScope captures SQL execution statistics such as CPU time, elapsed time, I/O operations, and buffer pool usage. It also tracks wait times for locks, latches, and other resources. This data is used to identify performance bottlenecks.

What are the main components of InfoScope's architecture?

InfoScope's architecture includes a data collection component, a data repository, and a reporting interface. The data collection component captures SQL performance data from Db2. The data repository stores the collected data. The reporting interface provides tools for analyzing and visualizing the data.

What administrative interfaces are available?

InfoScope provides a command-line interface (CLI) for administrative tasks such as configuring monitoring parameters, starting and stopping data collection, and generating reports. The CLI is accessed through a terminal session.

What is the business value of InfoScope?

InfoScope helps organizations improve the performance and efficiency of their Db2 applications. By identifying and resolving SQL performance bottlenecks, InfoScope can reduce CPU consumption, improve response times, and lower operating costs.

How does InfoScope help organizations proactively manage SQL performance?

InfoScope enables organizations to proactively manage SQL performance and prevent performance problems before they impact users. By monitoring SQL execution statistics and wait times, InfoScope can identify potential issues and alert administrators.

How does InfoScope help developers optimize SQL queries?

InfoScope provides detailed insights into SQL query behavior, enabling developers to optimize SQL statements and improve application performance. By analyzing SQL execution statistics and resource consumption, developers can identify areas for improvement.

What authentication methods are supported?

InfoScope supports authentication using RACF (Resource Access Control Facility). Users must have appropriate RACF permissions to access InfoScope functions and data. InfoScope integrates with RACF to validate user credentials.

What access control model is used?

InfoScope uses role-based access control (RBAC) to manage user permissions. Users are assigned to roles, and each role has specific permissions to access InfoScope functions and data. RBAC simplifies user management and ensures that users have only the necessary permissions.

What encryption is used and where?

InfoScope encrypts sensitive data at rest and in transit. Data at rest, such as SQL statements and execution statistics, is encrypted using AES (Advanced Encryption Standard). Data in transit is encrypted using TLS (Transport Layer Security).

What audit/logging capabilities exist?

InfoScope provides audit logging capabilities to track user activity and system events. Audit logs record user logins, logouts, configuration changes, and data access. These logs can be used for security monitoring and compliance reporting.

What monitoring/logging capabilities exist?

InfoScope provides monitoring and logging capabilities to track system health and performance. It monitors CPU usage, memory consumption, and disk space. It also logs system events, errors, and warnings. This data helps administrators identify and resolve operational issues.

What administrative interfaces are available?

InfoScope provides a command-line interface (CLI) for administrative tasks such as configuring monitoring parameters, starting and stopping data collection, and generating reports. The CLI is accessed through a terminal session.

Are You a Vendor? Claim Your Listing

Take control of your product listings. Add verified information, showcase updates, and unlock a Claimed Vendor badge across the directory.

Claim Your Listing Now

InfoScope

Infotel Active z/OS

Performance Application Development Db2

Vendor

Infotel

Product Overview

InfoScope's architecture comprises several key components working together to monitor and optimize SQL query performance on Db2 databases. The data collection component captures SQL execution statistics, including CPU time, elapsed time, and I/O operations, directly from Db2 subsystems. This component communicates with Db2 using standard Db2 interfaces.

The data repository, a Db2 database, stores the collected performance data. The database schema includes tables for SQL statements, execution statistics, wait times, and resource consumption. The reporting interface provides tools for analyzing and visualizing the data, allowing users to identify performance bottlenecks and optimize SQL queries.

Administrative tasks are performed via a command-line interface (CLI). InfoScope supports authentication using RACF and uses role-based access control (RBAC) for user permissions. Audit logging tracks user activity.

Configuration files define monitoring parameters, thresholds, and reporting options. These files specify the Db2 subsystems to monitor, the SQL statements to track, and the performance metrics to collect. Competing products include IBM Db2 Performance Expert and BMC AMI Ops Monitor for Db2.

Frequently Asked Questions

What does InfoScope do?

InfoScope monitors SQL query performance on Db2 databases. It captures SQL execution statistics, resource consumption, and wait times. This data helps identify performance bottlenecks and optimize SQL queries.

How does InfoScope integrate with application development?

InfoScope integrates with the INFO-OPTIMIZER suite. It can be used during application development to analyze SQL performance early in the development lifecycle. It provides insights into SQL query behavior in different environments.

What configuration files are used by InfoScope?

InfoScope uses configuration files to define monitoring parameters, thresholds, and reporting options. These files specify the Db2 subsystems to monitor, the SQL statements to track, and the performance metrics to collect.

Help Improve This Directory

Notice outdated information? Have insights about this product? Help the mainframe community stay informed with accurate, current data.

Report Issue Suggest Product Share Event

Are You a Vendor? Claim Your Listing

Take control of your product listings. Add verified information, showcase updates, and unlock a Claimed Vendor badge across the directory.

Claim Your Listing Now

Are You a Vendor? Claim Your Listing

InfoScope

Product Overview

Frequently Asked Questions

What does InfoScope do?

How does InfoScope integrate with application development?

What configuration files are used by InfoScope?

What performance metrics does InfoScope collect?

What are the main components of InfoScope's architecture?

What database does InfoScope use?

What administrative interfaces are available?

What is the business value of InfoScope?

How does InfoScope help organizations proactively manage SQL performance?

How does InfoScope help developers optimize SQL queries?

What authentication methods are supported?

What access control model is used?

What encryption is used and where?

What audit/logging capabilities exist?

What monitoring/logging capabilities exist?

How is InfoScope configured?

What administrative interfaces are available?

Related Products

More from Infotel

InfoLoad for DB2 on z/OS

InfoPak

InfoReorg for DB2 on z/OS

InfoSimulation

InfoTrace

InfoUnload for DB2 on z/OS

Similar Products

4Tune

Ab Initio Business Rules Environment

Access Manager for CICS

Access Manager for IMS

ACCOLADE

Adabas Caching Facility

Help Improve This Directory

Are You a Vendor? Claim Your Listing