Preparing to customize

Before you start to customize Db2® Utilities Enhancement Tool for the first time, determine all of the customization values that you need to specify during the customization process, and familiarize yourself with all of the customization tasks.

The following checklist lists and describes each significant customization step. Use this checklist to guide you through the entire customization process.

Tip: Print the following checklist and the data set names and parameter values worksheets. Use the worksheets to record your values, and refer to them during the customization process.
Task Link to detailed instructions Status
Tools Customizer basics
Prior to beginning the customization process, familiarize yourself with Tools Customizer terminology and data sets, and other basic information about Tools Customizer. Tools Customizer reference  
Hardware, software, and storage requirements
Verify that your environment meets the minimum hardware requirements. Verify that your environment meets hardware requirements  
Verify that your environment meets the minimum software requirements. To install and use Db2 Utilities Enhancement Tool, your environment must be running a supported version of the z/OS operating system and of Db2 for z/OS. Additionally, certain levels of maintenance might be required. Verify that your environment meets software requirements  
Verify that your environment meets CSA or ECSA minimum storage requirements, that your DFSMS rules support LOAD utility enhancements, and that your DASD storage is sufficient. Verify that your environment meets storage requirements  
SMP/E installation
Verify that Db2 Utilities Enhancement Tool has been installed correctly. Db2 Utilities Enhancement Tool is installed by using standard SMP/E processing. Verify that Db2 Utilities Enhancement Tool has been installed successfully  
Verify that Tools Customizer for z/OS has been installed correctly. Tools Customizer for z/OS is installed by using standard SMP/E processing. Verify that Tools Customizer has been installed successfully  
Security requirements
Make sure that you have the required authorizations to use Db2 UET. Security requirements  
Started task considerations
If you have a very high volume of activity, you can run multiple started tasks concurrently to handle the workload more efficiently. Considerations for running multiple started tasks  
Data sharing considerations
Review deployment and configuration issues for Db2 data sharing environments. Considerations for Db2 data sharing environments  
Dispatching priority requirements
Ensure that the dispatching priority for the Db2 UET started task is set correctly with respect to other dispatching priorities. Dispatching priority  
WTO messages for automated operations
Consider whether to use the Write-to-Operator (WTO) messages that Db2 UET issues for automated operations. Use of WTO messages for automated operations  
Vector table issue
Db2 UET uses the shared 4-KB vector table. Review information about shared storage. Operational issue related to the vector table  
DB2 version migration
Review actions that you need to take when a Db2 subsystem that is used with Db2 UET is migrated to a later version of Db2, or when a fallback to an earlier version is required. Db2 version migration considerations  
Gather data set names
During the customization process, you must specify data set names for the following things:
  • Tools Customizer
  • FEC (common code)
  • Db2 Utilities Enhancement Tool
Worksheets: Gathering required data set names  
Gather parameter values
During the customization process, you must specify parameter values for Db2 Utilities Enhancement Tool, for Db2, and for your LPAR. Worksheets: Gathering parameter values for Tools Customizer  
Customize Db2 Utilities Enhancement Tool

Start Tools Customizer by running a REXX EXEC from the ISPF Command Shell panel.

Starting Tools Customizer  

Set up Tools Customizer user settings. If you are running Tools Customizer for the first time, you must modify several user settings to suit your environment. Otherwise, if the user settings that you have already established are still appropriate, skip this step.

Modifying Tools Customizer user settings  

Complete the steps in the appropriate customization roadmap based on the type of customization that you are performing.

Customizing for the first time

To customize the product for the first time, follow Roadmap: Customizing Db2 Utilities Enhancement Tool for the first time.

Roadmap: Customizing Db2 UET for the first time  
Customizing a different version of the product

If you have already customized a version of the product and you want to use the same parameter values to customize a different version, follow Roadmap: Customizing a new version of Db2 Utilities Enhancement Tool.

Roadmap: Customizing a new version of Db2 UET from a previous customization  
Recustomizing the same version of the product

If you have customized this version of the product for the first time, want to go back and change parameters and regenerate jobs, follow Roadmap: Recustomizing Db2 Utilities Enhancement Tool.

Roadmap: Recustomizing Db2 UET  

Some customization options require you to manually complete additional tasks after you have used Tools Customizer. If you generated jobs in Tools Customizer that correspond to the following customization options, complete the additional tasks before you submit the jobs. In some cases, an optional task can be completed either by using Tools Customizer or by manually completing tasks without using Tools Customizer.

APF authorization
The SABPLOAD data set must be APF authorized. APF-authorizing the load library  
Make the started task address space available to user interfaces
Copy the Db2 UET started task PROC to your system PROCLIB to make the started task address space available to the user interfaces for the product. Copying the started task PROC  
Copy the DSNUTILF module
The DSNUTILF module must be in an APF-authorized library in the STEPLIB or JOBLIB concatenation for the Db2 LOAD utility jobs. Copying the DSNUTILF module  
Optional: Customize DSNUTILB intercept parameters
You can customize the cancel parameters and global parameters that the DSNUTILB intercept uses for all thread blocking and cancelation activities. Customizing DSNUTILB intercept parameters (optional)  
Optional: Set up the initialization options member
The initialization options member, called abpidOPTS, is used by the Db2 UET started task upon initialization. Setting up additional initialization options members (optional)  
Optional: Create a security exit
You can create a security user exit to control user access to product commands for intercept processing and to certain ISPF panels. Creating a security exit (optional)  
Optional: Create a pre- or post-cancel exit
You can create pre-cancel and post-cancel exits to perform additional processing before or after thread cancelations. Creating a pre- or post-cancel exit (optional)  
Prepare Db2 UET for use
Before you can use the product, you must perform initial set-up tasks. Getting started