Skip to Content
Information
Limited support BMC 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 Apptune for Db2 13.1.

Layout data set

A layout data set member controls the appearance of the Explain Object Selection List and the Explain Results panel.

The Explain function is shipped with a default layout member (PSSREPA) in the  hlq.SAMP data set. The DOMCLIST allocates the product  hlq.llqSAMP data set to the PSSCNTL DD. The product does not allow you to customize PSSREPA, but you can copy the default layout to a new data set name and edit that member. You can save one or more layout members.

Warning

Note

The name of the delivered SAMP data set is hlq.llqSAMP. (The runtime library llq might use a different low-level qualifer (LLQ), depending on what values were entered during installation. Place all customized members in the hlq.llqSAMP data set.

To customize a default layout member:

  1. Copy the PSSREPA member to one of the following locations:
    • The userlib data set ( hlq.UBMCSAMP)

    • A different data set

      If you copy the member to a different data set, first allocate the target data set (for example, new.dsn) in the DOMCLIST on the PSSCNTL DD:

      Information
      Example
      ALLOC F(PSSCNTL) SHR REU DA('<new.dsn>' '<hlq>.UBMCSAMP' '<hlq>.BMCSAMP')
  2. Edit the new data set.
  3. Change the name of the member and then reference the new name as the layout data set.

The Layout Data Set panel contains the following options:

  • Edit layout data set opens the layout data set for editing.
  • Browse layout data set opens the layout data set for viewing. In this mode, you cannot edit the layout data set.
  • Use default data set instead of layout data set reverts to using the default data set to display the Explain Object Specification List and the Explain Results panel online.
  • Overwrite layout data set with default data set and edit replaces the contents of the layout data set with the contents of the default data set and opens the revised layout data set for editing.

The default layout data set contains comments to help you edit your layout data set.

 

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

BMC AMI Apptune for Db2 12.1