To disable aqr for a particular error(for example, error 8551), do:
  set session default aqr_entries '- 8551';

To add an error number, do:
  set session default aqr_entries '+ 8551';

Other aqr parameters can also be added.
For ex,
  set session default aqr_entries '+ 8551, 73, 2, 120';
Will do aqr for 8551/73(primary error 8551, secondary error 73), 
will retry 2 times, with delay of 120 secs between each retry.

To see all current aqr errors, do:
  get all aqr entries;

These set statements apply to that session only.
They cannot be added to defaults table.


-----Original Message-----
From: Sandhya Sundaresan [] 
Sent: Tuesday, August 8, 2017 10:39 PM
Subject: RE: how to setup/enable/disable AQR

Hi Ming,

  Yes use the Cqd  AUTO_QUERY_RETRY and set it  to 'OFF'.
If you want to disable it completely set it in the defaults table. 


-----Original Message-----
From: Liu, Ming (Ming) [] 
Sent: Tuesday, August 8, 2017 10:36 PM
Subject: how to setup/enable/disable AQR

Hi, all,

I want to disable AQR in Trafodion , is this possible? Or how should I disable 
AQR for specific SQL error?


Reply via email to