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

With BMC AMI LOBMaster for Db2® you can manage and validate unstructured data automatically to ensure the stored data is intact.

Ensure data integrity and meet compliance

  • Fast and easy: LOBs are validated as part of the utility function with parallel readers and writers increasing throughput
  • Online: Applications are left online throughout the entire process
  • Efficient and scalable: Reduced resource consumption with no SORT technology and processes designed specifically for the complexity of LOBS
BMC AMI Command Center Db2 File Locator

Ensure your data is intact

Automatically manage your complex LOBs with zero application downtime

Maintain data availability 100% of the time

Simplified Management

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

Simplify the rollout and maintenance of new LOB applications

Validation and Maintenance

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

Replace a four-step, manually intensive process with single, automated step

  • 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.
"Converting our DBADMIN tools to BMC has proven very beneficial to us in terms of increased DBA productivity and reduced MSUs." — David Lueck, IT Manager, Database Administration, Western Illinois University
View all customer stories

Getting started with BMC AMI LOBMaster for Db2 is easy