Other Uses for Query Bands
Other uses for query bands include:
Preventing development work from running on the production platform at critical times.
For example, queries with a query band of
‘Application=Test;’ can be prevented from running, based on a TASM filter rule.
Recording the parameterized values that the query uses for each execution of tactical
Java applications. These values are available in DBQL after the queries complete.
Choosing between dynamic plan execution or static query plan execution.
Setting the temperature of data being loaded into the system.
For More Information
For the syntax for setting a query band, see SQL Data Definition Language Syntax and Examples. For the available query band values, see SQL Data Definition Language Detailed Topics.