HOW TO INCREASE MAX STORAGE LIMIT FOR QUERY HISTORY CONFIGURATION?
NOTE: hist_disabled is the QHIST configuration which will not collect anything. And ALL_HIST is supposed to be the configuration that you want to change. please change the names as per your setup.
1) nzsql -c “SET HISTORY CONFIGURATION hist_disabled” 2) nzstop 3) nzstart
In below step we are increasing the limit to 10GB
4) nzsql – c “ALTER HISTORY CONFIGURATION ALL_HIST STORAGELIMIT=10000”
5) nzsql -c “SET HISTORY CONFIGURATION ALL_HIST”
6) nzstop
7) nzstart
8) Once system is back online run below command to make sure history configuration is changed to ALL_HIST
nzsql -c “SHOW HISTORY CONFIGURATION”