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 Log Master for Db2 13.1.

Action codes in the Log Master online interface


Many panels in theBMC AMI Log Master for Db2 online interface display a list of items, and enable you to perform various actions on the items in the list (for example, to delete or edit an item) by using action codes.

To perform an action, enter an action code in the field labelled 'ACT' or 'Action.'

Related topic

The following figure shows a sample online interface panel. The action codes that are available on this panel are shown in bold text.

.------------------------------------------------------------------------.
|                            Tablespace List                Line 1 of 53 |
| Command ===> _______________________________________ Scroll ===> HALF  |
| Qualifier: AFR%                                           SSID : DBAN  |
|                                                        Selected: 0     |
| Enter an action code and press Enter.                   More:     +    |
| S=Select DB=Database TB=Table IX=Index CO=Column PL=Plan               |
| ACT  TABLESPACE         OWNER     BUF POOL  PSID  PARTS  TABLES        |
| __   AFR230D.ACAREPOS   AFR230D   BP0         17      0       7        |
| __   AFR210I.ACAREPOS   AFR210I   BP0          5      0       7        |
| __   AFR220I.ACAREPOS   AFR220I   BP0         27      0       7        |
| __   AFR240D.ACAREPOS   AFR240D   BP0         18      0       7        |
| __   AFR230I.ACAREPOS   AFR230I   BP0         20      0       7        |
| __   AFRFIN.AFRACCT     LSB       BP0          2      3       1        |
| __   AFRAUDIT.AFRACCT   LSB       BP0          6      3       0        |
| __   AFRFIN.AFRHIST     LSB       BP0          8      0       1        |
| __   AFRAUDIT.AFRHIST   LSB       BP0         12      0       0        |
| __   AFRAUDIT.AFRHOLD1  LSB       BP0          2      0       0        |
| __   AFRAUDIT.AFRHOLD2  LSB       BP0          4      0       0        |
| __   AFRORDER.AFRORDER  LSB       BP0          2      0       1        |
| F1=Help F3=Exit F7=Backward F8=Forward F12=Cancel                      |
'------------------------------------------------------------------------'

In most cases, action codes perform the same action on all interface panels. However, in a few cases, Log Master uses the same single-letter code to represent two actions, but never on the same interface panel. The following table lists the general actions associated with the most common action codes.

Action code

Meaning

S=Select

Select one item from the list for further action.

Use this action code to select one of the items to operate on or to add the selected item to another list that you are creating. Frequently, you can use this action code after you generate a list by using a wild card expression.

D=Delete

Delete one item from the current list.

I=Insert

Insert a new item into the current list.

Frequently, Log Master displays additional panels where you can specify the attributes of the newly inserted item.

I=Information

Display another panel containing information about the selected item.

Use this action code to obtain enough details about the item to decide whether you want to select it or delete it from the current list.

E=Edit

Display another panel where you can change or examine the attributes of the selected item.

This action affects only the selected item; you cannot edit one item and then save it as another item. To create another item, use I=Insert or R=Repeat, if available.

R=Repeat

Create a copy of the selected item and add the newly created copy to the current list.

Use this action code when you are inserting a new item that is similar to an existing item. You can repeat the existing item, and then edit it to make the required changes, instead of defining all of the attributes for the entire new item.

B=Browse

View the contents of the selected item.

Usually, Log Master provides this action code when you are working with a list of files. When you type B and press Enter, Log Master initiates a TSO edit session of the selected file with read-only access. You can examine the file using TSO edit commands. When you exit the TSO session, Log Master redisplays the online interface panel.

L=Browse Load Data file

View the contents of the output load data file.

Log Master initiates a TSO edit session of the selected file with read-only access. You can examine the file using TSO edit commands. When you exit the TSO session, Log Master redisplays the online interface panel.

L=List Associated Work IDs

Display another panel containing a list of all of the work IDs that use the selected item (filter).

Log Master provides this action code only when you are working with a list of filters.

O=Logical OR

Insert a logical OR operator between two portions of a filter—called filter predicates.

Log Master provides this action code only when you are defining a filter through the Structured interface.

O=Options

Display another panel where you can specify optional values related to the selected Db2 object.

Log Master provides this action code only when you are defining the Db2 objects as part of an automated drop recovery.

C=Browse Load Control file

View the contents of the output load control file.

Log Master initiates a TSO edit session of the selected file with read-only access. You can examine the file using TSO edit commands. When you exit the TSO session, Log Master redisplays the online interface panel.

C=Catalog Search

Display the first in a set of panels that make up the Log Master Catalog Search facility. The Catalog Search facility is similar to the object search features of the BMC AMI Catalog Manager for Db2 product.

Use this action code to select a Db2 object (such as a table or a column name) when you are not certain of the exact name. You can search the current Db2 catalog using parts of a name and wildcard expressions. You can also search based on object relationships. For example, if you know the table name, but not the column name, you can display a list of all columns in the table, and select from that list.

DB=Database

Display another panel that lists the name of the database that contains the selected Db2 object.

This action code is part of the Log Master Catalog Search facility.

TS=Table Space

Display another panel that lists either

  • the name of the table space that contains the selected Db2 object
  • the names of all of the table spaces contained in the selected Db2 object

This action code is part of the Log Master Catalog Search facility.

TB=Table

Display another panel that lists either

  • the name of the table that contains the selected Db2 object
  • the names of all of the tables contained in the selected Db2 object

This action code is part of the Log Master Catalog Search facility.

CO=Columm

Display another panel that lists the names of all of the columns that are contained in the selected Db2 object. This action code is part of the Log Master Catalog Search facility.

IX=Index

Display another panel that lists the names of all of the indexes that relate to the selected Db2 object.

This action code is part of the Log Master Catalog Search facility.

PL=Plan

Display another panel that lists the names of all of the application plans that are dependent on the selected Db2 object.

This action code is part of the Log Master Catalog Search facility.

 

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