queries used to check SQL cluster view status

check about sql cluster
-------------------------------
select serverproperty('ComputerNamePhysicalNetBIOS');

SELECT * FROM fn_virtualservernodes();

SELECT * FROM sys.dm_os_cluster_nodes ;

script to check the DG sync status from primary Database

set time on
set echo off
set verify off
set feedback off
set pagesize 999 lines 200
col dest_name for a40
col destination for a40
col applied_seq# for 999999999
col archived_seq# for 999999999
select dest_name,status,destination,archived_seq#,applied_seq#
from v$archive_dest_status
where status='VALID';

steps to change the oracle DB SAp user password.

Please use the below SYNTAX.

brconnect -c -p initTEST.sap -l E -f chpass -o SYSTEM -password <PASSWORD>

steps to do table level re-org in SAP oracle database?

1.check the table size before re-org
2.here is the syntax:
brspace -u / -c force -f  tbreorg -m online -a reorg -t <Table_name> -degree 4 -initial 2
3.check the table size after re-org it will be reduced.

Steps to collect stats on table in SAP oracle database

brconnect -u / -c -f stats -t <table_name> -f collect

How to enable Query history on Netezza systems

Below are the sample steps that you can follow up to create and enable the history database:

1) Add users and grant appropriate access to them:

system(admin)=> create user owner with password 'ownerpw‘;
system(admin)=> grant create database to owner;
system(admin)=> create user audituser with password ‘audituserpw‘;
system(admin)=> grant list on audituser to owner;

2) Create history database using  “nzhistcreatedb” command:

$ nzhistcreatedb -d qhist -t q -u audituser -o owner -p 'ownerpw' -v 1

3) Maintenance of history database using  “nzhistcleanupdb” c- ommand:

$ nzhistcleanupdb -d qhist -u owner -pw 'ownerpw' –t ‘2011-10-31’

4) Create history configuration:

$ nzsql -c "CREATE HISTORY CONFIGURATION QUERY_HISTORY HISTTYPE QUERY NPS LOCALHOST DATABASE QHIST USER audituser PASSWORD 'audituserpw' COLLECT QUERY,PLAN,TABLE,COLUMN LOADINTERVAL 0 LOADMINTHRESHOLD 0 LOADMAXTHRESHOLD 1 STORAGELIMIT 10 LOADRETRY 1 ENABLEHIST TRUE ENABLESYSTEM TRUE VERSION 1;” VERSION 1;"

5) Enable history collection:

$ nzsql –c “SET HISTORY CONFIGURATION QUERY_HISTORY;”

6) Restart NPS using command:

$ nzstop;nzstart

How to do manual vac cum for Netezza database?

login as: root
root@server_name's password:
Last login: Thu Oct 30 17:35:29 2014 from xa65p020.domain.com
[root@server_name ~]# su - nz

     server_name NPS environment
==================================================

     HOME                 = /export/home/nz
     USER                 = nz

     NZ_USER              = admin
     NZ_DATABASE          = system


     /nz/data/config/system.cfg settings
==================================================

    startup.maxConnections    = 1000
    system.enableCTA2         = 1


[nz@server_name ~]$ date
Thu Oct 30 17:59:39 PDT 2014
[nz@server_name ~]$ nzrev
Release 7.0.2 (P-8) [Build 32960]
[nz@server_name ~]$ nzhw -issues
No entries found
[nz@server_name ~]$ nzds -issues
No entries found
[nz@server_name ~]$ nzds -regenstatus
No entries found
[nz@server_name ~]$ nzstats

Field Name           Value
-------------------- -------------------------------------------
Name                 server_name
Description          ddcnsdwodbcp01.domain.com
Contact            

Num SFIs             0
Num SPAs             2
Num SPUs             12
Num Data Slices      92
Num Hardware Issues  0
Num Dataslice Issues 0

