Database Management Utilities

Information by State  Print version   Search

A collection of programs that assist in the storing of data in a database and retrieving that information from that data. This includes: 1) Entering the data 2) Modifying or Updating data 3) Reporting or Manipulating the Data to provide useful information.

The below listed products are in use and being Maintained (M), they will be periodically reviewed by the Configuration Control Management Board (CCMB), Enterprise Architecture (EA), & OPS to determine status and whether plans should be made to migrate to Target or should be moved to the Obsolete category.

BMC Activity Monitor For DB2
BMC Alter For DB2
BMC Catalog Manager for DB2
BMC DASD Manager For DB2
BMC LoadPlus for IMS
BMC Secondary Index Utility
BMC UnloadPlus for IMS
IBM IMS DBRF
IBM IMS HPPC
IBM IMS LIU
IBM QMF 7.0
SQL POWER Desktop Showplan Analyzer
SQL POWER eData Usage Analyzer
SQL POWER Zero Impact Service Level Monitor
SQL POWER Zero Impact SQL Monitor
SQL POWER Zero Impact Top N SQL Analyzer
Sybase Replication Server 12.0
Syabse SQL Anywhere 9.0

The below listed products are Obsolete (O), outdated technology that plans are being made to sunset the product.

Sybase Adaptive Server IQ 12.0
Sybase CONVOY/DM
Sybase CONVOY/DM ODBC Metadata Extractor
SYBASE Replication Server
Sybase SQL Anywhere 8.0

Maintain Products

BMC Activity Monitor For DB2

Product Description

There is currently no information available for this product.

Back to Top

BMC Alter For DB2

Product Description

There is currently no information available for this product.

Back to Top

BMC Catalog Manager for DB2

Product Description

There is currently no information available for this product.

Back to Top

BMC DASD Manager For DB2

Product Description

There is currently no information available for this product.

Back to Top

BMC LoadPlus for IMS

Product Description

There is currently no information available for this product.

Back to Top

BMC Secondary Index Utility

Product Description

There is currently no information available for this product.

Back to Top

BMC UnloadPlus for IMS

Product Description

There is currently no information available for this product.

Back to Top

IBM IMS DBRF

Product Description

IBM IMS Database Repair Facility can interactively, and in batch mode, repair VSAM and OSAM organized IMS databases that contain pointer or data errors. With the latest release of this tool, V1.2, you can view entire blocks of data or individual IMS segments.

Back to Top

IBM IMS HPPC

Product Description

IBM IMS HP Pointer Checker helps you efficiently manage many database reorganization activities. When used regularly, IMS HP Pointer Checker helps ensure that your database pointers are error free alerting you when it's time to perform a database reorganization.

Back to Top

IBM IMS LIU

Product Description

IBM IMS Library Integrity Utilities (LIU) includes all the features and functions of the IMS Library Management Utilities for OS/390, which help you manage your IMS Access Control Blocks, PSB, and DBD libraries. IMS LIU also includes the IMS Advanced ACB Generator for OS/390, which contains additional features and functions to help you manage your IMS ACB libraries more effectively and provides a high-speed generation process. In addition, IMS LIU contains an Integrity Checker and Consistency Checker. The Integrity Checker protects your databases from corruption caused by using the wrong IMS control blocks for access. The Consistency Checker helps you ensure that the necessary definitions in your IMS subsystem have been created. The tool also provides easy-to-read reports and maps.

Back to Top

IBM QMF 7.0

Product Description

IBM Query Management Facility (QMF) is a tightly integrated, powerful, and reliable query and reporting toolset for IBM's DB2 relational database management system, and provides an environment that is easy for a novice to use but powerful enough for an application programmer. QMF offers extensive management and control over your enterprise query environment to protect valuable system resources.

Back to Top

SQL POWER Desktop Showplan Analyzer

Product Description

Empowers a Sybase SQL developer or DBA to capture and perform automated SQL tuning, coding analysis, I/O, time, show plan and SQL statement code coverage analysis of poor performing SQL transactions.

Back to Top

SQL POWER eData Usage Analyzer

