How does Dependency Analyzer identify dependencies?

The tool analyzes SQL statements embedded within application code, such as COBOL or PL/I programs. It parses the SQL syntax and identifies the DB2 objects referenced.

What type of reports does Dependency Analyzer generate?

Dependency Analyzer generates reports that show the relationships between SQL statements and DB2 objects. These reports can be viewed in a graphical interface or exported to other formats.

How does Dependency Analyzer contribute to business value?

By identifying and eliminating inefficient SQL, Dependency Analyzer can reduce CPU consumption and improve application response times. This translates to lower operational costs.

How does it ensure business continuity?

The tool helps in managing the impact of database changes, reducing the risk of application outages and data corruption. This ensures business continuity.

How does it help in database migrations and upgrades?

Dependency Analyzer provides insights into application dependencies, enabling better planning and execution of database migrations and upgrades. This minimizes disruption to business operations.

How does Dependency Analyzer handle security?

Dependency Analyzer leverages the security features of the underlying DB2 system. Access to the analysis results is controlled through DB2's authorization mechanisms.

What audit/logging capabilities exist?

The tool's audit logs record user activity and changes to configuration settings. This provides a trail for security auditing and compliance purposes.

What encryption is used and where?

Dependency Analyzer does not directly encrypt data. It relies on the encryption capabilities of the DB2 system to protect sensitive data.

What maintenance tasks are required?

Dependency Analyzer requires periodic maintenance to update its configuration files and ensure compatibility with changes to the DB2 environment. This includes refreshing data source definitions.

How should the tool be monitored?

The tool's logs should be monitored for errors and performance issues. This helps in identifying and resolving problems before they impact application performance.

Can it be integrated into automated processes?

Dependency Analyzer can be integrated into automated build and deployment processes to ensure that database changes are properly analyzed and managed. This requires scripting and integration with CI/CD tools.

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

Dependency Analyzer

Name: Dependency Analyzer
Availability: InStock

Platinum Technology Not Supported z/OS

Performance Application Development Db2

Vendor

Platinum Technology

Product Overview

Dependency Analyzer's architecture revolved around analyzing DB2 application dependencies by examining SQL statements and their relationships to DB2 objects. The core components included a SQL parser, a dependency analyzer, and a reporting engine. The SQL parser processed SQL statements embedded in application code (COBOL, PL/I).

The dependency analyzer then identified the DB2 objects referenced by these statements. Finally, the reporting engine generated reports showing the SQL-to-DB2 object relationships. Configuration files defined the DB2 subsystems and application libraries to be analyzed.

Communication between components was primarily through internal APIs. The tool stored analysis results in memory for report generation. Given its unsupported status, organizations should consider alternatives like IBM Db2 Query Monitor or BMC AMI SQL Performance for Db2.

These alternatives offer similar or enhanced architectural components for dependency analysis and performance monitoring, often incorporating real-time monitoring and advanced analytics capabilities. Dependency Analyzer lacked real-time monitoring, focusing on static analysis.

Frequently Asked Questions

What is the primary function of Dependency Analyzer?

Dependency Analyzer helps understand the relationships between DB2 objects and the SQL statements that access them. It identifies potential performance bottlenecks by tracing dependencies.

How does Dependency Analyzer assist in impact analysis?

The tool analyzes application code to reveal the impact of changes to DB2 objects. This helps in impact analysis and reduces the risk of unintended consequences.

Can Dependency Analyzer help in optimizing SQL performance?

Dependency Analyzer can identify redundant or inefficient SQL statements by analyzing access paths and data usage patterns. This allows for optimization of SQL code.

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

Dependency Analyzer

Product Overview

Frequently Asked Questions

What is the primary function of Dependency Analyzer?

How does Dependency Analyzer assist in impact analysis?

Can Dependency Analyzer help in optimizing SQL performance?

What configuration files are used by Dependency Analyzer?

How does Dependency Analyzer identify dependencies?

What type of reports does Dependency Analyzer generate?

How does Dependency Analyzer contribute to business value?

How does it ensure business continuity?

How does it help in database migrations and upgrades?

How does Dependency Analyzer handle security?

What audit/logging capabilities exist?

What encryption is used and where?

What maintenance tasks are required?

How should the tool be monitored?

Can it be integrated into automated processes?

Related Products

More from Platinum Technology

SystemVision Year 2000

TransCentury Date Logic Generator

Zina

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