The nzudxvalidate command
Checks tables and views for references to dropped UDXs, and validates the existing UDXs for any problems such as missing or invalid object files. You must be logged in as the nz user account to run this command, and NZ_USER and NZ_PASSWORD must be set to the admin account and password.
Syntax
The nzudxvalidate command
has the following syntax:
nzudxvalidate [-h] [-d dbname]The -h option displays help for the command. You use the -d option to specify one database to check. By default, the command checks all the databases. If your Netezza Performance Server user account has limited access to the databases on the Netezza Performance Server system, the command can check only the databases that you have access.
Description
The nzudxvalidate command
locates any references to dropped UDXs or invalid UDXs within all
of the databases or a specific database. The Netezza Performance Server system
must be online when you run this command. The command displays a list
of any tables and views that reference dropped UDXs and any UDXs that
have issues with their object files, such as missing object files,
invalid object files, or object files that fail a CRC checksum match.
A description of these problems and how to resolve them follows the
example.
Processing tables
Table DEV.T2.C2 - default value references stale UDF(s): 'ONE()'
Processing views
View DEV.VAS uses stale UDA UDA_SUM (oid 214389)
View DEV.VAS2 uses stale UDF UDF_LENGTH (oid 214444)
View DEV.VAS2 uses stale UDA UDA_SUM (oid 214389)
Processing udfs
UDF CONVERT.STRING_SIZE_VARCHAR(CHARACTER VARYING(64000)) is missing
its EXTERNAL HOST OBJECT file
UDF CONVERT.STRING_SIZE_VARCHAR(CHARACTER VARYING(64000)) is missing
its EXTERNAL SPU OBJECT file
UDF CONVERT.CHARID(CHARACTER(ANY)) has invalid checksum for its
EXTERNAL HOST OBJECT file
UDF CONVERT.ONE() has invalid EXTERNAL HOST OBJECT file
UDF CONVERT.ONE() has invalid EXTERNAL SPU OBJECT file
Processing udas
UDA small.CHARMAX2(CHARACTER(20)) is missing its EXTERNAL HOST OBJECT
file
UDA small.CHARMAX2(CHARACTER(20)) is missing its EXTERNAL SPU OBJECT
file
Processing libraries
LIBRARY mydb.myudxlib is missing its EXTERNAL SPU OBJECT file
LIBRARY mydb.mymathlib has invalid checksum for its EXTERNAL SPU
OBJECT file
LIBRARY mydb.mysqllib has invalid EXTERNAL SPU OBJECT file
Done