[nz@server_name ~]$ nz_catalog_size > /tmp/nz_catalog_size_before.out
[nz@server_name ~]$ vi /tmp/nz_catalog_size_before.out
You have new mail in /var/spool/mail/nz
[nz@server_name ~]$ nzsession | grep -i active
1952508 sql      ADMIN        30-Oct-14, 18:02:16 PDT 10438 SYSTEM        active normal            127.0.0.1      10436 SELECT session_id, clien
[nz@server_name ~]$ /tmp/nz_catalog_size_before.out
[nz@server_name ~]$ ./nzverifysyscat -K /nz/kit -D /nz/data -P
-bash: ./nzverifysyscat: No such file or directory
[nz@server_name ~]$ cd /nz/kit/bin/adm/
[nz@server_name adm]$ ./nzverifysyscat -K /nz/kit -D /nz/data -P
        get database list
        verify syscat   IBM_NETEZZA_CUSTOMER_SERVICE
     
[nz@server_name adm]$ nzstate
System state is 'Online'.
[nz@server_name adm]$ nzstop
[nz@server_name adm]$ nzstate
System state is 'Stopped'.
[nz@server_name adm]$ nz_manual_vacuum

Confirmed that the database is stopped.

Creating a backup of /nz/data.  Please wait.

Backup completed.


#######################################################
#
# Database 1 of 12
#
# Vacuuming and Reindexing database 'IBM_NETEZZA_CUSTOMER_SERVICE'
#
#######################################################


NOTICE:  database system was shut down at 2014-10-30 18:09:47 PDT
NOTICE:  database system is in production state
DEBUG:  Session id is 16001

POSTGRES backend interactive interface
Revision: 7.1  Date: 2004/11/17 01:54:14

