Disable sql auto-tune in IRIS 2022.1

Question

Question

David Satorres · May 31, 2023

Hello,

Do you know if there is any way to disable the automatic tuning IRIS is doing every time a class is altered? It just takes too long in our case and is holding the system, so I'd like to tune the tables when I decide it (again).

I've seen in the documentation that for 2023 version there is an option present in the backend. But not for 2022, so I assume a flag is needed somewhere.

Many thanks!

Product version: IRIS 2022.1

$ZV: IRIS for Windows (x86-64) 2022.1.2 (Build 574U) Fri Jan 13 2023 15:00:26 EST

Discussion (3)2

Log in or sign up to continue

Dean White · May 31, 2023

go into the terminal and the namespace you want to disable, then type Set ^%SYS("sql","sys","autotune") = 0

3 0

score 0 · Answer 1 · 2023-05-31T10:23:48-04:00

SQL adaptive mode s not avail. on 2022.1.2 but only on 2023.1 (right)

%SYS>s Status=##Class(Config.SQL).Get(.Properties)
%SYS>zw Properties
Properties("ANSIPrecedence")=1
Properties("AdaptiveMode")=1
...
Properties("TimePrecision")=0

score 0 · Answer 2 · 2023-05-31T12:46:03-04:00

I've always wanted my Zen tablePane (T-Pain, as we call them for short) to be able to use autotune. So glad this is finally possible in 2022.1. Brings me back to the golden days in the late '00s where we did lots of things that seemed really cool at the time and feel kind of silly now.