Question and Answer What the utilities available in nz/bin? Driver: libnzodbc.so , Utilities : nzconvert, nzds, nzevent, nzhw, nzload, nzodbcsql, nzpassword, nzreclaim, nzrev, nzsession, nzsql, nzstate, nzstats, nzsystem Where is the Configuration file available? Config file odbc.ini is available in nz/lib and it contains the Database Source properties and Connection parameters. What is NZSQL utility? This utility can be run from any machine on which it is installed i.e. it does not have be from netezza box itself. This utility can be used to run any sql statement like select or insert statement on the netezza database. In the below usage you see data extracted from the table into a output file and in the second mzsql command the data is also gzipped. nzsql -host <netezz_db_servername> -d <database> -u <username> -pw <password> -c -c "select * from tablename" -o /root/home/outputfilename.txt; What is NZLOAD utility? This utility can be us
NZSYSTEM nzsystem is a command line tool used by the DBA for various netezza operation. Some of the uses of nzsystem is mentioned below. It can be used to take the system offline ( nzsystem offline -u user -password password -host nzhost ) Pause the system (Its important when we do some registry changes like setting gatekeeper) nzsystem pause -u user -password password -host nzhost To display system registry settings where we can find GRA/GK settings also nzsystem showRegistry -u user -password password -host nzhost We also can configure the system settings using nzsystem. please follow the system admin guide.