15.10 - Syntax - Access Module

Teradata Tools and Utilities Access Module Reference

prodname
Access Module
vrm_release
15.10
category
Programming Reference
featnum
B035-2425-035K

Syntax

Note: Because the Named Pipes Access Module applies each parameter as it parses the initialization string, you can ensure the earliest possible acquisition of log information by doing one of the following:

  • Specify the log_directory parameter first
  • Use the NPLOGDIR environment variable to specify the log directory
  • where:

     

    Table 6: Initialization Syntax 

    Syntax Element

    Description

    block_size=n

    Block size, in bytes, of the data transfer operation where n is an integer from 1 to 2147483647.

    The default, if you do not specify the block_size parameter, is 65536 bytes.

    Due to the limitations in the Data Connector, the block size must be greater than or equal to the size of the largest record passing through the pipe. When the module is used in a trickle feed environment, as with TPump, the shortest latency occurs when the block size is set to the maximum record size.

    confirm_fallback_deletion=y

    Specification to make the Named Pipes Access Module present a confirmation prompt before deleting the fallback data file.

    fallback_directory=directorypath

    Path of the fallback data file directory. The default directory, if you do not specify the fallback_directory parameter, is:

  • /opt/np_axsmod on UNIX systems
  • %TEMP% or %WINDIR%\temp on Windows systems
  • fallback_file=filename

    Name of the fallback data file.

    log_directory=directorypath

    Path of the log file directory. If you do not specify the log_directory parameter, the default is:

  • /tmp on UNIX systems
  • %TEMP% or C:\ on Windows systems
  • log_level=n

    Specification that sets the level of detail to be posted to the log file, where:

  • 0 = Disabled – No logging. This is the default log_level value if you do not specify a log_directory path.
  • 1 = Critical – Logs events where a critical resource, such as memory or its message strings, cannot be obtained.
  • 2 = Error – Logs error conditions. This is the default if you specify a log_directory path but do not specify a log_level value.
  • 3 = Warning – Logs unusual events that do not halt processing.
  • 4 = Information – Logs operational events or statistics.
  • 5 = Debug – Logs details normally required for debugging.
  • 6 = Trace – Logs all available information about each I/O operation.
  • need_full_block=no

    Enables buffer flushing within client scripts when set to “no.”

    Must be set to “no” when TPump is using the latency option with IMPORT.

    Buffer flushing performs checkpoint restarting differently when not enabled (the default), the fallback recovery data generated is different, and is not interchangeable between flushing and nonflushing modes.

    pipe_wait=n

    Holds the sleep interval (in milliseconds) for polling the pipe when need_full_block=no. By default, the pipe_wait is set to 10 milliseconds.

    signature_check=checklevel

    Specification that sets the level of detail to be posted to the log file, where:

    0 = Disabled – A signature is neither calculated nor checked.

    1 = Enabled/No Return – Calculates and checks a signature and logs an error if the check fails, but does not return an error condition.

    2 = Enabled/Return – Calculates and checks a signature and logs and returns an error condition if the check fails.

    [no_fallback

    [With this parameter presented in the Initialization string, Names Piped Access Module will not create the Fallback file. Also, no checkpoints will be done for the Named Piped Access Module, the utility job couldn't be restart-able. Also, when this parameter is presented, the fallback_file and fallback_directory setting will be ignored.