Connecting to Netezza Performance Server

Netezza Performance Server for Cloud Pak for Data System

Learn about the different ways you can use to log in to your instance.

Important: Starting from Netezza Performance Server 11.2.2.X, the name of the host container is ipshost-0. You can access the host container by running the oc command instead of the docker command.

Logging in by running the oc exec command

As root on e1n1, display Netezza Performance Server instances that run on Cloud Pak for Data System:

nzinstall display

Example:

[root@gt20-node1 ~]# nzinstall display
Log file: /var/log/appliance/application/support-tools/nzinstall-20211007175934.log
Number of NPS instances detected: 1
-------------------- NPS instance --------------------
  -- namespace : nps-1
  -- network device : fbond.4084
  -- host nodes : ['e1n4', 'e2n1', 'e2n2', 'e2n3', 'e2n4']
  -- SPU nodes : ['e3n1', 'e3n2', 'e3n3', 'e3n4', 'e4n1', 'e4n2', 'e4n3', 'e4n4']

On Cloud Pak for Data System, node1 is the DNS alias for the first control plane node.

Access the Netezza Performance Server container:

oc exec -it ipshost-0 -n NAMESPACE -- bash

su - nz

Example:

[root@gt20-node1 ~]# oc exec -it ipshost-0 -n nps-1 -- bash
[root@nps-1-npshost /]# su - nz
Last login: Thu Oct  7 22:00:49 UTC 2021

Verify that the state of the instance is Online:

nzstate -local

Example:

[nz@nps-1-npshost ~]$ nzstate -local
Online

Logging in by connecting to port 51022

If you deployed Netezza Performance Server by using an external IP address, you can log in to the container by connecting to port 51022.

From a remote client machine, connect to port 51022 as root:

ssh -l root EXTERNAL_NPS_IP_ADDRESS -p 51022

Example:

[root@gt20-node1 ~]# ssh -l root <external_nps_ip_address> -p 51022
Warning: Permanently added '<external_nps_ip_address>:51022' (RSA) to the list of known hosts.
root@<external_nps_ip_address>'s password:
Last login: Thu Oct  7 22:45:43 2021 from 9.254.26.1
[root@nps-1-npshost ~]#

On Cloud Pak for Data System, node1 is the DNS alias for the first control plane node.

Logging in by connecting to a port mapped to the ssh service

If you deployed Netezza Performance Server without using an external IP address, you can log in to the container by connecting to a port, which is mapped to the ssh service.

As root, on e1n1, establish what the external IP address for Cloud Pak for Data System is:
```
ip -br -c addr show
```
The external IP address is listed after fbond.901@fbond UP.
As root, on e1n1, establish which port is mapped to port 51022:
```
oc get all -n NAMESPACE -o wide
```
The port number is listed in the service/ipshost-external section. For example, 51022:31419/TCP.
To get the namespace, run the command:
```
oc get pods --all-namespaces  | grep ipshost | awk '{print $1}'
```

From a remote client machine, connect to port 51022 as root:

ssh -l root EXTERNAL_CPDS_IP_ADDRESS -p PORT_MAPPED_TO_51022

Example:

[root@gt22-node1 ~]# ssh -l root <external_cpds_ip_address> -p 31419