Session variables

You can use the following session variables as nzload options.

• LOAD_REPLAY_REGION

  Specifies that a simple load using external tables has the ability to continue after the system has been paused and resumed

• MAX_QUERY_RESTARTS

  Specifies the number of restarts allowed for load continuation.

• LOAD_LOG_MAX_FILESIZE

  Specified the maximum allowed size in MB for the log file.

• NZ_SCHEMA

  For Netezza systems that run Release 7.0.3 or later that support multiple schemas in a database, specifies the schema into which data should be loaded. The NZ_SCHEMA value can be helpful for users who have to support loads into release 7.0.3 multiple schema systems as well as systems which do not support multiple schemas. You can keep the same nzload commands and set NZ_SCHEMA when connecting to multiple schema systems, and unset the variable before using the load scripts to single- schema systems.