System and SQL Performance products for Db2 customization tasks

Reading the overview section

The overview section contains important information, read the section before commencing the customization.

See Overview-of-customization-tasks.

Controlling access to the System and SQL Performance products for Db2

See Controlling access to the System and SQL Performance products.

Performing post-installation tasks

See Post-installation tasks.

Customizing the System and SQL Performance products

See Customizing the System and SQL Performance products.

Verifying product installation

See Customization tasks for verifying installation.

See Customizing OPERTUNE.

Customizing the user IDs for the DBC component

The DBC is the host address space that the System and SQL Performance products use.

For an overview, see User-IDs-for-the-DBC-component.

For more specific information about required authorizations for DBC, see the section about the required authorizations for user IDs in the BMC Infrastructure Components Administration Guide.

Setting security and permissions for user IDs for the System and SQL Performance products

Multiple user IDs are associated with installing, configuring, and using the product.

See Security-and-permissions-for-user-IDs-for-the-System-and-SQL-Performance-products.

Customizing the plan name

The System and SQL Performance products provide one plan. APPTUNE, SQL Explorer, MainView for Db2 - Data Collector , SQL Performance, and System Performance use this plan. Pool Advisor does not use a plan.

See Plan-name.

Granting authorizations for MVS security

If you have an IBM MVS security system, you must grant the required authorizations, even if your security system does not control access to DB2.

See z-OS-security.

Considerations when using DBC with CA-AF2, CA-Top Secret, or RACF security

If you use the IBM RACF or the CA Technologies CA-ACF2 or CA-Top Secret security product to control access to Db2, considerations apply.

See Managing-security-with-CA-ACF2-CA-Top-Secret-or-RACF-security.

Establishing Db2 and product security

The product administrator is responsible for establishing default security options for all users and for maintaining individual user access options through the user profile.

See Db2-and-product-security.

Defining a DOMPLEX

Editing a DOMPLEX option set online

Use this procedure to edit the DOMPLEX option set through the online interface.

See Editing-the-DOMPLEX-option-set-online.

Verifying the product for data sharing members

Creating indexes to improve performance

Generating Help text from Db2 trace record field descriptions

Adding or replacing the CLIST member for the ISPF interface

Add or replace the CLIST for the ISPF interface.

See Adding-or-replacing-the-CLIST-member-for-the-ISPF-interface.

(Optional)) Making products available from a menu

You can make products available from the menu.

See Making-products-available-from-a-menu.

(Optional)) Invoking SQL Explorer directly

(Optional)) Invoking BMC products without LIBDEFs

Complete this procedure if you have your own ISPF environment and do not want to invoke DOMCLIST with the LIBDEF command.

See Invoking-System-and-SQL-Performance-products-without-LIBDEFs.

Verifying or changing the global resource enqueues

This task is required for shared-DASD environments that use a global resource manager like GRS or MIM.

See Verifying-or-changing-the-global-resource-enqueues.

(Optional)) Refreshing the MVS Linklist Lookaside

Refresh the LINKLST data set only if both of the following conditions are true:

• You are using the MVS Linklist Lookaside (LLA) feature.
• You have installed the product load modules into a LINKLST data set.

See Refreshing-the-MVS-Linklist-Lookaside.

Verifying the product authorization

All BMC Software products require product authorization before you can use them.

See Verifying-the-product-authorization.

(PTF BQU1326 and BQU1107 applied)
Install the ADMIN_EXPLAIN_MAINT stored procedure.

Verifying or customizing the DOMPLEX option set

Verifying or changing the DOMPLEX parameters

The DOMPLEX parameters affect all users and procedures that use the same DOMPLEX option set.

This task is required for a new product installation. It is optional for a migration installation.

See Verifying-or-changing-DOMPLEX-parameters.

Checking the default user profile

User Profiles define the operating characteristics for a product session, including the authorizations granted to individual users.

See Checking-the-default-User-Profile.

Additional information about archiving and the Next Generation Logger (NGL)

You can set up a procedure to automatically generate an archive of a log file, and set up a post-processing job that is automatically submitted each time an archive procedure finishes.

See Additional-information-about-archiving-and-the-NGL.

Starting the DBC subsystem

Checking the system console log messages

Starting a product session

(Required for all products)

If you previously terminated your session, perform this task. Otherwise, the product’s main menu is still displayed.

See Initiating-a-product-session.

Selecting a DOMPLEX

Issuing a dynamic Explain command

Accessing the Index Component reports

(Required for SQL Performance)

The display of the Index Component reports confirms that the Index Component of SQL Performance has been installed correctly.

See Accessing-the-Index-Component-reports.