Default language.

Writer instructions

Page title

For most spaces, this page must be titled Space announcements.

For spaces with localized content, this page must be titled Space announcements l10n.

Purpose

Provide an announcement banner on every page of your space.

Location

Move this page outside of your home branch.

Guidelines

Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Reorg for Db2 13.1.

BMCUTIL table


The BMCUTIL table contains information about BMC products that are currently running.

Products use the BMCUTIL table to control the use of product IDs. Each product must have a unique product ID for restart purposes. If you have more than one product installed, all of these products should share the same BMCUTIL table. Products insert rows into the BMCUTIL table during the UTILINIT phase and update the table as the job status changes. Products also delete rows from the BMCUTIL table during the UTILTERM phase.

The following table describes the contents of the BMCUTIL table:

Column name

Data type

Description

UTILID

CHAR(16)

Product identifier

STATUS

CHAR(1)

Execution status of the product:

  • A (active, not executing command)
  • I (initializing)
  • P (pausing or pause-stopped)
  • S (stopped)
  • T (terminating)
  • X (executing command)

UTILNAME

CHAR(8)

Name of the executing product:

  • CHECK
  • COPY
  • STATS
  • LOAD
  • RECOVER
  • REORG
  • UNLOAD

PHASE

CHAR(8)

Current phase of the product

BMC AMI Copy does not use this column.

( BMC AMI Check, BMC AMI Load, BMC AMI Reorg, BMC AMI Stats, and BMC AMI Unload) The value for this column is always UTILINIT.

USERID

CHAR(8)

User ID executing the product

SSID

CHAR(4)

Db2 subsystem where the product is running

RESTART

CHAR(1)

Restart option:

  • N (not restart)
  • P (RESTART(PHASE))
  • Y (RESTART)

DASD MANAGER PLUS does not use this column.

(BMC AMI Check, BMC AMI Load, BMC AMI Reorg, BMC AMI Stats, and BMC AMI Unload) The value for this column is always N.

NOTEID

CHAR(8)

TSO user ID to be notified

DASD MANAGER PLUS, BMC AMI Check, BMC AMI Load, BMC AMI Reorg, BMC AMI Stats, and BMC AMI Unload do not use this column.

DBNAME

CHAR(8)

(BMC AMI Recover and REORG PLUS) Name of the database containing the table or index space for which the last checkpoint was taken

This value can be blank.

The other products do not use this column.

SPNAME

CHAR(8)

(BMC AMI Recover and REORG PLUS) Name of the table or index space for which the last checkpoint was taken

This value can be blank.

The other products do not use this column.

SPSTATUS

CHAR(5)

(REORG PLUS) Space status before the product stopped

The other products do not use this column.

COMMANDNO

SMALLINT

(BMC AMI Check, BMC AMI Load, BMC AMI Reorg, BMC AMI Stats, and BMC AMI Unload ) Always 1

For all other products, this column is always 0.

COMMAND

VARCHAR(256)

First 256 characters of the product command text

BMC AMI Recover, DASD MANAGER PLUS, BMC AMI Copy, BMC AMI Check, BMC AMI Load, BMC AMI Reorg, BMC AMI Stats, and BMC AMI Unload do not use this column.

STATE

LONG VARCHAR

Product state and sync information

DASD MANAGER PLUS, BMC AMI Check, BMC AMI Load, BMC AMI Reorg, BMC AMI Stats, and BMC AMI Unload do not use this column.

START_TIMESTAMP

TIMESTAMP

Starting timestamp of the product

BMC AMI Check, BMC AMI Load, BMC AMI Reorg, BMC AMI Stats, and BMC AMI Unload do not use this column.

 

 

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