About Defining Name-Value Pairs for Profile Query Bands
To assign values to a query band in a profile, submit a CREATE/MODIFY PROFILE request. The profile query band is automatically set for the session at logon. You can submit a MODIFY PROFILE QUERY_BAND = NULL request at any time to remove the query band from the profile. For the syntax and more extensive examples, see SQL Data Definition Language.
The profile has a [NOT] DEFAULT option to specify if the session and transaction query band can contain the same names as the profile query band. The DEFAULT option specifies that users can overwrite the values specified in the profile query band with the SET QUERY_BAND statement for the session or transaction. If the DEFAULT clause is omitted, the profile query band is set to NOT DEFAULT, and users cannot change the profile query band with the SET QUERY_BAND statement for the session or transaction.
If the transaction, session, and profile query bands have the same name but with different values, the name/value pair used for workload management classification is the first one found in a query band searched in the following order:
Example : Creating a Query Band in a Profile
CREATE PROFILE salesprofile AS
SPOOL = 2e6*(HASHAMP()+1),
QUERY_BAND = 'GROUP=sales;AREA=retail;';