where the following is true:
- SESSIONS…
- Maximum number of FastExport sessions that is logged on
when a LOGON command is entered and, optionally, the minimum number of
sessions required to run the job
- The max value specifies the maximum number of sessions to log on. The max specification must be greater than zero. If a SESSIONS max value is specified that is larger than the number of available AMPs, FastExport limits the sessions to one per working AMP. The default maximum, if the SESSIONS option is not used, is 4.
- The min value specifies the minimum number of sessions required for the job to continue. The min specification must be greater than zero. The default minimum, if the SESSIONS option is not used or a min value is specified, is 1. If the min value is specified as 0 which is invalid, FastExport will display an error message and terminate with the user error, RC=8"
- The * value specifies the maximum and minimum number of sessions. Using the asterisk character as the max specification logs on for the maximum number of sessions, one for each AMP. Using the asterisk character as the min specification logs on for at least one session, but always less than or equal to the max specification.
- TENACITY hours
- Number of hours that FastExport tries to log on to the database
- SLEEP minutes
- Number of minutes that FastExport waits between logon attempts
- NOTIFY…
- FastExport implementation of the notify user exit
option:
- NOTIFY OFF suppresses the notify user exit option.
- NOTIFY LOW enables the notify user exit option for those events signified by “Yes” in the Low Notification Level column of the following table in this section.
- NOTIFY MEDIUM enables the notify user exit option for those events signified by “Yes” in the Medium Notification Level column of the following table in this section.
- NOTIFY HIGH enables the notify user exit option for those events signified by “Yes” in the High Notification Level column of the following table in this section.
- EXIT name
- User-defined exit where name is the name of a user-supplied library with a member name of _dynamn
- TEXT 'string'
- A user-supplied string of up to 80 characters that FastExport passes to the named user exit routine
- MSG 'string'
- A user-supplied string of up to 16 characters that
FastExport logs on to:
- The operator’s console (mainframe-attached z/OS client systems)
- The system log (workstation-attached UNIX and Windows client systems)
- QUEUE option
- Queue management option on mainframe-attached z/OS client systemsThis option is available only on z/OS, and only for tasks with a low notification specification.
- DATAENCRYPTION
- Keyword that enables data encryption for the FastExport job
- DECIMALDIGITS
- A user-supplied maximum number of digits in the DECIMAL data type that can be exported. Starting from V2R6.2, the maximum number of digits in the DECIMAL data type increased from 18 to 38. Note that if a user does not set the limit, the default maximum number of digits is 18.
- NOSTOP
- If the NOSTOP option is specified and the database or CLIv2 does not support Large Decimal, if the user specifies a valid value for the decimaldigits parameter, FastExport does the following:
- Displays a message that the database or CLIv2 does not support Large Decimal
- Displays a warning that the decimaldigits setting is ignored
- Continues with the Teradata FastExport job
- Exits with an exit code of 4, unless there is another error with a higher exit code
- SPOOL
- Tells FastExport to spool the answer set. This is the default.
- NOSPOOL
- Tells FastExport to try to use the NoSpool method. If the NoSpool method is not supported, FastExport issues a warning and then uses the Spool method
- NOSPOOLONLY
- Tells FastExport to use the NoSpool method only. If the NoSpool method is not supported, then terminate the job with an error.
The following table lists the events which create notifications.
Event | Notification Level | Signifies | ||
---|---|---|---|---|
Low | Medium | High | ||
Initialize | Yes | Yes | Yes | Successful processing of the BEGIN EXPORT command |
File or INMOD open | No | No | Yes | Successful processing of the IMPORT command |
Database Restart | No | Yes | Yes | A crash error from the database or CLIv2 |
CLIv2 error | Yes | Yes | Yes | A CLIv2 error |
Database error | Yes | Yes | Yes | A database error that terminates FastLoad |
Exit | Yes | Yes | Yes | FastExport is terminating |
Export begin | No | Yes | Yes | Opening the export file |
Request submit begin | No | Yes | Yes | Submitting the SELECT request |
Request submit end | No | Yes | Yes | Received SELECT request response |
Request fetch begin | No | Yes | Yes | Fetching SELECT request results |
File or OUTMOD open | No | No | Yes | Opening output file or OUTMOD |
Statement fetch begin | No | No | Yes | Fetching current statement |
Statement fetch end | No | No | Yes | Last record fetched for current statement |
Request fetch end | No | Yes | Yes | Last record fetched for current request |
Export end | No | Yes | Yes | Export task completed |
Block Count | No | Yes | Yes | The total number of blocks when the no spool is in effect |