The following table lists the event codes and describes the data that operators pass to the notify exit routine and the system log for each event.
Event | Event Code | Event Description and Data Passed To The Notify Exit Routine |
---|---|---|
Initialize | 0 | Signifies successful processing of
the notify feature:
|
Phase 1 Begin | 2 | Signifies the beginning of the
insert phase, where the table name is specified by the INSERT
statement:
|
Checkpoint | 3 | Signifies that checkpoint
information is written to the restart log table:
|
Phase 1 End | 4 | Signifies the CHECKPOINT LOADING END
request has successfully completed after the end of the insert
phase:
|
Phase 2 Begin | 5 | Signifies that the application phase
is beginning:
|
Phase 2 End | 6 | Signifies that the application phase
is complete:
|
Error Table 1 | 7 | Signifies that processing of the SEL
COUNT(*) request completed successfully for the first error
table:
|
Error Table 2 | 8 | Signifies that processing of the SEL
COUNT(*) request completed successfully for the second error
table:
|
Teradata Database Restart | 9 | Signifies that the Load operator
received a crash message from the Teradata Database or from the
CLIv2:
|
CLIv2 Error | 10 | Signifies that the Load operator
received a CLIv2 error:
|
Teradata Database Error | 11 | Signifies that the Load operator
received a Teradata Database error that will produce an Exit code of
12:
|
Exit | 12 | Signifies that the Load operator is
terminating:
|
Checkpoint | 13 | Signifies that checkpoint
information is written to the restart log table:
This event is only available when the value for the NotifyMethod attribute is set to 'Exit64' or 'ExitEON'. |
Phase 1 End | 14 | Signifies the CHECKPOINT LOADING
END request has successfully completed after the end of the insert
phase:
This event is only available when the value for the NotifyMethod attribute is set to 'Exit64' or 'ExitEON'. |
Phase 2 End | 15 | Signifies that the application
phase is complete:
This event is only available when the value for the NotifyMethod attribute is set to 'Exit64' or 'ExitEON'. |
Error Table 1 | 16 | Signifies that processing of the
SEL CAST(COUNT(*) AS BIGINT) request completed successfully for the
first error table:
This event is only available when the value for the NotifyMethod attribute is set to 'Exit64' or 'ExitEON'. |
Error Table 2 | 17 | Signifies that processing of the
SEL CAST(COUNT(*) AS BIGINT) request completed successfully for the
second error table:
This event is only available when the value for the NotifyMethod attribute is set to 'Exit64' or 'ExitEON'. |
Initialize | 18 | Signifies successful processing of
the notify feature:
This event is only available when the value for the NotifyMethod attribute is set to 'ExitEON'. |
Phase 1 Begin | 19 | Signifies the beginning of the
insert phase, where the table name is specified by the INSERT
statement:
This event is only available when the value for the NotifyMethod attribute is set to 'ExitEON'. |
The following table lists events that create notifications.
Event | Notification Level | Signifies | ||
---|---|---|---|---|
Low | Med | High | ||
Initialize | Yes | Yes | Yes | Successful processing of the notify option |
Phase 1 Begin | No | Yes | Yes | The acquisition phase is beginning |
Checkpoint | No | No | Yes | Checkpoint information is written to the restart log table |
Phase 1 End | No | Yes | Yes | Successful completion of the acquisition phase |
Phase 2 Begin | No | Yes | Yes | The application phase is beginning |
Phase 2 End | No | Yes | Yes | Successful completion of the application phase |
Error Table 1 | No | No | Yes | Successful processing of the SEL COUNT(*) request for the first error table |
Error Table 2 | No | No | Yes | Successful processing of the SEL COUNT(*) request for the second error table |
Teradata Database Restart | No | Yes | Yes | A crash error was encountered from the Teradata Database or CLIv2 |
CLIv2 Error | Yes | Yes | Yes | A CLIv2 error was encountered |
Teradata Database Error | Yes | Yes | Yes | A Teradata Database error was encountered that will terminate the load operation |
Exit | Yes | Yes | Yes | The Load operator is terminating |