Configuring the Netezza Performance Server client

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

About this task

Follow these steps to set up the IBM® Spectrum Protect (formerly Tivoli® Storage Manager) configuration files, which make the Netezza Performance Server system a client of the Tivoli Storage Manager server.

There are two sets of configuration files, one set for the API client and one set for the B/A client. Follow these steps to configure the files for the API client. If you also installed the B/A client RPM, make sure that the changes that you make to the API client files are identical to the changes that you make for the BA client files which are in the /opt/tivoli/tsm/client/ba/bin directory. You can either repeat these steps for the B/A client files or copy the updated API client dsm.opt and dsm.sys files to the B/A bin directory.

Procedure

Make sure that you are logged in to the Netezza Performance Server system as root.
Change to the following directory:
```
 cd /opt/tivoli/tsm/client/api/bin
```
Copy the file dsm.opt.smp to dsm.opt. Save the copy in the current directory.
For example:
```
cp dsm.opt.smp dsm.opt
```
Edit the dsm.opt file by using any text editor.
In the dsm.opt file, proceed to the end of the file and add the following line, which is shown in bold, where server is the host name of the Tivoli Storage Manager server in your environment:
```
******************************************************************
* IBM Tivoli Storage Manager                                     *
*                                                                *
* Sample Client User Options file for UNIX (dsm.opt.smp)         *
******************************************************************

*  This file contains an option you can use to specify the TSM
*  server to contact if more than one is defined in your client
*  system options file (dsm.sys).  Copy dsm.opt.smp to dsm.opt.
*  If you enter a server name for the option below, remove the
*  leading asterisk (*).

******************************************************************
* SErvername       A server name defined in the dsm.sys file
  SErvername server
```
If you have multiple Tivoli Storage Manager servers in your environment, you can add a definition for each server. However, only one definition can be the active definition. Any additional definitions should be commented out by using the asterisk (*) character. The active dsm.opt entry determines which Tivoli Storage Manager server is used by the Tivoli Storage Manager connector for backup and restore operations. If there are multiple uncommented SERVERNAME entries in dsm.opt, the first uncommented entry is used.

If you plan to use Tivoli encryption for your backups, add the following settings to the server definition. For the TRACEFILE setting, specify a location on the Netezza Performance Server host or on a connected filesystem where you can store a trace file for more information about the backups. For details about the settings, see the Tivoli documentation.
```
TRACEFILE /nzscratch/user/trace.txt
TRACEFLAGS API API_DETAIL ENCRYPT
```
Save and close the dsm.opt file.
Copy the file dsm.sys.smp to dsm.sys. Save the copy in the current directory.
For example:
```
cp dsm.sys.smp dsm.sys
```
Edit the dsm.sys file by using any text editor.
In the dsm.sys file, proceed to the end of the file and add the settings, which are shown in bold, where server is the name of the Tivoli Storage Manager server in your environment, serverIP is the host name or IP address of the Tivoli Storage Manager server, and client_NPS is the node name for the Netezza Performance Server host client:
```
******************************************************************
* IBM Tivoli Storage Manager                                     *
*                                                                *
* Sample Client System Options file for UNIX (dsm.sys.smp)       *
******************************************************************

*  This file contains the minimum options required to get started
*  using TSM.  Copy dsm.sys.smp to dsm.sys.  In the dsm.sys file,
*  enter the appropriate values for each option listed below and
*  remove the leading asterisk (*) for each one.

*  If your client node communicates with multiple TSM servers, be
*  sure to add a stanza, beginning with the SERVERNAME option, for
*  each additional server.

******************************************************************
SErvername         server 
COMMMethod         TCPip
TCPPort            1500
TCPServeraddress   serverIp
NODENAME           client_NPS
```
For the NODENAME value, use the naming convention client_NPS, where client is the host name of the Netezza Performance Server host, to help uniquely identify the client node for the Netezza Performance Server host system.

If you plan to use Tivoli encryption for your backups, add the following settings to the server definition. For the ENCRYPTIONTYPE value, use the encryption value specific to your Tivoli configuration (AES128 is an example). For the include.encrypt setting, you can specify a setting such as /.../* to encrypt all of the TSM Performance Server backups, or you can specify a specific Performance Server backup object and backup type. For example, /FS1/MY_DB/FULL indicates that the TSM server should encrypt the full backups of the MY_DB database stored in the /FS1 location. For details about the settings, see the Tivoli documentation.
```
ENCRYPTKEY GENERATE
ENCRYPTIONTYPE AES128
include.encrypt /.../*
```
If you have multiple Tivoli Storage Manager servers in your environment, you can create another set of these definitions and append each set to the file. For example:
```
SErvername         server1 
COMMMethod         TCPip
TCPPort            1500
TCPServeraddress   server1Ip 
NODENAME           client_NPS

SErvername         server2 
COMMMethod         TCPip
TCPPort            1500
TCPServeraddress   server2Ip 
NODENAME           client_NPS
```
If you specify more than one Tivoli Storage Manager server definition in the dsm.sys file, you can create corresponding definitions in the dsm.opt file as described in step 4.
If you installed the Tivoli 5.4 client software on your hosts, you must also add the following options in the dsm.sys file.
```
ENCRYPTIONTYPE DES56
PASSWORDACCESS prompt
```
Verify that there are no other uncommented lines for the ENCRYPTIONTYPE and PASSWORDACCESS options.

The PASSWORDACCESS prompt option disables automatic, passwordless Tivoli Storage Manager authentication. Each operation that uses the Tivoli Storage Manager connector requires that you to enter a password. You can supply the password in the nzbackup and nzrestore connectorArgs option as TSM_PASSWORD=password or you can set TSM_PASSWORD as an environment variable.
Save and close the dsm.sys file.
If you installed the BA client kit, do one of the following steps:
- Change to the /opt/tivoli/tsm/client/ba/bin directory and repeat steps 3 through 9 to configure the BA client dsm.opt and dsm.sys files. Make sure that the changes that you make to the API client files are identical to the changes that you make for the BA client files.
- Copy the dsm.opt and dsm.sys files from the /opt/tivoli/tsm/client/api/bin directory to the /opt/tivoli/tsm/client/ba/bin directory.