Defining the MAINPACK identifier

In the Accounting report set you can use the MAINPACK identifier to distinguish plans according to the packages they contain. The representative package is either the first or the last package or DBRM executed within a plan.

This identifier is useful when the name of a plan does not provide satisfactory identification, as is the case with DBATs initiated by non-Db2 requesters that all have the same plan name DISTSERV.

You can define certain aspects of the MAINPACK identifier:

  • Whether the first or the last package executed within a plan is used as the MAINPACK.
  • Whether you want to use the package ID, the collection ID, or the location name of the package name as the value for the identifier. In the case of a DBRM, the program name is always used.

If you wish, you can have different MAINPACK definitions for data from different environments and from different plans.

The MAINPACK identifier can be used to include, exclude, and order data.

When you include data using MAINPACK, data from other packages belonging to the same plan is also reported. (If you used the PACKAGE identifier instead, data for that package, regardless of the plan, would be reported.) The same applies to ordering data.

The default definition for MAINPACK is to use the package ID of the first executed package.

The MAINPACK definition is stored in the member MAINPACK of the DPMPARMS data set. You can access the member using the MAINPACK Definition Member Editor, which is part of the Interactive Report Facility (IRF).

To access the editor, select option 4 (Maintain parameter data sets) from the Performance Expert main menu. The Data Set Maintenance Menu is displayed.

Figure 1. Selecting Maintain MAINPACK Definitions

DGOPMENU                   Data Set Maintenance Menu

Select one of the following.

4  1. Maintain exception thresholds
   2. Maintain correlation translations
   3. Maintain time zone information
   4. Maintain MAINPACK definitions

Exception data set

DPMPARMS data set

Command ===> __________________________________________________________________
 F1=Help    F2=Split   F3=Exit    F9=Swap   F12=Cancel

Type 4 in the input field to select Maintain MAINPACK definitions, and type the name of your DPMPARMS data set on the line below DPMPARMS data set.

Press Enter to go to the MAINPACK Definition Member Editor panel.

Use the editor to enter the main package specifications. Specify the requesting locations, connection IDs, plan names, and codes for the MAINPACK definition.

Figure 2. MAINPACK Definition Member Editor panel

 DGOPPMDS            MAINPACK Definition Member Editor          ROW 1 TO 1 OF 1

 Select one of the following MAINPACK definition codes for each
 specified combination of Requesting Location, Connection ID and
 Plan Name. Request EXIT when complete.

  Code      Description
   1        Package    ID of the first executed package
   2        Package    ID of the last executed package
   3        Collection ID of the first executed package
   4        Collection ID of the last executed package
   5        Location   of the first executed package
   6        Location   of the last executed package

 Action  Requesting Location  Connection ID  Plan Name  Code
 ____    ________________     ________       ________   _
 ******************************* BOTTOM OF DATA ********************************

 Command ===> ______________________________________________________________
  F1=Help    F2=Split   F3=Exit    F7=Up      F8=Down    F9=Swap   F12=Cancel

Enter the required information in the input fields. You can modify existing information by typing over it.

Standard ISPF editor line commands. For example:
Generate a new line
Delete a line
Duplicate a line
Move a line
Requesting Location
The 16-byte requesting location name. Db2 uses this name to identify the requester Db2 subsystem for distributed threads. For nondistributed threads this is the same as the local location name.
Connection ID
The 8-byte connection name used by Db2 to identify your environment.
Plan Name
The 8-byte name of the Db2 plan. In most cases it is a user-specified name, but for non-Db2 requesters it has a constant value DISTSERV.
One of the predefined definitions of MAINPACK.

You can get information about an entry field by moving the cursor to the field and pressing F1 (Help).