backend> DEBUG:  VACUUM: Opened all system relations
DEBUG:  VACUUM: vacuuming '_T_TYPE'
DEBUG:  Index _I_TYPE_OID: Pages 2; Tuples 37. CPU 0.00s/0.00u sec.
DEBUG:  Index _I_TYPE_TYPNAME: Pages 2; Tuples 37. CPU 0.00s/0.00u sec.
DEBUG:  VACUUM: vacuuming '_T_ATTRIBUTE'
DEBUG:  Index _I_ATTRIBUTE_RELID_ATTNAM: Pages 203; Tuples 10564: Deleted 0. CPU 0.00s/0.00u sec.
DEBUG:  Index _I_ATTRIBUTE_RELID_ATTNUM: Pages 17; Tuples 10564: Deleted 0. CPU 0.00s/0.00u sec.
DEBUG:  VACUUM: vacuuming '_T_CLASS'
DEBUG:  Index _I_CLASS_OID: Pages 2; Tuples 887: Deleted 0. CPU 0.00s/0.00u sec.
DEBUG:  Index _I_CLASS_RELNAME: Pages 19; Tuples 887: Deleted 0. CPU 0.00s/0.00u sec.
DEBUG:  VACUUM: vacuuming '_T_INHERITS'
DEBUG:  Index _I_INHERITS_RELID_SEQNO: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  VACUUM: vacuuming '_T_INDEX'
DEBUG:  Index _I_INDEX_INDRELID: Pages 2; Tuples 98. CPU 0.00s/0.00u sec.
DEBUG:  Index _I_INDEX_INDEXRELID: Pages 2; Tuples 98. CPU 0.00s/0.00u sec.
DEBUG:  VACUUM: vacuuming '_T_STATISTIC'
DEBUG:  Index _I_STATISTIC_RELID_ATT: Pages 2; Tuples 304: Deleted 52. CPU 0.00s/0.00u sec.
DEBUG:  VACUUM: vacuuming '_T_OPERATOR'
DEBUG:  Index _I_OPERATOR_OID: Pages 2; Tuples 664. CPU 0.00s/0.00u sec.
DEBUG:  Index _I_OPERATOR_OPRNAME_L_R_K: Pages 15; Tuples 664. CPU 0.00s/0.00u sec.
DEBUG:  VACUUM: vacuuming '_T_OPCLASS'
DEBUG:  Index _I_OPCLASS_OID: Pages 2; Tuples 32. CPU 0.00s/0.00u sec.
DEBUG:  Index _I_OPCLASS_DEFTYPE: Pages 2; Tuples 32. CPU 0.00s/0.00u sec.
DEBUG:  Index _I_OPCLASS_NAME: Pages 2; Tuples 32. CPU 0.00s/0.00u sec.
DEBUG:  VACUUM: vacuuming '_T_AM'
DEBUG:  Index _I_AM_OID: Pages 2; Tuples 4. CPU 0.00s/0.00u sec.
DEBUG:  Index _I_AM_NAME: Pages 2; Tuples 4. CPU 0.00s/0.00u sec.
DEBUG:  VACUUM: vacuuming '_T_AMOP'
DEBUG:  Index _I_AMOP_OPID: Pages 2; Tuples 186. CPU 0.00s/0.00u sec.
DEBUG:  Index _I_AMOP_STRATEGY: Pages 2; Tuples 186. CPU 0.00s/0.00u sec.
DEBUG:  VACUUM: vacuuming '_T_AMPROC'
DEBUG:  VACUUM: vacuuming '_T_LANGUAGE'
DEBUG:  Index _I_LANGUAGE_NAME: Pages 2; Tuples 5. CPU 0.00s/0.00u sec.
DEBUG:  Index _I_LANGUAGE_OID: Pages 2; Tuples 5. CPU 0.00s/0.00u sec.
DEBUG:  VACUUM: vacuuming '_T_LARGEOBJECT'
DEBUG:  Index _I_LARGEOBJECT_LOID_PN: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  VACUUM: vacuuming '_T_AGGREGATE'
DEBUG:  Index _I_AGGREGATE_NAME_NARG_TYPE: Pages 10; Tuples 193. CPU 0.00s/0.00u sec.
DEBUG:  Index _I_AGGREGATE_OID: Pages 2; Tuples 193. CPU 0.00s/0.00u sec.
DEBUG:  VACUUM: vacuuming '_T_IPL'
DEBUG:  VACUUM: vacuuming '_T_INHERITPROC'
DEBUG:  VACUUM: vacuuming '_T_REWRITE'
DEBUG:  Index _I_REWRITE_OID: Pages 2; Tuples 457. CPU 0.00s/0.00u sec.
DEBUG:  Index _I_REWRITE_RULENAME: Pages 11; Tuples 457. CPU 0.00s/0.00u sec.
DEBUG:  VACUUM: vacuuming '_T_LISTENER'
DEBUG:  Index _I_LISTENER_PID_RELNAME: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  VACUUM: vacuuming '_T_DESCRIPTION'
DEBUG:  Index _I_DESCRIPTION_OBJOID: Pages 4; Tuples 1444. CPU 0.00s/0.00u sec.
DEBUG:  VACUUM: vacuuming '_T_DIST_MAP'
DEBUG:  Index _I_DIST_MAP_SEQ: Pages 2; Tuples 15. CPU 0.00s/0.00u sec.
DEBUG:  Index _I_DIST_MAP_RELID: Pages 2; Tuples 15. CPU 0.00s/0.00u sec.
DEBUG:  VACUUM: vacuuming '_T_ORGANIZE_ON'
DEBUG:  VACUUM: vacuuming '_T_GROOM_HISTORY'
DEBUG:  VACUUM: vacuuming '_T_THIN'
DEBUG:  VACUUM: vacuuming '_T_ALTBASE'
DEBUG:  VACUUM: vacuuming '_T_ACTIONFRAG'
DEBUG:  Index _I_ACTIONFRAG_EVCLASS: Pages 2; Tuples 564. CPU 0.00s/0.00u sec.
DEBUG:  VACUUM: vacuuming '_T_SELCACHE'
DEBUG:  VACUUM: vacuuming '_T_EXTERNAL'
DEBUG:  VACUUM: vacuuming '_T_EXTOBJECT'
DEBUG:  VACUUM: vacuuming '_T_EXTZONES'
DEBUG:  VACUUM: vacuuming '_T_CONSTRAINT'
DEBUG:  VACUUM: vacuuming '_T_CONST_RELATTR'
DEBUG:  VACUUM: vacuuming '_T_CONST_REFATTR'
DEBUG:  VACUUM: vacuuming '_T_SYNONYM'
DEBUG:  VACUUM: vacuuming '_T_BACKUP_GROUP'
DEBUG:  VACUUM: vacuuming '_T_BACKUP_GROUP_MEMBER'
DEBUG:  VACUUM: vacuuming '_T_RESTORE_ATTRESTOID'
DEBUG:  VACUUM: vacuuming '_T_LIBRARY'
DEBUG:  Index _I_LIBRARY_NAME: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  VACUUM: vacuuming '_T_UDXATTRIBUTE'
DEBUG:  Index _I_UDXATTRIBUTE_RELID_ATTNAM: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  Index _I_UDXATTRIBUTE_RELID_ATTNUM: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  VACUUM: vacuuming '_T_SCSI_ERRORS'
DEBUG:  Index _I_SCSI_ERRORS_SCSI_ERRID: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  Index _I_SCSI_ERRORS_SCSI_HWID: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  VACUUM: vacuuming '_T_SPACOMP'
DEBUG:  VACUUM: vacuuming '_T_VT_HOSTTX'
DEBUG:  VACUUM: vacuuming '_T_MD_REGEN_ERRORS'
DEBUG:  Index _I_MD_REGEN_ERRORS_MD_ERRID: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  Index _I_MD_REGEN_ERRORS_MD_HWID: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  Index _I_MD_REGEN_ERRORS_MD_TBLID: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  VACUUM: vacuuming '_T_UDXENVIRONMENT'
DEBUG:  Index _I_UDXENVIRONMENT_RELID: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  Index _I_UDXENVIRONMENT_RELID_ATTNAM: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  Index _I_TOAST_5150: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  VACUUM: vacuuming '_T_ATTRDEF'
DEBUG:  Index _I_ATTRDEF_ADRELID: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  Index _I_TOAST_1215: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  VACUUM: vacuuming '_T_PROC'
DEBUG:  Index _I_PROC_OID: Pages 4; Tuples 1418. CPU 0.00s/0.00u sec.
DEBUG:  Index _I_PROC_PRONAME_NARG_TYPE: Pages 58; Tuples 1418. CPU 0.00s/0.00u sec.
DEBUG:  Index _I_TOAST_1255: Pages 1; Tuples 0. CPU 0.00s/0.00u sec.
DEBUG:  Analyzing...
DEBUG:  Analyzing...
DEBUG:  Analyzing...
DEBUG:  Analyzing...

