Modernization Hub

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
Categories
3
Recommended
Claim Your Listing
Verified Vendor Access
Request Access Now

Product Overview

Policy-1 is a software solution designed to automate the handling of Db2 SQL return codes on z/OS. It intercepts and processes non-zero return codes, providing automatic actions such as issuing WTOs, replacing return codes, abending programs, or calling subroutines. The software operates transparently, requiring no modifications to existing Db2 applications or the Db2 subsystem itself.

Policy-1 integrates directly with Db2, monitoring SQL return codes and applying predefined rules. The architecture of Policy-1 consists of several key components. A central control module manages the overall operation of the software.

Configuration data, including the rules for handling specific return codes, is stored in a dedicated repository. An interception module intercepts SQL return codes from Db2. An action execution module performs the configured actions based on the intercepted return codes.

These components communicate through internal APIs and data structures. Policy-1 is deployed on-premise within the z/OS environment, typically running in an LPAR alongside Db2. It requires minimal network configuration and integrates seamlessly with existing security infrastructure.

Compared to alternatives like manual coding or other Db2 performance monitoring tools, Policy-1 offers a focused and efficient solution for return code management.

Frequently Asked Questions

What does Policy-1 do?

Policy-1 automates the handling of Db2 SQL return codes. It allows for automatic processing of non-zero return codes, such as issuing a WTO, replacing the Db2 return code, abending the program, or calling a subroutine.

Is this a system, application, or tool?

Policy-1 is a software tool designed to enhance Db2 application development and problem analysis. It operates transparently to both applications and Db2, requiring no application changes.

What types of organizations use this?

Organizations that rely heavily on Db2 databases and need to ensure the stability and reliability of their applications would benefit from Policy-1. This includes enterprises in finance, insurance, and other industries with critical Db2-based systems.

When should we consider Policy-1?

A company should consider using Policy-1 when they experience issues related to Db2 SQL return codes impacting application stability. It is especially useful when they want to avoid modifying existing applications to handle these return codes.

What are the alternatives to Policy-1?

Alternatives to Policy-1 include manual coding of error handling routines within applications, using other Db2 performance monitoring tools, or implementing custom solutions for return code management.

Related Products

More from Log-On Software

z/OS

# Application Support Facility (ASF) - Technical Manager Summary Application Support Facility (ASF) is a z/OS-based solution designed to streamline document generation and content management....

View Details →

DPT

Active
z/OS

DPT (Data Processing Tables) is a tool set designed to enhance database performance within z/OS mainframe environments. It addresses the common problem of slow application...

View Details →

Log-On APL2

Active
z/OSz/VM

Log-On APL2 serves as a replacement for IBM APL2, operating within z/OS and z/VM environments. It supports APL2 programming in TSO/E and CMS, offering a...

View Details →

NV FTP

Active
z/OS

NV FTP is a file transfer solution for z/OS environments, enabling data exchange via the FTP protocol. Key components include the FTP client, which resides...

View Details →
z/OS

QuickSelect for Db2 is a middleware solution designed to enhance the performance of Db2 databases running on z/OS. It addresses the business problem of slow...

View Details →
z/OS

TVL Event Pump is designed to monitor z/OS systems and resources, providing event data to other monitoring tools. Key components include the Event Collector, Event...

View Details →

Similar Products

2cIP

Active
z/OS

2cIP provides comprehensive network trace analysis capabilities for z/OS environments, focusing on TCP/IP and SNA protocols. The core architecture comprises the Capture Engine, the Analysis...

View Details →

2cSNA

Active
z/OS

2cSNA is a z/OS-based tool designed for in-depth analysis of VTAM sessions. It provides detailed insights into SNA communication flows, enabling users to pinpoint performance...

View Details →
z/OS

Ab Initio BRE is a comprehensive BRMS designed to streamline the development, deployment, and maintenance of rules-based applications. The core components include the Rule Engine,...

View Details →

Abend-AID

Active
z/OS

Abend-AID is a critical tool for z/OS application support, providing post-abend analysis to reduce downtime and improve developer productivity. It captures detailed diagnostic information, including...

View Details →
z/OS

Access Manager for CICS provides a robust solution for integrating CICS applications with Oracle databases on z/OS. The product's architecture includes the CICS Interface, Oracle...

View Details →
z/OS

Access Manager for IMS provides a solution for integrating IMS applications with Oracle databases on z/OS. The primary components include the IMS Connect client, the...

View Details →

Help Improve This Directory

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

Share Your Product Experience

Help the community by sharing your experience with mainframe products. Your insights help others make informed decisions.

Share Your Experience