High Speed Utilities for Db2®
Changing the game in data management
Make interacting with your Db2 database faster, easier, and cheaper with BMC High Speed Utilities for Db2 with Next Generation Technology (NGT). The advanced technology in the products included in this solution provide more control, deliver adaptive automation, and consume significantly fewer resources than their Db2 counterparts. Use these tools to:
- Drastically reduce the time and cost of your day-to-day database housekeeping operations.
- Eliminate application outages.
- Collect and analyze a wealth of performance statistics—invaluable for making informed maintenance decisions.
Next-generation data management tools
Working in concert across your Db2 environment, High Speed Utilities for Db2 with Next Generation Technology handle a wide range of data management tasks more efficiently without taxing Db2 resources. In addition, the utilities offer full availability, even while performing maintenance reorganization.
Interact without disruption
Applications maintain full read/write access to your data during copy, load, unload and reorg with zero downtime.
Give your processors a break
The utilities drastically reduce resource consumption by using advanced algorithms, managing their own buffering, performing I/O operations at the lowest level possible, and processing thousands of objects in a single statement.
With fast, fully online no-sort reorganization processes you can afford to keep data optimized at all times.
Choose your recovery method
Go beyond the standard recovery methods with options not only for restoring to a point-in-time copy but for rolling back changes or migrating data seamlessly to a brand new table space or subsystem.
Protect your data integrity
Find and eliminate inconsistencies that threaten your data integrity with online structural and referential integrity checks.
Automate data management processes
Mold the utilities to your business needs to simplify complex data management processes with adaptive automation.
"Don’t remain stuck in the past with your Db2 environment. Embrace the next generation with BMC High Speed Utilities with NGT. Stop worrying about how you’re going to manage your Db2 structures and begin concentrating on delivering quality and service to your end users. Plus, ensure that you can manage your Db2 environment, no matter how big it grows!"— Craig S. Mullins , President and Principal Consultant of Mullins Consulting, Inc
Say goodbye to downtime
- Keep your databases up and available throughout backup, recovery, and reorg tasks.
- Collect exhaustive performance data so you can address issues before they cause problems.
- Give your staff the solutions they need to keep things running smoothly.
Products included in this solution
The High Speed Utilities for Db2 solution is made up of the following products, all of which are designed to help you perform common database tasks faster and with fewer resources than the native Db2 utilities.
NGT Check for Db2®
Ensure the consistency of your Db2 data using the range of integrity checking features offered by Next Generation Technology Check for Db2. Ranging from structural checks for your table spaces and indexes to detailed referential integrity checks on column data, NGT Check for Db2 provides a faster, more powerful alternative to the native Db2 utilities. With BMC, running integrity checks won’t interfere with database availability.
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.
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.
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.
NGT Recover for Db2® (formerly Recover Plus)
Take advantage of three options for high-speed recovery with NGT Recover for Db2. With advanced recovery features, NGT Recover for Db2 lets you choose the right approach for the job. With the backout recovery option, you can start from the current state of your database and back out erroneous updates until you reach your desired point. Alternatively, you can use the forward recovery function to restore an earlier point-in-time copy and apply updates from there. Finally, you have the option to use image copies and log records to recover over into a new table space and translate the object IDs. In addition, unlike traditional recovery methods, NGT Recover for Db2 allows you to recover dropped objects automatically.
NGT Reorg for Db2®
Next Generation Technology Reorg for Db2 efficiently reorganizes Db2 data using a fraction of the resources required by all other Reorg processes. Through flexible built-in automation and patented advanced processing techniques, BMC NGT Reorg streamlines the Reorg process for tens of thousands of objects, eliminating the SORT, and providing full data availability to applications, while reducing overall CPU usage and Elapsed time no matter how much data is managed.
Next Generation Technology Stats efficiently gathers Db2 statistics using a fraction of the resources required by all other Runstats products to give you an exceptionally clear view of your database structures. With powerful options for when and how statistics are gathered, Db2 environments gain productivity while reducing the overall cost of Runstats processing. BMC NGT Stats can tell you exactly how well your databases are performing.
Snapshot Upgrade Feature
Working in concert with a variety of other BMC utilities, the Snapshot Upgrade Feature provides for near-continuous availability during many database processes. By exploiting the hardware capabilities of intelligent storage devices, the Snapshot Upgrade Feature allows you to create data-consistent copies instantaneously, with little to no outages. These point-in-time snapshot copies can be used to enhance recovery, unload, and reorg tasks.