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 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 in Recompiling 32-bit UDXs.

Reregistering IBM Fluid Query functions

After INZA is upgraded, you must reregister the IFQAdmin function by running the following command:
/nz/export/ae/products/fluidquery/fqRegister.sh --ifq-admin

Reregister data connector/data movement functions with fqRegister.sh.