Product Description

Identifies end-user data usage query patterns in data warehouse or eCommerce environments.

Back to Top

SQL POWER Zero Impact Service Level Monitor

Product Description

Zero Impact Service Level Monitor provides hard metrics of average end-user response time, database server response time, network send time, by database server, application and individual end-user.

Back to Top

SQL POWER Zero Impact SQL Monitor

Product Description

Enables you to capture in real time all SQL text and corresponding SQL performance metrics. Filter or reconstruct SQL statement activity 15+ ways.

Back to Top

SQL POWER Zero Impact Top N SQL Analyzer

Product Description

Monitor all long running SQL statements, blocked processes, deadlocks, and contention issues. Provides an an accurate account of when blocked or deadlocks processes occur along with a graph of the associated SQL text, show plan description, database locks involved in blocking. Long running SQL statements in stored procedures, triggers, and SQL batches are also pinpointed. The SQL statements most commonly involved in degrading database performance are summarized in the product's Top N SQL statement analysis for deadlocked, blocked or long running SQL statements.

Back to Top

Sybase Replication Server 12.0

Product Description

Sybase Replication Server moves and synchronizes data across the enterprise to meet a host of competing challenges such as data replication, data management, and heterogeneous replication while providing the highest level of data management. It delivers operational data across complex and broadly distributed data infrastructures in near-real-time.

Back to Top

Syabse SQL Anywhere 9.0

Product Description

SQL Anywhere® is a comprehensive package providing data management and data exchange technologies that enable the rapid development and deployment of database-powered applications. SQL Anywhere offers enterprise caliber databases that scale from 64-bit servers with thousands of users down to small handheld devices.

Back to Top

Obsolete Products

Sybase Adaptive Server IQ 12.0

Product Description

Sybase Adaptive Server IQ is a high-performance decision support server designed specifically for data warehouses and data marts.

Back to Top

Sybase CONVOY/DM

Product Description

"Notice: Sybase Convoy/DM is no longer offered by Sybase. If you would like to speak with a Sybase representative to see how Sybase can meet your business requirements through other Sybase products and solutions, contact our sales team nearest you. Sybase Convoy/DM is at its core a data transformation tool that provides sophisticated, flexible data extraction, mapping, transformation, validation, and loading capabilities for the PeopleSoft environment. Its ability to extract applications metadata, or detailed descriptions of the business rules required by your source and target applications, is key to its ease-of-use. With Convoy/DM, your technical team can oversee and manage user-initiated changes that impact your application interfaces, resulting in efficient, cost-effective on-going maintenance that is less prone to error."

Back to Top

Sybase CONVOY/DM ODBC Metadata Extractor

Product Description

"Notice: Sybase Convoy/DM is no longer offered by Sybase. If you would like to speak with a Sybase representative to see how Sybase can meet your business requirements through other Sybase products and solutions, contact our sales team nearest you. Sybase Convoy/DM is at its core a data transformation tool that provides sophisticated, flexible data extraction, mapping, transformation, validation, and loading capabilities for the PeopleSoft environment. Its ability to extract applications metadata, or detailed descriptions of the business rules required by your source and target applications, is key to its ease-of-use. With Convoy/DM, your technical team can oversee and manage user-initiated changes that impact your application interfaces, resulting in efficient, cost-effective on-going maintenance that is less prone to error."

Back to Top

Sybase Replication Server

Product Description

Sybase Replication Server moves and synchronizes data across the enterprise to meet a host of competing challenges such as data replication, data management, and heterogeneous replication while providing the highest level of data management. It delivers operational data across complex and broadly distributed data infrastructures in near-real-time.

Back to Top

Sybase SQL Anywhere 8.0

Product Description

SQL Anywhere® is a comprehensive package providing data management and data exchange technologies that enable the rapid development and deployment of database-powered applications. SQL Anywhere offers enterprise caliber databases that scale from 64-bit servers with thousands of users down to small handheld devices.

Back to Top

Return to Data Services Domain
Technology Reference Model IT Modernization Standards Profile Page
Return to Enterprise Architecture
Comments and Questions