Starting and stopping profiles

Start of changeYou must enable and start profiles before Db2® can use the information in the profile tables. When you apply changes to an existing started profile, you must stop the profile and start it again before the changes are applied.End of change

Before you begin

Before you can start profiles the following prerequisites must be met:
  • A set of profiles exist on the Db2 subsystem.
  • The SYSIBM.DSN_PROFILE_TABLE and SYSIBM.DSN_PROFILE_ATTRIBUTES contain rows of data that define valid profiles and the action that Db2 takes when a context meets the definition of a profile.

About this task

A profile is a set of criteria that identifies a particular context on a Db2 subsystem. Examples include threads, connections, or SQL statements that have particular attributes.
Important: Start of changeIf the value of the PROFILE_AUTOSTART subsystem parameter is set to YES, the START PROFILE command is issued automatically as part of Db2 start processing.End of change

Procedure

To start or stop profiles, use one of the following approaches:

  • Issue a START PROFILE command. Db2 activates the functions specified in the profile tables for every valid row of the SYSIBM.DSN_PROFILE_TABLE table that contains PROFILE_ENABLED='Y'. Profiles in rows that contain PROFILE_ENABLED='N' are not started.
  • Issue a STOP PROFILE command. Db2 disables all profile functions.
Start of change

What to do next

If you modify existing started profiles, you must stop and start profiles again to apply the changes. For profiles that affect access path selection, you must invalidate the statements in the dynamic statement cache before changes to profile attribute values are applied for those statements.End of change