Netezza Performance Server for database administrators

Administration interfaces
Learn about the administration interfaces, such as the command-line interface, the SQL commands, and the web console.
Installing client software packages
Learn how to install the Netezza Performance Server CLI clients tool.
Upgrading Netezza Performance Server
Turning off the MBR settings on Intel disks
If you are on Netezza Performance Server 11.2.1.4 and lower, and the SPU key is enabled, turn off the MBR settings on the Intel disk before you upgrade.
Database backup and restore
Learn how to back up and restore data on Netezza Performance Server. The sections provide general information about the backup and restore methods, and also describe how to use the third-party storage solutions.
Migrating to Netezza Performance Server
Netezza Performance Server is compatible with the previous generation appliances. You can use the nz_migrate script to migrate the data from the IBM® PureData® System for Analytics appliances.
Managing user databases
You do not need a database administrator (DBA) to manage and control user databases. Instead, there are a few system administration tasks that relate to the creation and management of the user content that is stored on the system.
Managing the Netezza Performance Server system
This section describes how to manage the Netezza Performance Server system, log files, and where to find operational and error messages for troubleshooting activities.
Event rules
The event manager monitors the health, status, and activity of the Netezza Performance Server system operation and can act when a specific event occurs. Event monitoring is a proactive way to manage the system without continuous human observation.
Collecting data history
A Netezza Performance Server system can be configured to capture information about user activity such as queries, query plans, table access, column access, session creation, and failed authentication requests. This information is called history data. Database administrators can use history data to gain insight to usage patterns.
Managing workloads
The workload consists of user-initiated jobs such as SQL queries, administration tasks, backups, and data loads, and system-initiated jobs such as regenerations and rollbacks. Workload management (WLM) is the process of assessing a system's workload and allocating the resources used to process that workload.
Working with system statistics
The nzstats command displays operational statistics about system capacity, faults, and performance. Operational statistics provide you with a high-level overview of how your system is running in a context of recent system activity. Also, operational statistics provide details so that you can diagnose problems, understand performance characteristics, and interface to system management software.

Parent topic: Netezza Performance Server for IBM Netezza Appliance N4001