Overview

This course takes the learner through the purpose and value of IBM Netezza Performance Server to knowing how to use the database system. It covers at a high level the NPS architecture and then dives into how to use NPS. The learner will be able to describe the data distribution model used in Netezza systems and be able to create and manage databases and tables. The learner will also be able to perform load and unload operations as well as understand how the query plans and performance tuning operations are done. Finally, the learner will be able to perform backup and restore operations, monitoring, and troubleshooting.

Audience

Database Administrators

Prerequisites

None

Objective

• Overview of IBM Netezza Performance Server 
• Describe the Netezza Performance Server architecture 
• Describe data distribution and create distribution keys in Netezza systems 
• Manage Netezza Performance Server database user access 
• Load and unload data from Netezza Performance Server database tables 
• Describe query plans and performance tuning methods for Netezza Performance Server 
• Backup and restore operations on Netezza Performance Server 
• Monitoring and troubleshooting Netezza Performance Server

Course Outline

Overview of IBM Netezza Performance Server 
• Describe the Netezza Performance Server 
• List and describe the different deployment factors for Netezza Performance Server 
• Explain the new features of the Netezza Performance Server 

Describe the Netezza Performance Server architecture 
• Describe the infrastructure and the components 
• Describe the database architecture 
• List and describe the storage options for Cloud Pak for Data System with NPS 

Describe data distribution and create distribution keys in Netezza systems 
• Use nzsql to create and manage database and tables 
• Create and manage databases 
• Create and manage tables 
• Describe data types and the best practices for choosing the right data type 
• Describe table constraints and how they are used 

Manage Netezza Performance Server database user access 
• Create and manage users 
• Create and manage groups 
• Describe and manage roles 
• Compare and contrast administrator and object privileges 
• Grant and revoke privileges 

Load and unload data from Netezza Performance Server database tables 
• Describe the data movement process, options, and support file types and formats 
• Describe the data encoding options and use nzconvert 
• Create and load external tables and remote client systems 
• Use nzload for high performance bulk load 
• Describe the use cases of SQL and nzload, including common errors and output 
• Load and unload of fixed format files 

Describe query plans and performance tuning methods for Netezza Performance Server 
• Active monitoring of queries to isolate the high run-time and high queue-time queries 
• Optimizing query performance through aligning the distribution key, zone map, system statistics, and groom maintenance job 
• System tuning guidelines 
• Workflow management best practices 

Backup and restore operations on Netezza Performance Server 
• Full backup & incremental backup  and restore approach for recovery 
• DR and recovery plan alignment to RPO/RTO (with or without separate DR system) 
• Backup/Restore sequencing to handle dependency and handling idle or stuck process 

Monitoring and troubleshooting Netezza Performance Server 
• Explain the different web console metrics 
• Describe the auto alerts and PMR generation 
• Describe specific action plans for different categories 
• Create log collections 
• Use nz_* commands for maintenance and performance tuning