Registering a Netezza Performance Server client on a Tivoli Storage Manager server

Deployment options: IBM Netezza Appliance

About this task

To register a Netezza system on the Tivoli® Storage Manager server, you create a client node that represents the Netezza Performance Server host.

To register a Netezza Performance Server system as a client on a Tivoli Storage Manager server, complete the following steps.

Procedure

  1. In the left navigation frame of the ISC Console, click Tivoli Storage Manager.
  2. Click Policy Domains and Client Nodes.
  3. Select the Tivoli Storage Manager server from which you will be managing your Netezza Performance Server systems, and then select View Policy Domains from the Select Action list.
  4. Select a policy domain and select Modify Policy Domain from the Select Action list.
  5. Click the arrow to the right of Client Nodes to expand the client nodes list.
  6. Select Create a client node from the Select Action list.
  7. Type a name for the Netezza Performance Server host.
    The name must match the name that is specified in the dsm.sys file on the client system.
  8. Enter and confirm a password for client authentication, and choose an expiration for the password. Click Next to continue.
  9. You can either select Create administrator and assign it owner authority to node or Assign owner authority to selected administrator, then click Next.
    The administrator of a node can use the owner authority to perform administrative tasks such as changing the client properties. A Summary window opens to display messages about the successful creation of the client node.
  10. Click Finish.
    The newly created client node now displays in the Client Nodes list.
  11. Select the newly created client node and select Modify Client Node from the Select Action list.
  12. Click the Communications tab on the left.
  13. Type in the TCP address and port in the fields. You can specify the host name of the client (the Netezza Performance Server system host name) and any unused port value (for example, 9000). To list the used ports on the system, use the netstat command.
  14. Click the Advanced Settings tab on the left.
  15. Change the maximum size of transaction value to a value such as 4096.
    The maximum number of objects in a transaction cannot exceed 65000. Use caution when you are selecting a maximum for the number of objects per transaction; larger numbers can impact performance. Try to estimate the maximum number of objects in the database and set the value accordingly. You could begin with an estimate of three times the number of tables in the database.
  16. Click OK to save the settings.