Manage user content on the Netezza appliance

Unlike other database solutions, the IBM® Netezza® appliance does not require 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.

This section describes some basic concepts of Netezza databases, and some management and maintenance tasks that can help to ensure the best performance for user queries.

You can manage Netezza databases and their objects by using SQL commands that you run through the nzsql command and by using the IBM Netezza Performance Portal, NzAdmin tool, and data connectivity applications like ODBC, JDBC, and OLE DB. This section focuses on running SQL commands (shown in uppercase, such as CREATE DATABASE) from the nzsql command interface to perform tasks.