The nz_find_32bit_udx command

• The script is introduced in 11.0.6.0 as a part of SST.
• The script searches for 32-bit SERVER and SPU code under the /nz/data directory.
• The script looks for a 32-bit SPU object files for user defined functions, aggregates, libraries etc.

With the script, you can identify whether you have the incorrect INZA or SQL Extension Toolkit versions installed on the system. The script also helps you to identify whether the migrated (or restored) database/s from older Netezza Performance Server releases have any 32-Bit SPU object files.

$ ./nz_find_32bit_udx

--------------------------------------------------------------------------------

The purpose of this script is to identify any 32-bit UDX
(any 32-bit user defined function / aggregate / library )
that exists on the system.

Expectations
------------
  NPS 7.x       -- server = 32 bit, spu = 32 bit
  NPS 11.0,11.1 -- server = 32 bit, spu = 64 bit
  NPS 11.2      -- server = 64 bit, spu = 64 bit

Inputs: No arguments are needed. The script knows what version of the NPS software you are currently using.
-------
  -spu             Search for any 32-bit SPU code.
                   This is the default option if your system is running 11.0 / 11.1
                   as all SPU code should now be compiled for 64 bit.

  -server          Search for any 32-bit SERVER code (that would run on the NPS host).
                   This is the default option if your system is running 11.2 as all UDXs
                   (both SPU and SERVER) should now be compiled for 64 bit.
--------------------------------------------------------------------------------