Recompiling UDXs and reregistering IBM Fluid Query

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

After you upgraded or installed INZA and SQL Extension toolkit to a corresponding 11.2.X.X version, you must recompile UDXs and reregister IBM Fluid Query if it is installed on the system.

Recompiling custom 32-bit UDX

After you upgraded from 11.0.x to 11.2.x, you must recompile UDXs.

  1. Find all 32-bit UDXs (excluding INZA and SQL Extension Toolkit).

    Follow the steps that are described in The nz_find_32bit_udx command.

    This nz_find_32bit_udx command also indicates whether the correct INZA and SQL Extension toolkit is installed on the system.

  2. After you identified the 32-bit host and 32-bit SPU code by running the nz_find_32bit_udx utility, recompile the code and reregister the UDXs.

    Follow the steps that are described inThe nzudxcompile command syntax.

Recompiling custom UDX

After you upgraded to 11.2.x.x, you must recompile UDXs.

  1. Refer the /nz/export/udx_list.txt for UDX names and verify that the source code is available.
  2. Recompile the code and re-register the UDXs by following the steps in The nzudxcompile command syntax.

Re-registering IBM Fluid Query functions

Note: Ensure that the fluid query package is available and installed. If not, download and install the package from the fix central.
  1. After INZA is upgraded, you must re-register the IFQAdmin function by running the following command:
    /nz/export/ae/products/fluidquery/fqRegister.sh --ifq-admin
  2. Re-register data connector/data movement functions with fqRegister.sh.