Common utility tables


This section describes the contents of the common utility, BMCHIST_STEP, and BMCHIST_OBJECT tables, considerations for these tables, and how to maintain them if necessary.

The BMC common utility tables contain information about the BMC products that you execute.

Important

CHECK PLUS, LOADPLUS, REORG PLUS, and UNLOAD PLUS use aliases. Support for Synonyms has been deprecated.

Table

Default name

Alias

Utilities that use this table

CMN_BMCDICT

BMC_BMCDICT

  • LOADPLUS
  • REORG PLUS

CMN_BMCHIST

BMC_BMCHIST

  • CHECK PLUS
  • Some content is unavailable due to permissions.

  • LOADPLUS
  • Some content is unavailable due to permissions.

  • REORG PLUS
  • UNLOAD PLUS
  • BMC AMI Load
  • BMC AMI Reorg
  • BMC AMI Unload

CMN_BMCSYNC

BMC_BMCSYNC

  • CHECK PLUS
  • BMC AMI Check
  • Some content is unavailable due to permissions.

  • DASD MANAGER PLUS (BMCSTATS)
  • LOADPLUS
  • BMC AMI Load
  • Some content is unavailable due to permissions.

  • Some content is unavailable due to permissions.

  • REORG PLUS
  • BMC AMI Reorg
  • UNLOAD PLUS
  • BMC AMI Unload

CMN_BMCUTIL

BMC_BMCUTIL

  • CHECK PLUS
  • BMC AMI Check
  • Some content is unavailable due to permissions.

  • DASD MANAGER PLUS (BMCSTATS)
  • LOADPLUS
  • BMC AMI Load
  • Some content is unavailable due to permissions.

  • Some content is unavailable due to permissions.

  • REORG PLUS
  • BMC AMI Reorg
  • UNLOAD PLUS
  • BMC AMI Unload

CMN_BMCXCOPY

BMC_BMCXCOPY

  • Some content is unavailable due to permissions.

  • BMC AMI Log Master
  • Some content is unavailable due to permissions.

  • Some content is unavailable due to permissions.

  • REORG PLUS
  • UNLOAD PLUS
  • BMC AMI Unload



  • BMC AMI Load
  • BMC AMI Reorg
  • BMC AMI Unload
  • BMC AMI Check
  • Some content is unavailable due to permissions.

  • Some content is unavailable due to permissions.

  • BMC AMI Log Master
  • High-speed Apply Engine

Warnings and considerations for common utility tables

This topic describes important information that you need to know when using the common utility tables.

Warning

The following warnings apply to the common utility tables:

  • To prevent unpredictable results, do not run any of the following products against the BMC common utility tables or table spaces:
    • LOADPLUS
    • BMC AMI Load
    • REORG PLUS
    • BMC AMI Reorg
    • UNLOAD PLUS
    • BMC AMI Unload
    • BMC AMI Stats
    • BMCSTATS
  • Because

    Some content is unavailable due to permissions.

    uses BMC tables during the recovery process, you cannot use

    Some content is unavailable due to permissions.

    to recover any BMC table except the BMCHIST table.
  • Do not run the RUNSTATS utility against the BMC common utility tables. Doing so can negatively impact utility performance.
  • We strongly recommend that you use the ISOLATION (UR) bind option and issue SQL COMMIT statements when querying the tables in the BMC database. If objects in the BMC database are restricted for UPDATE, the executing BMC utilities might not be able to complete successfully.

Note the following considerations:

  • Some columns in the tables are present for compatibility with specific BMC utilities and are not used by all of the utilities.
  • If you have applications that depend on the structure or content of these tables, be aware that these tables are subject to change.
  • In general, the utility tables should not require maintenance, with the exception of BMCHIST.
  • You should back up the BMC table spaces on a regular basis to enable recoveries. If you use

    Some content is unavailable due to permissions.

    as the copy utility, you must use SHRLEVEL CHANGE for the following spaces:
    • BMCUTIL
    • BMCHIST
    • BMCSYNC
    • BMCXCOPY
    • BMCHISTS
    • BMCHISTO
  • Supported versions of the following BMC products support the LOCKROW installation option:

    • CHECK PLUS
    • LOADPLUS
    • REORG PLUS
    • UNLOAD PLUS

    If the value of the option is YES (which is the default value), the products use z/OS enqueues instead of SQL LOCK TABLE statements to serialize updates to the BMCSYNC and BMCUTIL tables.

    The following BMC products always use z/OS enqueues for serialization when updating the BMCSYNC and BMCUTIL tables:

    • Some content is unavailable due to permissions.

    • DASD MANAGER PLUS
    • Some content is unavailable due to permissions.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*