Netezza

Reading Time: 2 minutes

NPS AMPP Architecture & Various Netezza 7.2 appliance models

  • Netezza High Availability Architecture (Clustering, Mirroring, failover)
  • Installing the Netezza system and client software
  • Installing Netezza Emulator for day-to-day practice
  • Nz Admin: GUI Admin Tool (Installation & Set-up)

Netezza Command Line Interface (CLI)

  • Manage NPS with CLI commands
  • Manage User access to Netezza Databases
  • Monitoring Netezza and Linux logs
  • Netezza Events (Set-up & Monitoring)

Databases & Tables

  • Data Distribution (Hash, Random), Cluster Base Tables, Table Skew
  • Generate Statistics, Zone Maps, Materialized Views, Groom Table
  • Backup & Restore (Host Level, Database Level, Table Level)
  • Database Refreshes & Migrations

Netezza Appliance migration (For Example: 6.x to 7.x migration)

  • Data Loading/Unloading using External Tables, NZLOAD, NZ_MIGRATE
  • Data Loading/Unloading using GUI Tools
  • Optimizer and query plans
  • Query history collection & Reporting

Netezza Replication/DR Architecture

  • Netezza performance improvement techniques
  • Common DBA activities such as SPU replacements, etc
  • ODBC/JDBC/OLEDB Client Connectivity
  • Working with IBM Netezza Support to resolve issues
IBM Netezza