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