IBM PureData System for Analytics, Version 7.1

nzload command syntax

The nzload command takes options and arguments. You can accept the defaults or specify options on the command line, in the control file, or by using environment variables.

Syntax

The nzload command uses the following syntax:

nzload [-h|-rev] [options]

Inputs

The nzload command uses many of the options for external tables as described in External table load options. Particular options for nzload are shown in the following table.

Table 1. The nzload options
Option	Description
-cf `filename`	Specifies the control file. For more information, see The nzload control file.
-df `filename`	Specifies the data file to load. If you do not specify a path, the system uses the special token <stdin> to store the file path string. Corresponds to the DataObject external table option.
-lf `filename`	Specifies the log file name. If the file exists, append to it.
-bf `filename`	Specifies the bad or rejected rows file name (overwrite if the file exists).
-outputDir `dir`	Specifies the output directory for the log and bad or rejected rows files. Corresponds to the LogDir external table option.
-logFileSize `n`	Session variable (LOAD_LOG_MAX_FILESIZE) that specifies the size (in MB) of the log and bad or rejected rows files. The default is 2000 MB (2 GB).
-fileBufSize -fileBufByteSize	Specifies the chunk size (MB for fileBufSize or bytes for fileBufByteSize) at which to read the data from the source file. Corresponds to the SocketBufSize external table option.
-allowReplay -allowReplay `n`	Session variables (LOAD_REPLAY_REGION and MAX_QUERY_RESTARTS) that specify the number of query restarts for load continuation if a SPU is reset or failed over. If `n` is a valid non-zero number, it specifies the number of allowable query restarts. If no value is specified, or `n` is 0, the system defaults to the Postgres default setting.

Additional options

The nzload command takes the following additional options:

Table 2. Additional options for nzload
Option	Description
-u `user`	Specifies the database user name [NZ_USER].
-pw `password`	Specifies the password of the Netezza® user [NZ_PASSWORD].
-host `name`	Specifies the host name or IP address [NZ_HOST]. Runs on the local host if not specified here. If you set this option to any name but localhost or any IP address but the reserved one (127.0.0.1), the system sets the remotesource option to ODBC.
-caCertFile `path`	Specifies the path name of the root CA certificate file on the client system. This argument is used by IBM® Netezza clients who use peer authentication to verify the Netezza host system. The default value is NULL which skips the peer authentication process.
-securityLevel `level`	Specifies the security level that you want to use for the session. The argument has four values: preferredUnSecured This value is the default value. Specify this option when you would prefer an unsecured connection, but you accept a secured connection if the Netezza system requires one. onlyUnSecured Specify this option when you want an unsecured connection to the Netezza system. If the Netezza system requires a secured connection, the connection is rejected. preferredSecured Specify this option when you want a secured connection to the Netezza system, but you accept an unsecured connection if the Netezza system is configured to use only unsecured connections. onlySecured Specify this option when you want a secured connection to the Netezza system. If the Netezza system accepts only unsecured connections, or if you are attempting to connect to a Netezza system that is running a release before 4.5, the connection is rejected. Note: If you specify an invalid value for the -securityLevel argument of the nzload command, the command defaults to the preferredUnSecured level.
-db `database`	Specifies the database to load [NZ_DATABASE].
-schema `schema`	For a Netezza system that supports multiple schemas in a database, this option specifies the schema in which to load the table. If you do not specify the -schema option, the system uses the value of the NZ_SCHEMA environment variable. If NZ_SCHEMA is not set, the system uses the default schema for the database.
-t `table`	Specifies the table name. You can specify a fully qualified name for this value.
`- port`	Specifies the port to use, which you can use to override the default.
-loginTimeout `<int-seconds>`	You can enter a different value, expressed in seconds, for the login timeout. This option overrides the default value of 30 seconds.

Outputs

The nzload command exits with the following codes:

0: Successful, all input records were inserted.
1: Failed, no records were inserted because of an error or errors found during the load.
2: Successful, but errors found during the input did not exceed the error threshold (-maxErrors), good records were inserted.