Installing the IBM SQL Extensions toolkit

Learn how to install SQL Extensions toolkit by using python3 if you are on IBM Netezza Appliance 2.0.X.

1. Log in to the Netezza Performance Server host.

   oc exec -it ipshost-0 -n NAMESPACE bash

   Example:

   [root@gt22-node1 ~]# oc exec -it ipshost-0 -n nps-3 bash
   kubectl exec [POD] [COMMAND] is DEPRECATED and will be removed in a future version. Use kubectl exec [POD] -- [COMMAND] instead.
   [root@nps-3-npshost /]# su - nz
   Last login: Wed Oct 18 12:53:07 UTC 2023 on pts/3
   [nz@nps-3-npshost ~]$

2. Install SQL Extensions toolkit:
   • In the default SQLEXT database and ADMIN schema:

     python3 -m utils.addonsInstaller --sqlext 

   • In a database or schema of your choice:

     python3 -m utils.addonsInstaller --sqlext --database DATABSE --schema SCHEMA

     Replace DATABSE and SCHEMA with the names of you database and or schema.