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.


anoop

-----Original Message-----
From: Sandhya Sundaresan [mailto:sandhya.sundare...@esgyn.com] 
Sent: Tuesday, August 8, 2017 10:39 PM
To: d...@trafodion.incubator.apache.org; user@trafodion.incubator.apache.org
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. 

Sandhya

-----Original Message-----
From: Liu, Ming (Ming) [mailto:ming....@esgyn.cn] 
Sent: Tuesday, August 8, 2017 10:36 PM
To: d...@trafodion.incubator.apache.org; user@trafodion.incubator.apache.org
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?

Thanks,
Ming

Reply via email to