Space announcement

   

This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

Common utility tables

The following topics describe the contents of the common utility tables, considerations for these tables, and how to maintain them if necessary:

The BMC common utility tables contain information about the BMC utilities that you generate and submit through a BMC utility product.

The following table lists the tables that each utility uses and each table’s default name and synonym.

Common utility tables

Table

Default name

Synonym

Utilities that use this table

BMCDICT

CMN_BMCDICT

BMC_BMCDICT

  • LOADPLUS

  • REORG PLUS

BMCHIST

CMN_BMCHIST

BMC_BMCHIST

  • CHECK PLUS

  • COPY PLUS

  • LOADPLUS

  • RECOVER PLUS

  • REORG PLUS

  • UNLOAD PLUS

BMCLGRNX

CMN_BMCLGRNX

BMC_BMCLGRNX

  • COPY PLUS

  • Log Master

  • RECOVER PLUS

  • RECOVERY MANAGER

BMCSYNC

CMN_BMCSYNC

BMC_BMCSYNC

  • CHECK PLUS

  • COPY PLUS

  • DASD MANAGER PLUS (BMCSTATS)

  • LOADPLUS

  • RECOVER PLUS

  • RECOVERY MANAGER

  • REORG PLUS

  • UNLOAD PLUS

BMCTRANS

CMN_BMCTRANS

BMC_BMCTRANS

  • Log Master

  • RECOVERY MANAGER

BMCUTIL

CMN_BMCUTIL

BMC_BMCUTIL

  • CHECK PLUS

  • COPY PLUS

  • DASD MANAGER PLUS (BMCSTATS)

  • LOADPLUS

  • RECOVER PLUS

  • RECOVERY MANAGER

  • REORG PLUS

  • UNLOAD PLUS

BMCXCOPY

CMN_BMCXCOPY

BMC_BMCXCOPY

  • COPY PLUS

  • Log Master

  • RECOVER PLUS

  • RECOVERY MANAGER

  • REORG PLUS

  • UNLOAD PLUS

Warnings and considerations for common utility tables

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

Warning

The following warnings apply to the common utility tables:

  • Do not run LOADPLUS, REORG PLUS, or UNLOAD PLUS against the BMC common utility tables or table spaces. Doing so can cause unpredictable results.

  • Because RECOVER PLUS uses BMC tables during the recovery process, you cannot use RECOVER PLUS 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.

  • BMC strongly recommends 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 COPY PLUS as the copy utility, you must use SHRLEVEL CHANGE for the following spaces:

    • BMCUTIL

    • BMCHIST

    • BMCSYNC

    • BMCXCOPY

  • 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 MVS enqueues instead of SQL LOCK TABLE statements to serialize updates to the BMCSYNC and BMCUTIL tables.

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

    • COPY PLUS

    • DASD MANAGER PLUS

    • RECOVER PLUS

Was this page helpful? Yes No Submitting... Thank you

Comments