Starting and stopping profiles
You 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.
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
Important:
If
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.
If
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.
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.

What to do next
