BMC AMI LOBMaster for Db2^®

BMC AMI LOBMaster for Db2 eliminates the need to run multiple utilities that potentially bring an object offline. It will perform all the required LOB maintenance, while leaving all objects online for application processing without requiring SORT calls.

• Replace a four-step, manually intensive process with single, automated step
• A single command consolidates the required steps to validate, maintain, and correct LOB data
• LOBs are validated during REORG, LOAD, and UNLOAD processes, eliminating the need to run CHECK INDEX, CHECK LOB, and CHECK DATA
• Adaptive parallel processing techniques reduce elapsed times and can spread work across a sysplex environment
• Applications maintain full access to the LOB data during a reorg
• Powerful reporting capabilities show you the size of the LOBs you have

Db2 LOBs and unstructured data have become a growing concern to database administrators (DBAs) who must manage the massive amounts of datasets, indexes, and new data. True management of LOBs requires constant execution of four different utilities: CHECK DATA, CHECK INDEX, CHECK LOB and REORG – in the correct order. These checks are time and resource intensive and if they are not done correctly your data integrity is at risk BMC LOBMaster for Db2 simplifies data management by consolidating all the required processes into a single, high-speed solution that:

• Checks the integrity of all LOB objects
• Reports on all errors
• Corrects any errors that can be corrected
• Minimizes resource usage
• Reduces utility times and resources
• Facilitates deployment of new applications with LOBs

• Speed: LOBMaster is designed specifically for a LOB’s massive size and unique structure. It does not require any SORT, FLASHCOPY, or unload during a REORG, so CPU and elapsed time are greatly reduced.
• Parallelism: Multiple LOBs and indexes can be run in parallel using unique server technology, even spreading work across a sysplex.