backend> NOTICE:  shutting down
NOTICE:  database system is shut down

--------------------------------------------------------------------------------

NOTICE:  database system was shut down at 2014-10-30 18:09:50 PDT
NOTICE:  database system is in production state
DEBUG:  Session id is 16001

POSTGRES backend interactive interface
Revision: 7.1  Date: 2004/11/17 01:54:14

backend> NOTICE:  relation 1247 was reindexed
NOTICE:  relation 1249 was reindexed
NOTICE:  relation 1259 was reindexed
NOTICE:  relation 5107 was reindexed
NOTICE:  relation 5105 was reindexed
NOTICE:  relation 5115 was reindexed
NOTICE:  relation 5113 was reindexed
NOTICE:  relation 5112 was reindexed
NOTICE:  relation 5101 was reindexed
NOTICE:  relation 5102 was reindexed
NOTICE:  relation 5109 was reindexed
NOTICE:  relation 5110 was reindexed
NOTICE:  relation 5100 was reindexed
NOTICE:  relation 5114 was reindexed
NOTICE:  relation 5111 was reindexed
NOTICE:  relation 5104 was reindexed
NOTICE:  relation 5002 was reindexed
NOTICE:  relation 5030 was reindexed
NOTICE:  relation 5132 was reindexed
NOTICE:  relation 5146 was reindexed
NOTICE:  relation 5666 was reindexed
NOTICE:  relation 5727 was reindexed
NOTICE:  relation 5150 was reindexed
NOTICE:  relation 1215 was reindexed
NOTICE:  relation 1255 was reindexed

backend> NOTICE:  shutting down
NOTICE:  database system is shut down

Netezza upgrade from 702 to 7.0.2.14

1.get the below pulgins and place it under the dir

z@server_name tmp]$ cd /nz/kit/share/upgrade/plugins/nz/Plugin/
[nz@server_name Plugin]$ clear
[nz@server_name Plugin]$ ls -ltr

[root@server_name ~]# service drbd status
drbd driver loaded OK; device status:
version: 8.2.6 (api:88/proto:86-88)
GIT-hash: 3e69822d3bb4920a8c1bfdf7d647169eba7d2eb4 build by root@nps22094, 2010-11-18 14:52:01
m:res  cs         st                 ds                 p  mounted       fstype
0:r1   Connected  Primary/Secondary  UpToDate/UpToDate  C  /export/home  ext3
1:r0   Connected  Primary/Secondary  UpToDate/UpToDate  C  /nz           ext3
[root@server_name ~]# ssh ha2 service drbd status
drbd driver loaded OK; device status:
version: 8.2.6 (api:88/proto:86-88)
GIT-hash: 3e69822d3bb4920a8c1bfdf7d647169eba7d2eb4 build by root@nps22094, 2010-11-18 14:52:01
m:res  cs         st                 ds                 p  mounted  fstype
0:r1   Connected  Secondary/Primary  UpToDate/UpToDate  C
1:r0   Connected  Secondary/Primary  UpToDate/UpToDate  C
[root@server_name ~]# head -n 25 /etc/hosts

