Creating active logs


OPERTUNE creates new logs by invoking IDCAMS from your OPERTUNE session. You can create a log in three ways:

You can also use the CREATELOG command to create a log. For more information, see Creating an active log using the CREATLOG command).

Important

You cannot create a log for a Db2 data-sharing group.

Use the Create Data Set Parameters panel to set or modify the CREATE command parameters, as displayed in the following figure:

DDTG DBI1 Create Data Set Parameters
Command ===> __________________________________________________________________

Enter attributes of the active log being created. Then press Enter.

Parameters of Active Log to be Created
Data set name . . . . . . . ____________________________________________
Read password . . . . . . . ________
Volume . . . . . . . . . . .______
Unit . . . . . . . . . . . ._________ (CYLINDERS, TRACKS, RECORDS,
MEGABYTES, KILOBYTES)
Primary . . . . . . . . . . ______
Secondary . . . . . . . . . ______
Catalog . . . . . . . . . . ____________________________________________
Catalog password . . . . . .______

The following input fields are displayed on the Create Data Set Parameters panel:

Field

Description

Data set name

The name of the active log to be created.

Read password

The password for the new log data set (optional).

Volume

The volume serial number of the storage device.

Unit

The unit of allocation to be used on the storage device, Specify one of the following values:

  • CYLINDERS
  • TRACKS
  • RECORDS
  • MEGABYTES
  • KILOBYTES

Primary

The number of units for the primary allocation.

Secondary

The number of units for the secondary allocation

Catalog

The name of the catalog that will contain the log.

Catalog password

(Optional) The password that will be used to access the catalog.

Creating an active log by specifying all parameters

To specify all of the parameters for a new log, perform the following steps:

  1. On the Add/Remove Active Logs panel, type Create on the Command line and press Enter.

    The Create Data Set Parameters panel is displayed. You can specify the CREATE command parameters on this panel.

  2. Type the requested information and press Enter to invoke IDCAMS.
    When processing is finished, the OPERTUNE IDCAMS Response panel is displayed with the results of the IDCAMS DEFINE CLUSTER command.

Creating an active log by copying parameters

To create a new log by copying the parameters from another log, follow these steps:

  1. On the Add/Remove Logs panel, select a data set by either typing a name in the Copy 1 Data Set Name field or typing 1 next to a log from the displayed list, and pressing Enter.
  2. Type Create on the Command line and press Enter.
    The Create Data Set Parameters panel displays the data set name, volume, unit, primary allocation, and secondary allocation information from the named log.
  3. Modify the information as necessary and press Enter to invoke IDCAMS.
    When processing is finished, the OPERTUNE IDCAMS Response panel is displayed with the results of the IDCAMS DEFINE CLUSTER command.

Creating an active log using the CREATLOG command

Use the following syntax to issue the CREATLOG command:

IN(DB2ssid@opertuneID) CREATLOG

Command syntax and parameters

image2018-12-25_18-12-47.png

Value

Description

DB2ssid

Db2 subsystem ID or the name of the Db2 data sharing group to which the command applies.

opertuneID

OPERTUNE system profile name (if OPERTUNE is running as a started task) or the batch job name (if OPERTUNE is running as a batch job).

dataSet

The name of the active log to be created.

volume

The volume serial number of the storage device.

records

The number of records the log will hold.

password

(Optional) The password for the log data set.

catalog

(Optional) The name of the catalog that will contain the log.

catpass

(Optional) The password that will be used to access the catalog.

 

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