Upgrading to 11.2.3.0 or later

Before you begin

Important:
  1. Before you upgrade, always read the release notes to be aware of all prerequisites and known issues for your particular release. For more information, see Netezza Performance Server 11.2.X.X release notes.
  2. Install your third-party software after the upgrade again as Netezza Performance Server does not provide any means to preserve the software.
  3. Downgrading from 11.2.3.X to 11.2.1.X Netezza Performance Server version is not supported. Contact IBM support for more information.
  4. In order to upgrade to 11.2.3.X, Netezza Performance Server must be on version 11.2.1.7 or later.
Note:
  • With 11.2.3.0, the default compiler is GCC-9.
  • All on-prem custom UDX must be upgraded to GCC-9.
  • 11.2.3.0 does not support GCC-4.
  1. Run udx_backup.sh as nz user to capture the complete list of custom UDF and respective CREATE FUNCTION statement.
    Note: The script will capture the output file under /nz/export/ location.
    Example:
    [nz@ipshost-0 ~]$ ./udx_backup.sh.sh
    The list of third party UDX will be saved as /nz/export/udx_list.txt
  2. Verify that you have CPP code for each of those custom UDF that is listed in /nz/export/udx_list.txt
    Important: Following are the considerations for upgrading to 11.2.3.0 or later:
    1. A non-void function must include a return statement. Using an incorrect return type or declaring a function as void when it should return a value will cause the system to crash immediately.
    2. GCC-9 is more strict in handling NULL values, requiring that UDX, UDF's and UDTF's must have proper NULL handling conditions.
    3. C++11 coding standards must be followed while handling pointers, structures, and syntax issues.
    4. All object files (prefix.o) compiled over gcc-4 must be recompiled and re-registered over GCC-9 to maintain compatibility.
    5. Ensure not to back up the old incompatible object files when taking backup. Restore the backup after RHEL8 upgrade is completed.
    6. python2 is no longer supported.
  3. Port/Compile CPP code for each UDX listed in step 2. Download the scripts from udx_backup.sh.

Procedure

  1. Run the following command to uninstall INZA. 
    /nz/var/nzcm/uninstall_inza.sh
  2. Go to libnetcrypto/11.2.x.x/ and libnetxml/11.2.x.x/ and run the following command to uninstall SQL extension toolkit. 
    ./install -d sqlext -R
  3. Verify that udx_backup.sh script output captures CREATE FUNCTION statement as mentioned in Before you begin upgrading to Netezza Performance Server 11.2.3.0 or later.
  4. Upgrade the host container and Netezza Performance Server to 11.2.3.0 or later, see Upgrading the container to 11.2.3.0 or later.
  5. Install the SQL extension toolkit that comes with 11.2.2.10, see Installing the IBM SQL Extensions toolkit.
  6. Install INZA that comes with 11.3.1, see Installing Netezza Performance Server Analytics.

What to do next

Compile and register all custom UDF. For more information, see Recompiling UDXs and reregistering IBM Fluid Query and Register the UDF with the Netezza Performance Server system.