InSync® DBA

Db2 catalog and object management

  • OVERVIEW
    OVERVIEW
    OVERVIEW
    OVERVIEW
    OVERVIEW
    OVERVIEW
  • KEY FEATURES
    KEY FEATURES
    KEY FEATURES
    KEY FEATURES
    KEY FEATURES
    KEY FEATURES
  • RESOURCES
    RESOURCES
    RESOURCES
    RESOURCES
    RESOURCES
    RESOURCES

OVERVIEW

Change management and administration take up more time than ever in today's 24x7 Db2 environments. This exposes database administrators (DBAs) to the frustrations of decreasing downtime windows, with little or no room for mistakes.

At the same time, security administrators, application developers and systems engineers all have a stake in precision Db2 systems management and need the ability to access a limited range of Db2 functions.

InSync® DBA alleviates the pressure on all Db2 technicians by providing quick and accurate access to the Db2 Catalog to retrieve information and perform maintenance and development tasks simply, easily and efficiently.

KEY FEATURES

  • Easy-to-use interface
    An intuitive user interface enables fast navigation around the Db2 catalog tables and easy execution of administrative tasks for experienced database administrators and non-specialist users alike
  • Simplified data and object management
    Security administrators and application developers can browse, copy and extract object information without the need for SQL knowledge, which reduces the workload for specialist database administrators and prevents bottlenecks
  • Distributed Data Facility services
    Distributed Data Facility services for connected Db2 subsystems simplify maintenance of the Db2 Communications database; InSync DBA can be used across DRDA links to work with remote Db2 systems
  • Integration with InSync®
    Db2 table data can be accessed easily for browsing and editing, with or without SQL queries; InSync DBA can also be integrated with InSync to provide direct access to detailed object information
  • Dynamic Explain support
    Dynamic Explain support ensures that Db2 access path information is displayed in a user-friendly format; an ISPF Edit macro can also be used to run Explain for SQL embedded in source code and display the results in the same way

RESOURCES

The InSync product suite also includes:
  • InSync®  data management and manipulation for z/OS
  • InSync® for IMS Online  a standalone edit and browse facility for users who have no access to TSO/ISPF

Want to learn more?

Let's discuss how our products can benefit your business

LET'S TALK

Get In Touch

For details on how your data is stored and used, please visit our Privacy Notice.