NOWARN
Purpose
The NOWARN parameter provides a runtime option to the ARCMAIN client to selectively reclassify a normally warning condition as normal to ensure normal exit if the selected message is issued.
Syntax
where
Syntax Element |
Definition |
errorno |
Changes specified warning error codes to a severity code of 0 |
Usage Notes
NOWARN changes the severity of an Teradata ARC warning code to NORMAL, severity code = 0. This runtime parameter is useful for those who do not want specific warning codes to generate an exit code with severity level of 4 (WARNING).
The warning message will still be displayed in the job output but it will be classified as an 'INFO' message with severity 0 instead of a 'WARNING' message with severity 4. If no other conditions are found, the job will terminate with severity 0.
This option only applies to warning codes; any non-warning code entered with this option will be considered to be an invalid warning code and will result in a fatal error condition and cause ARCMAIN to abort.
ARCMAIN NOWARN=(1032,1033,1034)
Delimiters, such as =, are mandatory.
To see a list of the Teradata ARC warning codes, please see Table 18 on page 156 in the WARNING Severity Level section.
Notice:
If this runtime parameter is used, the user will be less likely to see the warning messages that are being filtered out. For this reason, when this runtime parameter is used, the user is solely responsible for any consequences caused by ignoring the specified warning messages
.
Example
Without the NOWARN runtime parameter: ARCMAIN
08/22/2013 15:43:44
.
.
08/22/2013 15:43:44
08/22/2013 15:43:44 *** Warning ARC1032:Object "ARCTESTDB_DB1" has one or more
Online tables that is still logging.
08/22/2013 15:43:44
08/22/2013 15:43:44 DUMP COMPLETED
08/22/2013 15:43:44
08/22/2013 15:43:44 *** Warning ARC1033:After archive, one or more Online
tables is still logging.
08/22/2013 15:43:44
08/22/2013 15:43:44 STATEMENT COMPLETED
08/22/2013 15:43:44
08/22/2013 15:43:44 LOGGED OFF 7 SESSIONS
08/22/2013 15:43:44 STATEMENT COMPLETED
08/22/2013 15:43:44
08/22/2013 15:43:44
08/22/2013 15:43:44 ARCMAIN TERMINATED WITH SEVERITY 4
With the NOWARN runtime parameter: ARCMAIN NOWARN=(1032,1033)
08/22/2013 18:35:24 SEVERITY LEVEL CHANGED TO NORMAL(0): ARC1032, ARC1033
08/22/2013 18:35:24
.
.
08/22/2013 18:35:31
08/22/2013 18:35:31 *** Info ARC1032:Object "ARCTESTDB_DB1" has one or more
Online tables that is still logging.
08/22/2013 18:35:31
08/22/2013 18:35:31 DUMP COMPLETED
08/22/2013 18:35:31
08/22/2013 18:35:31 *** Info ARC1033:After archive, one or more Online tables
is still logging.
08/22/2013 18:35:31
08/22/2013 18:35:31 STATEMENT COMPLETED
08/22/2013 18:35:31
08/22/2013 18:35:31 LOGGED OFF 7 SESSIONS
08/22/2013 18:35:31 STATEMENT COMPLETED
08/22/2013 18:35:31
08/22/2013 18:35:31
08/22/2013 18:35:31 ARCMAIN TERMINATED WITH SEVERITY 0
With an invalid WARNING code: ARCMAIN NOWARN=(1030)
The job will terminate with the following error:
08/22/2013 19:08:33 *** Failure ARC0016:TERMINATING BECAUSE OF UNANTICIPATED
CONDITIONS. 1030 is not a valid warning number for NOWARN.