icon_CloudMgmt icon_DollarSign icon_Globe icon_ITAuto icon_ITOps icon_ITSMgmt icon_Mainframe icon_MyIT icon_Ribbon icon_Star icon_User icon_Users icon_VideoPlay icon_Workload icon_caution icon_close s-chevronLeft s-chevronRight s-chevronThinRight s-chevronThinRight s-chevronThinLeft s-chevronThinLeft s-trophy s-chevronDown

Object Administration for Db2®

Object Administration for Db2

Simplify database administration

Making changes to objects in your database—or even just performing routine administrative tasks—can be difficult, risky work. There are dozens of tasks to keep track of, and a single misstep could have a disastrous impact on availability and data integrity. You can cut back on both effort and risk with BMC Object Administration for Db2, a collection of tools to help you:

  • Reduce the time required to administer complex and disparate Db2 environments.
  • Automate routine tasks throughout the application lifecycle for improved integrity.
  • Improve productivity with simplified Db2 catalog navigation and change management.
  • Enhance application availability by performing changes and maintenance with minimal outages.

Automate and facilitate common tasks

Object Administration for Db2 lets you automate routine database administration tasks, manage multiple Db2 environments, and synchronize changes across any of your Db2 environments. The solution facilitates every aspect of interacting with Db2 objects, from simplifying catalog navigation and change management to streamlining the process of loading, unloading, and copying Db2 data.

Navigate with ease

Use a powerful catalog management tool to navigate and interact with your Db2 catalog information.

Mitigate the dangers of change

Take advantage of version control and pre-production testing, so you can make changes carefully and confidently and ensure that everything is put back together correctly.

Sync changes across systems

Take changes you’ve made to one database schema and easily apply them to corresponding structures across your environment.

Speed up your data tasks

Use the load, unload, and copy utilities to move and duplicate your data faster and with fewer resource demands.

Create copies instantly, with no outages

Capture a complete snapshot of your data quickly, without having to suspend read/write access to your database.

Boost productivity and availability

  • Make routine administrative tasks easier, faster, and more reliable.
  • Improve productivity for database users at all levels by giving them powerful, easy-to-use utilities.
  • Keep your databases up and available even during updates and changes.

Products included in this solution

The Object Administration for Db2 solution is made up of the following products, all of which are designed to make interacting with and maintaining your Db2 environments easier and more reliable.

  • Catalog Manager for Db2®

    Rather than having to view and update your Db2 catalog manually, the BMC Catalog Manager for Db2 provides a user-friendly interface for navigating and interacting with your catalog information. The integrated table editor means that, with the appropriate authority, you can make changes directly to your underlying data. Beyond that, the catalog manager supports executing a broad variety of DDL, DCL, DML, and Db2 commands within the catalog.

    This product is available as a part of the following offerings: Object Administration for Db2®

  • Change Manager for Db2®

    Replacing the cumbersome, unreliable process of managing database changes manually, BMC Change Manager for Db2 automates the steps required for implementing structural changes, migrating data, and tracking modifications across multiple Db2 systems, including complex applications such as CRMs and ERPs. Validate your changes in a test environment before putting them into production. Use version control to roll changes back or forward, as needed. Overall, Change Manager for Db2 allows you to execute changes faster, with a higher success rate.

    This product is available as a part of the following offerings: Object Administration for Db2®

  • NGT Load for Db2®

    Load data faster than the native Db2 utility, while maintaining higher availability, with Next Generation Technology Load for Db2. By analyzing the available CPU and memory, NGT Load uses massive parallelism to perform a truly high performance load of any size object. Additionally, with NGT Load's safe Load Resume architecture you can back out an unsuccessful Load instantly without recovery; or using parallel insert processing NGT Load can keep read/write access to your table space during load processing. NGT Load can also update catalog information as you go, so you can skip RUNSTATS.

    This product is available as a part of the following offerings: Object Administration for Db2®, High Speed Utilities for Db2®

  • NGT Unload

    Next Generation Technology Unload for Db2 offers a high-speed, online alternative to the native Db2 unload utility. NGT Unload produces consistent point in time unloads without ever taking the objects out of RW. With its extensive native SQL support, NGT Unload performs high speed unloads directly from the VSAM datasets without the overhead of passing that SQL to Db2. Make multiple unloads, even with different formats, with one pass of a table space.

    This product is available as a part of the following offerings: Object Administration for Db2®, High Speed Utilities for Db2®

  • NGT Copy for Db2® (formerly Copy Plus)

    Simplify and speed your backup jobs with NGT Copy for Db2, a replacement for the native Db2 copy utility. With options for compression and encryption, as well as the ability to write copies simultaneously to tape and DASD, NGT Copy for Db2 makes the backup process faster and more dependable. NGT Copy for Db2 will copy related data sets automatically and can quiesce groups of related table spaces to support application recovery, if needed. The utility also automatically updates Db2 catalog information, without the need to execute RUNSTATS separately.

    This product is available as a part of the following offerings: Object Administration for Db2®, High Speed Utilities for Db2®, Recovery for Db2®

Tap the unused power of your mainframe

Overcome the difficulties in managing NPIs

Get help with daily Db2 activities