InSync DBA provides quick and accurate access to the Db2 Catalog to retrieve information and perform maintenance and development tasks easily and efficiently.
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 reduces the pressure on Db2 technicians by simplifying the way they work with the Db2 Catalog.
An intuitive user interface enables fast navigation around the Db2 catalog tables and easy execution of administrative tasks both for experienced database administrators and non-specialist users.
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.