Administration interfaces

Deployment options: Netezza Performance Server for Cloud Pak for Data System Netezza Performance Server for Cloud Pak for Data

Learn about the administration interfaces, such as the command-line interface, the SQL commands, and the web console.

Netezza Performance Server offers a couple of options that you can use to perform system and database management tasks:

The web console

See Web console.

The command-line interface

With the command-line interface, you have access to the following type of commands.

Netezza Performance Server commands

They are installed in the /nz/kit/bin directory on the Netezza Performance Server host. For many of the commands, you must be able to log on to the Netezza Performance Server system to access and run those commands. In most cases, users log in as the default nz user account, but you can create other Linux® user accounts on your system. Some commands require you to specify a database user account, password, and database to ensure that you have permissions to do the task.

Netezza Performance Server for Cloud Pak for Data

You must install the nz remote command line to remotely run commands in a secure way through TLS/SSL.

See Remote command-line nz.

The SQL commands

They support administration tasks and queries within an SQL database session. You can run the SQL commands from the Netezza Performance Server nzsql command interpreter or through SQL APIs such as ODBC, JDBC, and the OLE DB Provider. You must have a database user account to run the SQL commands with appropriate permissions for the queries and tasks that you perform.

Netezza Performance Server for Cloud Pak for Data

You must install the nz remote command line to remotely run Netezza Performance Server commands in a secure way through TLS/SSL.

See Remote command-line nz.

The client kits package

It is a subset of the CLI commands that you can run from Windows and UNIX client systems. The client commands might also require you to specify a database user account, password, and database to ensure that you have database administrative and object permissions.

Netezza Performance Server for Cloud Pak for Data

You must install the nz remote command line to remotely run Netezza Performance Server commands in a secure way through TLS/SSL.

See Remote command-line nz.

The commands are installed and available on Netezza Performance Server, but it is more common for users to install client applications on client workstations. Netezza Performance Server supports various Windows and UNIX client operating systems.

Administration interfaces describes how to get started using the administration interfaces.

The client interfaces provide you with different ways to do similar tasks. You can use any combination of the client interfaces, depending on the task or your workstation environment, or interface preferences.

In general, the CLI commands are used most often for the various administration tasks. Many of the tasks can also be performed by using SQL commands or the interactive interfaces.