User Profiles for System and SQL Performance administration

This section describes the User Profiles that are used to:

  • Limit the use of resources
  • Grant and restrict access to:
    • Data Collectors 
    • Products
    • Various product features
    • Db2 subsystems
  • Set default values for session characteristics and function keys

Important

Denying access to Db2 through the product does not prevent you from using Db2. It prevents only the product's ability to monitor Db2. Where the panels and text of this section refer to "access to Db2," this access is only for the purpose of monitoring Db2 using the System and SQL Performance products.

The User Profile is composed of a security record (contained in the SECURITY VSAM data set) and a user record (contained in the PROFILE VSAM data set).

  • The security record contains parameters that grant or deny access to various product functions and to Db2.
  • The user record contains the parameters for session characteristics and function keys.

A default User Profile called 9DEFAULT is shipped with the System and SQL Performance products. This User Profile is composed of a 9DEFAULT security record and a 9DEFAULT user record. Together these records contain the default values for all parameters in the User Profile.

Important

The User Profile is presented as a single entity. There is no obvious distinction between the security and user records.

As the system administrator, you create User Profiles for each user ID that is authorized to access the System and SQL Performance  products that are installed at your site. However, it is possible for users to access the products automatically before you create their User Profiles. 

This section contains the following topics:


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*