Data sets that Tools Customizer uses during customization

Tools Customizer uses several unique data sets during the customization process. Familiarize yourself with these data sets before you begin to use Tools Customizer.

Several different data sets are required to customize Db2® SQL Performance Analyzer with Tools Customizer. These data sets are supplied by Db2 SQL Performance Analyzer, supplied by Tools Customizer, or allocated by Tools Customizer.

Db2 SQL Performance Analyzer provides the following data sets:
Metadata library
Contains the metadata for the product to be customized. Tools Customizer uses the metadata to determine which tasks, steps, and parameters to display on the Product Parameters panel, the LPAR Parameters panel, and the Db2 Parameters panel. This data set also contains the templates that Tools Customizer uses to generate the customization jobs.

The metadata library naming convention is high_level_qualifier.SANLCKPCQMHLOHLRDYXIMZDENU, where high_level_qualifier is all of the segments of the data set name except the lowest-level qualifier.

You specify the metadata library on the Specify the Metadata Library panel. READ access to this data set is required.

Discover EXEC library (CLIST library)
Contains the Db2 SQL Performance Analyzer Discover EXEC. When you customize Db2 SQL Performance Analyzer, you can use the Discover EXEC to automatically retrieve and store product information, such as parameter values from an already customized product. Tools Customizer saves the discovered information in the data store.

The default name of the data set is the high-level qualifier for the metadata library plus a lowest-level qualifier. For Db2 SQL Performance Analyzer, the lowest-level qualifier is SANLCKPCQMHLOHLRDYXIMZCLSTDENUDENUDENUDENUDENU. You can change the default value on the Discover Customized Product Information panel. EXECUTE access to this data set is required.

Tools Customizer provides the following data sets:
Tools Customizer metadata library
Contains the metadata for the Db2 and LPAR parameters that are required to customize Db2 SQL Performance Analyzer. Tools Customizer uses the metadata to determine which parameters to display on the Db2 Parameters panel and the LPAR Parameters panel. In addition, Tools Customizer uses information in the metadata library to determine whether additional Db2 and LPAR parameters need to be displayed on these panels. As you customize different products, different Db2 and LPAR parameters might need to be defined.

The default name of the data set is Db2TOOL.CCQ110.SCCQDENU. You can change the default value on the Tools Customizer Settings panel. READ access to this data set is required.

Tools Customizer table library
Stores information about jobs that are customized. Job information that is stored includes a description of the job, its member name and template name, the SSID, group attach name, and when the job was generated.

The default name of the data set is Db2TOOL.CCQ110.SCCQTENU. WRITE access to this data set is required.

Tools Customizer requires that the following data sets exist during the customization process. If the data sets do not exist, Tools Customizer automatically allocates them.
Discover output data set
Contains the output that is generated when you run the Db2 SQL Performance Analyzer Discover EXEC. The Db2 SQL Performance Analyzer Discover EXEC retrieves the metadata and values for the parameters from a previous customization of Db2 SQL Performance Analyzer.

The default name of the data set is Db2TOOL.CCQ110.DISCOVER. You can change the default value on the Tools Customizer Settings panel or the Discover Customized Product Information panel. WRITE access to this data set is required.

Data store data set
Contains product, LPAR, and Db2 parameter values, and Db2 entry associations. Tools Customizer uses this data set to permanently store all information that is acquired about the product, Db2 subsystems or data sharing groups, and LPAR when you customize products on the local LPAR.

The default name of the data set is Db2TOOL.CCQ110.DATASTOR. You can change the default value on the Tools Customizer Settings panel. WRITE access to this data set is required.

Customization library
Contains the customization jobs that Tools Customizer generates for Db2 SQL Performance Analyzer.

Tools Customizer checks whether a customization library name was specified for more than one instance of the same version of the same product. If the same customization library name is specified for more than one product of the same version, the CCQD123E message is issued to prevent you from overwriting previously generated customization jobs. Ensure that you specify unique qualifier for the customization library for each instance of the product.

To customize Db2 SQL Performance Analyzer, submit the members of the data set in the order in which they are displayed on the Finish Product Customization panel.

The data set naming convention is hlq.$LPAR_name$.xyzvrm, where:
  • hlq is the value of the Customization library qualifier field on the Tools Customizer Settings panel (CCQPSET)
  • LPAR_name is the four-character LPAR name
  • xyzvrm is the three-letter product identifier with the version, release, and modification level

For example, the data set name might be Db2TOOL.PRODUCT.CUST.$MVS1$.XYZ410.

WRITE access to this data set is required.

Tools Customizer allocates the data sets for the discover output, the data store, and the customization library with the attributes that are shown in the following table:
Table 1. Data set attributes for allocating the Discover output, data store, and customization library data sets
Data set Organization Record format Record length Block size Data set name type
Discover output data set PO Variable block 16383 32760 LIBRARY
Data store data set PO Variable block 16383 32760 LIBRARY
Product customization library PO Fixed block 80 32720 LIBRARY
Restrictions:
  • Multiple users cannot simultaneously share the discover output data set, data store data set, Tools Customizer metadata library, and metadata library.