The nzverifyauditsig command

Use the nzverifyauditsig command to verify the signature of a signed block in a specified audit database table.

Synopsis

Syntax for this command:
nzverifyauditsig [options]

Inputs

The nzverifyauditsig command takes the following inputs.
Table 1. The nzverifyauditsig inputs
Input Description
-d | --db <dbname> The name of the history database.
-f|--le-start <logEntryStart> The starting log entry ID of the signed block.
-l|--le-end <logEntryEnd> The ending log entry ID of the signed block.
-m|--npsid <npsid> The ID of the source system.
-i|--instance <npsinstanceid> The instance ID of the source Netezza Performance Server system.
-n|--host <host> The host name of the target Netezza Performance Server system. The default is NZ_HOST.
-p|--pwd <password> The password for USER that is used for getting audit data. The default is NZ_PASSWORD.
-s|--seq-start <seqIdStart> The starting sequence ID of the signed block. The default is 0.
-e|--seq-end <seqIdEnd> The ending sequence ID of the signed block. The default is 0.
-t|--type <audittype> The type of audit table database to verify. You can specify additional information:
  • Failed_authentication (0)
  • Session_prolog (1)
  • Session_epilog (2)
  • Query_prolog (3)
  • Query_epilog (4)
  • Query_overflow (5)
  • Log_entry (6)
  • Plan_prolog (7)
  • Plan_epilog (8)
  • Table_access (9)
  • Table_access (9)
  • Service (11)
  • State_change (12)
-u|--user <user> The USER account used to extract audit data. The default is NZ_USER.
-v|--schema <num> The version of the history database. For Netezza Performance Server Release 4.6, the number is 1. Starting in Release 7.0.3, the version number is 2 to support multiple schemas and other changes. Starting in Release 7.1, the version number is 3 to support scheduler rules and client information fields.
-h|--help Display the help for this topic.

Outputs

The nzverifyauditsig command has the following outputs:
Table 2. The nzverifyauditsig output
Output Description
Signature verified. The digital signature and key used were checked and verified.
Signature could not be verified. The digital signature and key used were checked and cannot be verified.

Description

Verifies the signature of a signed block in a specified audit database table.

Privileges required
None.
Common tasks
Verify a signed block.

Usage

The following provides sample usage:
nzverifyauditsig -d auditdb -t query_epilog -v 2 -u histusr -p admpw 
-i 2 -m 1