Creating profiles
You can create profiles to define filtering scopes for processes within Db2®. The filtering for each profile is controlled by the column values in the DSN_PROFILE_TABLE. You can also specify actions for Db2 to take when a process, such as a SQL statement, thread, or connection meets the criteria of the profile. The actions are specified by the column values in the DSN_PROFILE_ATTRIBUTES table.
Before you begin
About this task
Procedure
To create a profile:
- Insert rows into SYSIBM.DSN_PROFILE_TABLE with appropriate set of values for the type of profile that you want to create.
- Insert rows into the SYSIBM.DSN_PROFILE_ATTRIBUTES table to indicate the action that Db2 takes when the criteria that are specified in the profile table are met. Db2 uses the PROFILEID columns to associate rows in the SYSIBM.DSN_PROFILE_TABLE and SYSIBM.DSN_PROFILE_ATTRIBUTES profile tables.