DSG DSNZPARM Performance and Optimization Parameters Workspace

The DSG DSNZPARM Performance and Optimization Parameters workspace for data sharing groups (DSG) shows information about the installation parameters for performance and optimization invoked by SQL CALL statements.

This workspace is comprised of the following views:

DSNZPARM Module Information (table view)

Shows the name and the assembly date of the current, initial, and previous DSNZPARM module.

DSNTIP8 - Performance and Optimization 1 (table view)

Shows the Db2 field names, ZPARM names, and the values set for each parameter. These entries set the application programming default values pertaining to performance and optimization.

DSNTIP81 - Performance and Optimization 2 (table view)

Shows the Db2 field names, ZPARM names, and the values set for each parameter. These entries set the application programming default values pertaining to performance and optimization.

DSNTIP82 - Query Accelerator Ref (table view)

Shows the Db2 field names, ZPARM names, and the values set for each parameter. These entries show the performance and optimization parameters for query accelerators.

You can use the HTML navigation feature to navigate from one workspace to another, while passing context information to the next workspace. The workspaces that belong to the same functional unit are linked using HTML navigation. Tivoli Enterprise Portal workspaces are grouped into the following units: Thread Summary workspaces, Thread Detail workspaces, and Statistics workspaces.

Based on the information that this workspace provides, you can recommend changes, set up situations, and verify that your recommended changes improve system performance.