Skip to content

How to disable Query history in Netezza?

TO disable query history in Netezza follow below steps:

1) Create a new history configuration which will not collect any data

SYSTEM(ADMIN)=> CREATE HISTORY CONFIGURATION hist_disabled HISTTYPE none;
CREATE HISTORY CONFIGURATION

Incase you already have a configuration with this name, you cna drop that by running below command.

SYSTEM(ADMIN)=> DROP HISTORY CONFIGURATION ALL_HIST;
ERROR: Current history configuration ‘ALL_HIST’ cannot be dropped
2) Run below query and you will see this new configuration but in disabled state

SYSTEM(ADMIN)=> show history configuration all;
3) Now run below command to set hist_disabled as a new configuration that system will use.

SYSTEM(ADMIN)=> set history configuration hist_disabled;
SET HISTORY CONFIGURATION
4) Now restart NPS for the changes to take effect.
5) OPTIONAL – You can drop the queryhistory database if needed.

How to check active viewpoint host in cluster environment?

You can have your viewpoint configured in a standalone environment or in a cluster environment.

If you have a cluster environment then you need to be aware of the active host before you plan to restart any services.
So, to check active viewpoint host in cluster environment you have to run below UNIX command (/etc/opt/teradata/viewpoint/distributed.cluster.properties) on any of the viewpoint nodes:

# cat /etc/opt/teradata/viewpoint/distributed.cluster.properties
#Mon, 07 Sep 2015 11:11:44 -0500
#
# Distributed viewpoint cluster properties.
#
active.database.host=10.4.10.11
standby.database.host=10.4.10.12
Her in the output you will see the active and standby host IP.