Skip to main content

Software > Information Management > IBM DB2 and IMS Tools >

DB2 Bind Manager for z/OS, V2.3


Information Management software
Overview

IBM DB2 Bind Manager allows application programmers to safely bypass the DB2 bind process for code changes that do not alter existing SQL structures in an application.

A 'catalog cleanup' feature lets you compare bound DB2 packages to their load libraries. Where there is no match, a Free Command removes obsolete packages and a backup of the DBRM is recreated from the system catalog. If you have missing DBRMs, you can recreate them from the system catalog. DB2 Bind Manager, used in conjunction with DB2 Path Checker, reduces the amount of catalog data to be migrated to DB2 UDB for z/OS, Version 8, and also helps identify potentially harmful access path changes before they occur.

  Key Features
  • Avoids binds when moving between DB2 V7 and DB2 V8 compatibility mode because DB2 V8 inserts a CCSID into the DBRM. A bind is prevented by a feature that detects whether the CCSID is missing in DB2 V7 but is present in DB2 V8.
  • Offers DBRM Check Function that includes an Index Utility which displays available indexes and key columns for a table, and a DBRM Builder in batch.
  • Determines if a bind is required after an application has been precompiled or automatically resets the time stamp and bypasses the bind.
  • Handles consistency checking between an existing DBRMLIB and a DB2 subsystem (through the DBRM Checker function).
  • Matches time stamps in a DBRM to time stamps in a load module.
  • Scans a load library for modules and CSECTS that contain static SQL.

Program number: 5655-E43
DB Application Management


  Related Tools
DB2 Path Checker
DB2 Table Editor
DB2 Test Database Generator
DB2 Web Query Tool

System Requirements

IBM DB2 Bind Manager for z/OS, V2.3 is designed to operate with the following DB2 versions:

  • DB2 9 (5635-DB2)
  • DB2 V8 (5625-DB2)
  • DB2 V7 (5675-DB2)

The following versions of the z/OS operating system are required:

  • z/OS V1.6 (5694-A01), or later

For more information on the system requirements, see the Program Directory on the Library page.


Offsite link Get Adobe® Reader®


We're here to help
Easy ways to get the answers you need.
Request a quote
E-mail IBM

or call us at
877-426-3774
Priority code:
104CBW60


Highlights

Success Story: Amica Sharpens Productivity with DB2 Tools (PDF 375KB)


Technical details

Fact Sheet (PDF79KB)

Product Life Cycle


Publications

Library

Redbook: New Tools for DB2 for OS/390, z/OS

Redbook: DB2 UDB Server for OS/390 and z/OS V7