Deadlock issue found when 'SET QUERY_BAND' submitted

Problem :

SET QUERY_BAND cause deadlock issue, since it need to update sessiontbl.

Environment/Conditions/Configuration
All version

Solution

We can avoid to lock sessiontbl with volatile option.With this change, we can avoid this deadlock.

SET QUERY_BAND=xxxx FOR SESSION VOLATILE;

If it is difficult to apply this change, please consult with your CSR for system level setting.