BMC Database Administration for Db2 customization tasks

After you install and configure the BMC Database Administration for Db2solution, you might need to perform several additional customization tasks to complete and verify the installation. You perform these tasks outside the Installation System dialog panels.

This solution includes the following products or components:

BMC AMI Change Manager for Db2
BMC AMI Catalog Manager for Db2
BMC AMI Copy for Db2
LOADPLUS for DB2
BMC AMI Recover for Db2 (partial functionality)
SNAPSHOT UPGRADE FEATURE for Db2(SUF, also known as XBM)
UNLOAD PLUS for DB2

Perform the following customization tasks for theBMC Database Administration for Db2 solution, in the order listed.

Summary of BMC Database Administration for Db2customization tasks

Customization task	Description and link
Verifying authorization	Verify that your BMC Authorization passwords are saved and copied to the correct library. See Authorization verification.
Setting the MEMLIMIT system parameter	See Setting the MEMLIMIT system parameter.
Controlling access and setting user authorizations	Use the following information to set the required authorizations for the products in this solution: Authorization verification mechanisms for the Backup and Recovery products and Utility products BMC AMI Copy for Db2 user authorizations Setting LOADPLUS authorizations Granting user authorizations for EXTENDED BUFFER MANAGER Setting UNLOAD PLUS authorizations BMC AMI Recover for Db2 user authorizations Restricting access to the worklist parallelism feature
(Optional) Enabling interaction between products	If you did not install this solution at the same time as the Administrative products, you might need to complete the following tasks: See Enabling interaction between ALTER or Change Manager and BMC utilities (including Backup and Recovery products) See Enabling interaction between Catalog Manager and BMC utilities (including Backup and Recovery products)
Completing tasks specific to Catalog Manager, ALTER, and Change Manager	See the Specific CATALOG MANAGER, ALTER, and CHANGE MANAGER customization tasks table.
Completing tasks specific to Change Manager	See the Specific CATALOG MANAGER tasks table.
Completing tasks specific to LOADPLUS	See the LOADPLUS specific tasks table.
Completing tasks specific to XBM	See the XBM and SUF specific tasks table.
Competing tasks specific to Cross-System Image Manager	See the Cross-System Image Manager (XIM) specific tasks table.
Restricting access to worklist parallelism	The solution enables you to use the worklist parallelism feature to run portions of a CHANGE MANAGER worklist concurrently. However, you can control access to these functions for a user or group of users. See Restricting access to the worklist parallelism feature.
Verifying product installation	See the Customization tasks for verifying installation table.

The following tables list additional customization tasks that apply to specific products or components within the solution.

SpecificCatalog Manager,ALTER, andChange Managercustomization tasks

Customization task	Description and link
(Optional) Defining catalog indirection	Catalog indirection is an optional method of implementing and maintaining Catalog Manager, ALTER, and Change Manager. See Using catalog indirection with ALTER, Catalog Manager, and Change Manager.
Working with CLISTs	Ensure that the correct version of CLIST is installed and that implicit execution of CLISTs is enabled. See Working with CLISTs.
(Optional) Creating indexes to improve performance	To improve performance, BMC recommends that you create indexes on the Db2 catalog tables and on copies of the catalog tables (if you are using catalog indirection). See Creating indexes on the Db2 catalog tables to improve performance.
Sharing components	The ALTER, Catalog Manager, Change Manager, and DASD MANAGER PLUS products share several components. You must bind each product to the new level of the shared components if either of the following conditions exists: You install the products at different times You are applying maintenance, and some of the products share the same APF-authorized load library. See Shared components.
(Optional) Customizing the BMCDB2PR panel	The BMCDB2PR panel is part of the ISPF interface that the Installation System generates. You might need to add additional products to the selection list or modify the catalog access field after you install and customize ALTER, Catalog Manager, Change Manager, or DASD MANAGER PLUS. See BMCDB2PR panel.
(Optional) Customizing the control table	By modifying the control table, you can: Add a product Specify the location of libraries Enable access to data sharing members Specify different libraries for SSIDs Specify shared installation options See Control table.
(Optional) Setting up fast path navigation	Fast Path Navigation enables you to switch from one product to another without leaving the current product. The Installation System provides Fast Path Navigation for the ALTER, Catalog Manager, Change Manager, and DASD MANAGER PLUS products. See Fast Path Navigation.
(Optional) Changing user profile values	You can change the values in the installation options module or in the product options file (POF) for a specific product by using the product’s user options. See Modifying user profile values.
(Optional) Enabling the use of DDF	Catalog Manager and Change Managercan access remote Db2 subsystems by using the DB2 Distributed Data Facility (DDF). Important Perform this task only if you did not enable the use of DDF when you installed the products. See Enabling the use of DDF.