2.stop/start the NPS

w-r--r-- 1 nz   nz   13953 Dec 13 09:09 SetDefSchema.pm
-rw-r--r-- 1 root root 17345 Dec 13 09:09 CheckReplication.pm
[nz@server_name Plugin]$
[nz@server_name Plugin]$
[nz@server_name Plugin]$ nzrev
Release 7.0.2 (P-8) [Build 32960]
[nz@server_name Plugin]$ nzstate
System state is 'Stopped'.
[nz@server_name Plugin]$
[nz@server_name Plugin]$ nzstart
Updating '/nz/data.1.0/kit' ...

(startupsvr) Info: NZ-00022: --- program 'startupsvr' (28177) starting on host 'server_name' ... ---
[nz@server_name Plugin]$ clear
[nz@server_name Plugin]$


3.do the pre-upgrade check


[root@server_name upgrade]# wget https://delivery04.dhe.ibm.com/sdfdl/v2/sar/CM/IM/04vtr/0/Xa.2/Xb.jusyLTSp44S03sPozQAzX2GfBoWlywJNOUH2OSyo/Xc.CM/IM/04vtr/0/nz-nps-v7.0.2.14-P2.tar.gz/Xd./Xf.Lpr./Xg.7883631/Xi.habanero/XY.habanero/XZ.E95gizBav5h64nSQSB.0.2.14-P2.tar.gz
--2014-12-13 09:51:44--  https://delivery04.dhe.ibm.com/sdfdl/v2/sar/CM/IM/04vtr/0/Xa.2/Xb.jusyLTSp44S03sPozQAzX2GfBoWlyvt75UH2OSyo/Xc.CM/IM/04vtr/0/nz-nps-v7.0.2.14-P2.tar.gz/Xd./Xf.Lpr./Xg.7883631/Xi.habanero/XY.habanero/XZ.E95gizBav5h64nSQSBmTD1.14-P2.tar.gz
Resolving delivery04.dhe.ibm.com... 170.225.15.105
Connecting to delivery04.dhe.ibm.com|170.225.15.105|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 1332315118 (1.2G) [application/octet-stream]
Saving to: `nz-nps-v7.0.2.14-P2.tar.gz'

100%[===================================================================================================>] 1,332,315,118 7.4

2014-12-13 09:54:18 (8.34 MB/s) - `nz-nps-v7.0.2.14-P2.tar.gz' saved [1332315118/1332315118]

[root@server_name upgrade]# clear
[root@server_name upgrade]# ls -ltr
total 1371924
-rwxr-xr-x 1 nz   nz         2353 Apr 18  2012 check_hba.sh
-rw-r--r-- 1 nz   nz      2146836 Apr 23  2012 asu.tgz
-rwxr-xr-x 1 nz   nz          789 Sep 27  2012 check_CBT.sh
-rwxr-xr-x 1 nz   nz       244230 May  7  2013 disk_monitor.nps70
-rw-r--r-- 1 root root    2202835 May  7  2013 check_scripts.tgz
-rwxr-xr-x 1 nz   nz        39107 May 24  2013 upgrade_tools
-rwxr--r-- 1 nz   nz         9023 Sep 17  2013 SetDefSchema.pm
-rw-r--r-- 1 nz   nz         5719 Sep 17  2013 CheckReplication.pm
-rw-r--r-- 1 root root    2214752 Sep 30  2013 upgrade_tools_1.9.tgz
-rw-r--r-- 1 root root        556 Sep 30  2013 nzupgrade.ssh.lock
-rwxr-xr-x 1 root root      18367 Sep 30  2013 check_root.sh
drwxr-xr-x 3 nz   nz         4096 Sep 30  2013 log
-rw-r--r-- 1 root root        603 Sep 30  2013 badViews.sql
drwxr-xr-x 6 root root       4096 Oct  4  2013 FDT
-rw------- 1 nz   nz     64193106 Oct  4  2013 server_name.backup.10042013.tgz
drwxr-xr-x 3 root root       4096 Oct  4  2013 HPF
drwxr-xr-x 2 root root       4096 Oct  4  2013 bios
drwxr-xr-x 6 root root       4096 Oct  4  2013 service_tools
drwxr-xr-x 3 root root       4096 Oct  4  2013 hwtools
drwxr-xr-x 3 nz   nz         4096 Oct  4  2013 swtools
-rw-r--r-- 1 root root 1332315118 Nov  4 15:39 nz-nps-v7.0.2.14-P2.tar.gz
[root@server_name upgrade]# tar -zxvf nz-nps-v7.0.2.14-P2.tar.gz
npsos.7.0.2.14-P2.tar.gz
unpack
[root@server_name upgrade]# ./unpack
-------------------------------------------------------------------------------
IBM Netezza -- Netezza Platform Software 7.0.2.14-P2
(C) Copyright IBM Corp. 2002, 2014  All Rights Reserved.
-------------------------------------------------------------------------------

