Getting started with Db2 Automation Expert sample best practice profiles

Db2 Automation Expert provides sample profiles that can be used for common maintenance tasks.

The sample profiles provide examples of common object, utility, exception, and job profiles containing typical defaults that can be tailored for your site's needs.

The best practice sample profiles can help you leverage IBM®-advised industry trends and Db2 enhancements. These profiles reflect Db2 best practices as recommended by IBM Db2 for z/OS professionals, and provide a range of examples for different object types and schedules.

Installing the sample profiles

The sample profiles are installed using Tools Customizer. For more information, see Preparing to customize Db2 Automation Expert.

After installation, you can rename or export the sample profiles with a different creator name and/or profile name. If you do not, and the sample profiles are reinstalled with the same creator and profile name, any changes that you make are overwritten.

Alternatively, you could make the sample profiles view only. To do so, update each sample profile and set the Share Option field to V for view only. Users can then export and import these profiles under their own creator ID and modify them for their own use.

Before using the sample profiles, modify them to fit your location's data set naming conventions and other location-specific information.

Using the sample profiles

The sample profiles are each described in the Sample profiles reference.

You can start by reviewing the best practice job profiles to see examples of common maintenance tasks. Check the profiles that you are interested in to see if modifications are needed for your location. For example, in the BEST PRACTICE RUNSTATS job profile, the ALL OBJECTS object profile is included. You might want to initially limit the object set until you understand how the job profile generates the job.

If you want to generate these job profiles as active or passive actions instead of JCL jobs, review the sample maintenance windows that are installed with Db2 Automation Expert. The samples provide common time periods for running maintenance activities and can be customized for your site. For information about the samples, see Sample maintenance windows reference.