DSG DSNZPARM Data Set and Database Parameters Workspace

The DSG DSNZPARM Data Set Parameters workspace for data sharing groups (DSG) shows information about the data set and database-related installation parameters in the DSNZPARM module.

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.

DSNTIP7 - SQL Object Defaults 1 (table view)

Shows the Db2 field names, ZPARM names, and the values set for each parameter. These entries define default values for the system-required objects that DB2 creates automatically. DB2 uses these options for any indexes or table spaces that it implicitly creates. The remaining fields provide general default settings for creating table spaces.

DSNTIP71 - SQL Object Defaults 2 (table view)

Shows the Db2 field names, ZPARM names, and the values set for each parameter. These entries define default values for the system-required objects that DB2 creates automatically. DB2 uses these options for any indexes or table spaces that it implicitly creates. The remaining fields provide general default settings for creating table spaces.

DSNTIP9 - Workfile Database (table view)

Shows the Db2 field names, ZPARM names, and the values set for each parameter. These entries configure the 4 KB and 32 KB page size table spaces in the DB2 Workfile Database.

DSNTIPS - Auto Start DB/TS (table view)

Shows the Db2 field names, ZPARM names, and the values set for each parameter. These entries show the databases, table spaces, and index spaces to restart automatically when you start DB2.

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.