A default query band can be defined in a profile using the CREATE PROFILE statement. The profile query band can be used for tracking and controlling system usage, similar to the SET QUERY_BAND statement. The profile query band is automatically set for the session at logon time.
To assign the profile to a user, specify the profile name in the CREATE USER or MODIFY USER statement for the user.
The SET QUERY_BAND statement sets, updates, and removes the session and transaction query bands for the session. This statement does not affect the profile query band. The only way the profile query band changes for an existing session is if the profile for the session changes.
Use the MODIFY PROFILE statement to modify the profile query band. All profile query band changes to active sessions take effect at the beginning of the next request.
The profile query band is not saved in DBC.SessionTbl, so after a restart the session is initialized with the profile query band based on the current profile setting.
For information about the CREATE PROFILE and MODIFY PROFILE statements, see SQL Data Definition Language.