Tools Customizer terminology
Tools Customizer uses several unique terms that you should be familiar with before you begin to use Tools Customizer.
- Products and components
- How an IBM® Tool is packaged determines whether it is referred to as a product or as a component in the Tools Customizer documentation and interface. An IBM Tool that is ordered as a stand-alone entity (that is, not as part of a solution pack) is referred to as a product. An IBM Tool that is part of a solution pack is referred to as a component. Some IBM Tools are available in both formats; therefore, the same IBM Tool can be referred to as a product or as a component depending on how it is packaged.
- Db2® entry
You can customize Db2 SQL Performance Analyzer on one or more Db2 entries. A Db2 entry can be any of the following items:
- Db2 subsystem
- A distinct instance of a relational database management system (RDBMS) that is not part of a data sharing group. An example of a Db2 subsystem name is DB01.
- Db2 group attach name
- The name that is used by the TSO/batch attachment, the call attachment facility (CAF), DL/I batch, utilities, and the Resource Recovery Services attachment facility (RRSAF) as a generic attachment name. An example of a group attach name is DSG1. Some products and components do not support Db2 group attach.
- Db2 data sharing member
- A Db2 subsystem that is assigned by the cross-system coupling facility (XCF) to a data sharing group. An example of a Db2 data sharing member name is DB02.
Tools Customizer maintains the following lists of Db2 entries:
- Associated list
The list of Db2 entries that are associated with Db2 SQL Performance Analyzer. If the product to be customized requires Db2 entries, you can customize Db2 SQL Performance Analyzer only on Db2 entries that are in the associated list. When you customize Db2 SQL Performance Analyzer, this list is displayed in the Db2 Entries, Associations, and Parameter Status section of the Customizer Workplace panel.
You can add and copy Db2 entries to the associated list. When you add or copy Db2 entries to the associated list, the entries are associated with Db2 SQL Performance Analyzer.
- Master list
The list of all Db2 entries that are defined but are not associated with Db2 SQL Performance Analyzer. Tools Customizer obtains information about these Db2 entries either from entries that were created manually or from the customizations of other products that were discovered. If you remove a Db2 entry from the associated list, the Db2 entry is added to the master list. When you create a new Db2 entry, it is added to the master list, and when you associate the new entry with Db2 SQL Performance Analyzer, it is removed from the master list and added to the associated list. The master list is displayed on the Associate a Db2 Entry for Product panel.
If the associated list does not have the Db2 entries on which you want to customize Db2 SQL Performance Analyzer, you can associate existing entries from the master list to the associated list.
You can create new Db2 entries and copy existing entries to the master list.
- High-level qualifier
- The high-level qualifier is considered to be all of the qualifiers except the lowest level qualifier. A high-level qualifier includes a mid-level qualifier.
- Product parameters
- Parameters that are specific to Db2 SQL Performance Analyzer. These parameters are defined by Db2 SQL Performance Analyzer and are stored in a data member that is defined by Db2 SQL Performance Analyzer.
- LPAR parameters
- Parameters on the local LPAR that are required to customize Db2 SQL Performance Analyzer. These parameters are defined by Tools Customizer and are stored in an LPAR parameter data member.
- Db2 parameters
- Parameters for a Db2 entry. These parameters are defined by Tools Customizer and are stored in a Db2 parameter data member.
- Configuration
- A set of parameter values and selected tasks and steps that you use to generate the jobs that
customize Db2 SQL
Performance Analyzer.
For example, you might want to have a test configuration and a production configuration on the same Db2 entry.
- Status type
- Product, LPAR, and Db2 entry status type
After you specify the product that you want to customize, the product, the LPAR, and the Db2 entries have a status. The status is partly based on whether required parameters are defined. For some products, LPAR parameters or Db2 parameters might not be required. In these cases, the status is Not Required.
To customize Db2 SQL Performance Analyzer, all of the required parameters must be defined.
If required parameters for the product parameters, LPAR parameters, or Db2 parameters are not defined, the status of the parameters is Incomplete. Define values for parameters by manually editing them or by generating the customization jobs and specifying values for all of the required parameters that are displayed on the panels.
When values for all of the required parameters are defined, the status is Ready to Customize. Customization jobs can be generated only when all of the required parameters are defined and the status is Ready to Customize or Customized for the product parameters, LPAR parameters, and Db2 parameters for the Db2 entries on which Db2 SQL Performance Analyzer will be customized.
The following table shows the meaning of the status types. Each status is defined differently for each type of parameter.
Table 1. Status types for the product, the LPAR, and the Db2 entries Status Product LPAR Db2 entries Incomplete The required product parameters are not defined. The required parameters are not defined. The required parameters are not defined. Discovered The product parameter definitions were discovered by using the product Discover EXEC. N/A N/A Ready to Customize The required product, is Ready to Customize or Customized for the LPAR and at least one associated Db2 entry. You can generate the customization jobs. The required LPAR parameters are defined or LPAR parameters are not required. The required Db2 parameters are defined or Db2 parameters are not required. Verify Values The required product or component parameter values are defined but they either have not been verified or verification is not enabled on the Product or Component Parameters panel. The required LPAR parameter values are defined, but they either have not been verified or verification is not enabled on the LPAR Parameters panel. The required Db2 parameter values are defined, but they either have not been verified or verification is not enabled on the Db2 Parameters panel. Customized The jobs are customized on the local LPAR. The jobs are customized for the product or for all of the associated Db2 entries on the local LPAR. The jobs are customized for the Db2 entry. Errors in Customization N/A N/A Errors occurred while the customization jobs were being generated. Not Required N/A LPAR parameters are not required. Db2 parameters are not required.