Validating package checksum ... ok

Where should the Netezza Platform Software be unpacked? [/nz]

 0%          25%         50%         75%          100%
 |||||||||||||||||||||||||||||||||||||||||||||||||||

You can check the system to prepare for an upgrade with:
    /nz/kit.7.0.2.14-P2/sbin/nzupgrade check

You can start the upgrade (which also checks the system) with (as root):
    /nz/kit.7.0.2.14-P2/sbin/nzupgrade upgrade

Unpacking complete.
[root@server_name upgrade]# /nz/kit.7.0.2.14-P2/sbin/nzupgrade check
-------------------------------------------------------------------------------
IBM Netezza -- Netezza Platform Software
(C) Copyright IBM Corp. 2002, 2014  All rights reserved.
-------------------------------------------------------------------------------

Logfile: /nz/var/log/upgrade.20141213.7.0.2.14-P2.check

Checking the system for validity...

Checking HPF health ... ok

---------------------------------------------------------------
IBM Netezza Model:  IBM PureData System for Analytics N1001-005
FDT version:        2.6.1
HPF version:        5.3
---------------------------------------------------------------

System checks succeeded.

You can upgrade your system with:
    /nz/kit.7.0.2.14-P2/sbin/nzupgrade  upgrade


Logfile: /nz/var/log/upgrade.20141213.7.0.2.14-P2.check.gz
[root@server_name upgrade]# clear
[root@server_name upgrade]# screen

SYSTEM(ADMIN)=> \q
[nz@server_name ~]$ nzsql
Welcome to nzsql, the IBM Netezza SQL interactive terminal.

Type:  \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

SYSTEM(ADMIN)=> show history configuration all;
 CONFIG_NAME | CONFIG_DBNAME | CONFIG_DBTYPE | CONFIG_TARGETTYPE | CONFIG_LEVEL | CONFIG_HOSTNAME | CONFIG_USER | CONFIG_PASSWORD | CONFIG_LOADINTERVAL | CONFIG_LOADMINTHRESHOLD | CONFIG_LOADMAXTHRESHOLD | CONFIG_DISKFULLTHRESHOLD | CONFIG_STORAGELIMIT | CONFIG_LOADRETRY | CONFIG_ENABLEHIST | CONFIG_ENABLESYSTEM | CONFIG_NEXT | CONFIG_CURRENT | CONFIG_VERSION | CONFIG_COLLECTFILTER | CONFIG_KEYSTORE_ID | CONFIG_KEY_ID | KEYSTORE_NAME | KEY_ALIAS | CONFIG_NAME_DELIMITED | CONFIG_DBNAME_DELIMITED | CONFIG_USER_DELIMITED
-------------+---------------+---------------+-------------------+--------------+-----------------+-------------+-----------------+---------------------+-------------------------+-------------------------+--------------------------+---------------------+------------------+-------------------+---------------------+-------------+----------------+----------------+----------------------+--------------------+---------------+---------------+-----------+-----------------------+-------------------------+-----------------------
(0 rows)

SYSTEM(ADMIN)=>

query to check the transaction that are currently roll back/executing on Netezza

use
nz_transactions

how to find netezza system state?

use
nzstate