Specific Catalog Managertasks

Customization task	Description and link
(Optional) Accessing catalog information	For an overview of the Catalog Manageraccess guidelines, see Access to catalog information.
(Optional) Prohibiting access to Catalog Managerfunctions	Set options for editing data, controlling data display, and processing SQL on the Edit DB2 Table Options panel. See Prohibiting access to Catalog Manager functions.
(Optional) Specifying an entry panel	You can optionally cause Catalog Managerto display an entry panel other than the Primary Menu panel by adding an entry panel command to the BMCDB2 CLIST. See Specifying an entry panel.
(Optional) Specifying locking options for editing data	To set the editor locking options for all users, you must enable the locking options command. See Specifying locking options for editing data.
(Optional) Setting the session profile	The Catalog Managersession profile enables you to customize specific product displays and operations for specific users or groups of users. See Setting the session profile.
(Optional) Editing the CONNECT command servers	You can edit and change the servers that are listed for the CONNECT command See Editing the CONNECT command servers.
(Optional) Adding ACTEMAIN and ACTDCL to the ISPF command table	System security can use a TSO command-limiting function to restrict an individual user or an entire site. If command limiting is active, you must add ACTEMAIN and ACTDCL to the list of commands that are allowed for CATALOG MANAGER. See Adding ACTEMAIN and ACTDCL to the ISPF command table.
(Optional) Enabling the use of BMC AMI SQL Explorer for Db2 within Catalog Manager	Within Catalog Manager, you can use commands to invoke the BMC AMI SQL Explorer for Db2production. See Enabling the use of BMC AMI SQL Explorer for Db2 within Catalog Manager.

LOADPLUS specific tasks

Customization task

Description and link

Customizing products that prevent x37 abends in LOADPLUS

Products that prevent x37 abends must be customized to ensure that they work properly with EXCP processing in LOADPLUS.

See Customizing products that prevent x37 abends in LOADPLUS

Increasing the size of Db2 active logs for LOADPLUS

See Increasing the size of Db2 active logs for LOADPLUS

XBM specific tasks

Customization task	Description and link
Customizing XBMsubsystems	See Customizing XBM subsystems.
Customizing XBMcomponents	See Customizing XBM components.

Cross-System Image Manager (XIM) specific tasks

Customization task

Description and link

Customizing Cross-System Image Manager (XIM)

The customization process constructs the XIM started task procedure and the XIM initiator procedure in the HLQ.JCL data set. Customizing XIM involves copying these procedures into the appropriate libraries.

See Customizing Cross-System Image Manager (XIM).

Executing XIM

The Database Administration solution uses the XIM technology to manage units of work (UOWs).

See Execution of XIM.

Customization tasks for verifying installation

Customization task

Description and link

Verifying the installation of the Administrative products

Perform this task to verify thatALTER, Catalog Manager, Change Manager, or DASD MANAGER PLUS have been installed correctly.

See Verifying the Administrative products installation.

Verifying Backup and Recovery product and Utility product installation

The Installation System generates an installation verification procedure (IVP) job for each installed Backup and Recovery or Utility product. To help ensure that a product installed properly, BMC strongly recommends that you run the corresponding IVP job.

See Verifying Backup and Recovery product and Utility product installation.

Related topic

Overview of customization tasks

BMC Database Administration for Db2 customization tasks

Comments