All Forums Database
Kishore_1 208 posts Joined 03/10
12 May 2014
Querybanding and Changing Workload

I have a scheduled job(a set of CPU intensive statements) which should run under a high priority workload during off business hours and should run under a low prioirity workload when the sytem is busy during business hours.
Can I use query banding to change the workload of  job ?Where do i need to make the changes for the system to recognise and promote or demote the session to the corresponding workload depending on the time of day?We are using Viewpoint.Do you need to configure the information in viewpoint portlet?

dnoeth 4628 posts Joined 11/04
13 May 2014

Of course you can assign a workload based on QueryBand or whatever you want, you just have to check where/if it fits into your current WL definitions/state matrix.
This has to be done using the Workload Designer portlet.
 
 

Dieter

You must sign in to leave a comment.