The nzudxdbg command

Enables or disables message logging for user-defined functions or aggregates. The command displays messages to standard output and optionally to the standard log files. You must run this command as the nz user.

The command has the following syntax:
nzudxdbg [--all | --id hwid ] [--on | --off] [--file] [--user user] 
[--pw password] [-h]
The following table describes the usage for the command.
Table 1. The nzudxdbg command arguments
Argument Description
--all Displays messages from routines that are run on all the SPUs.
--id hwid Displays messages from routines that run only on the specified SPU. The hwid value must be a valid SPU ID.
--on Enables message logging for UDXs.
--off Disables message logging for UDXs.
--file When logging is enabled, specifies that the log messages are written to the standard log files in addition to standard output. The standard log files include the following files:
  • /nz/kit/log/dbos/dbos.log for the user-defined functions that run on the host
  • /nz/kit/log/postgres/pg.log for the functions that operate on the system catalog or at statement preparation time
  • /nz/kit/log/sysmgr/sysmgr.log for the functions that run on the SPUs
--user user Specifies a SQL user for the command. Use the admin user or a SQL user who has Manage Hardware privileges. The default is the value of NZ_USER.
--pw password Specifies the password for the SQL user account. The default is the value of NZ_PASSWORD.
-h Displays the command usage.