RE: how to setup/enable/disable AQR
thanks Anoop and Sandhya, this really helps. Best Regards, Ming -Original Message- From: Anoop Sharma [mailto:anoop.sha...@esgyn.com] Sent: Wednesday, August 09, 2017 10:08 PM To: user@trafodion.incubator.apache.org; d...@trafodion.incubator.apache.org Subject: RE: how to setup/enable/disable AQR 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
RE: how to setup/enable/disable AQR
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
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
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
