DBRM and SQL analysis tools

The DBRM and SQL analysis tools include DBRM Checker, DBRM Load Module Cross-Reference, and Load Module Static SQL Report. The following topics provide more information about these tools:

About this task

  • Using DBRM load module cross-reference
    The DBRM load module cross-reference (hereafter called DBRM cross-reference) extends the logic of DBRM Checker to include load module comparisons.
  • Creating the static SQL load module report
    The static SQL Load module (BNDA007) produces a report that shows which load module and CSECTs within the load module call static SQL. This report is useful when you attempt to match DBRMs with load modules.
  • Catalog cleaning (program BNDA020)
    Program BNDA020, one of the DB2® Bind Manager catalog clean-up programs, correlates the package entries in the DBRM catalog to one or more load libraries to determine which packages are still referenced by load modules.
  • DBRM creation (program BNDA024)
    Use the BNDA024 batch program to create DBRMs from the catalog.
  • Catalog timestamp listing (program BNDA030)
    Use the BNDA030 batch program to identify all occurrences of a DBRM in the catalog and determine which instances have timestamps that match the timestamp in the DBRM.
  • Catalog cleanup (program BNDA036)
    Program BNDA036, the DB2 Bind Manager catalog cleanup program that is used with DB2 Version 8 and later, correlates the package entries in the DBRM catalog to one or more load libraries to determine which packages are still referenced by load modules.
  • BNDA055
    BNDA055 is designed to improve the performance of BNDA036 by removing the need for BNDA036 to scan large numbers of NCAL modules. Performance of BNDA036 can be improved by removing any libraries that consist exclusively of NCAL modules from the BNDA036 JCL and processing those libraries with BNDA055 instead.
  • Batch DBRM interpreter (BNDA043)
    The batch DBRM interpreter program (BNDA043) is a batch program that is designed to produce the same output as the existing DBRM Browser ISPF function.
  • Catalog cleanup (program BNDA046)
    Program BNDA046, the DB2 Bind Manager catalog clean up program that is used with DB2 Version 7 and earlier, correlates the package entries in the DB2 catalog to one or more load libraries to determine which packages are still referenced by load modules.