You can use the nzstats command to display the group and statistics tables. You must be the user admin or have Manage System privileges to view IBM® Netezza® statistics. You must also be the user admin to view the Database, Table, and the Query tables.

Netezza appliances uses the up-to-date stat information to plan and execute the queries. The statics are very much important in performance of the query.

System Statistics using Netezza nzstats Command

You can use the nzstats command to display the statistics of a specific group or table, operational statistics about system capacity, system faults, and system performance or how your system is running.

To display the System Group table, enter: nzstats show -type system

The information in the output is obtained from the /nz/data/config/callHome.txt file. If that file is not customized for your IBM® Netezza® system, the command output might contain general placeholder text.

You can use the nzstats command to display the group and table types. You can also use the command to display specific fields within a group or table.

• To list the tables, enter:

nzstats listTypes

• To display specific fields of a table, enter:

nzstats listFields -type dataslice

NzAdmin tool can also be used to display statistics. You can check the table statistics by using Netezza admin tool.

Meet Ananth Tirumanur. Hi there 👋

I work on projects in data science, big data, data engineering, data modeling, software engineering, and system design.

• 👨‍💻 All of my projects are available at https://github.com/akrish1982
• 💬 Ask me about Data engineering, SQL, Databases, Data pipelines, Data infrastructure
• 📄 My work history: https://www.linkedin.com/in/ananthtirumanur/
• ⚡ Fun fact: Marathoner & Casual Birding enthusiast

Connect with me:

• Twitter: @akrish82
• LinkedIn: https://linkedin.com/in/ananthtirumanur/

My Resources:

• LinkedIn Newsletter: Data Engineering with AWS
• Udemy Course: AWS Certified Data Engineer Associate Practice Test
• Python Crash Course: Python Crash Course on Gumroad

Languages and Tools:

AWS, Bash, Docker, Elasticsearch, Git, Grafana, Hadoop, Hive, EMR, Glue, Athena, Lambda, Step Functions, Airflow/MWAA, DynamoDB, Kafka, Kubernetes, Linux, MariaDB, MySQL, Pandas, PostgreSQL, Python, Redis, Scala, SQLite