Example: DBSERROR - Teradata Tools and Utilities

Teradata® Archive/Recovery Utility Reference

Product
Teradata Tools and Utilities
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-06-05
dita:mapPath
fac1527114221922.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2412
Product Category
Teradata Tools and Utilities
ARCMAIN DBSERROR=(2805,12)

In this example, error code 2805 (maximum row length exceeded) has its severity level increased from its default level of warning (4) to fatal error (12).

ARCMAIN DBSERROR=(2843,4)

In this example, error code 2843 (database out of space) has its severity level decreased from its default level of fatal error (12) to warning (4).

ARCMAIN DBSERROR=(2843,4) DBSERROR=(2805,8)

In this example, error code 2843 (database out of space) has its severity level decreased from its default level of fatal error (12) to warning (4) and error code 2805 (maximum row length exceeded) has its severity level increased from its default level of warning (4) to non-fatal error (8).

ARCMAIN DBSERROR=(2805,4) DBSERROR=(2805,12) DBSERROR=(2805,8).

In this example, error code 2805 (maximum row length exceeded) is specified 3 times, each with a different severity level. Changing from its default level of warning (4) to fatal error (12) to non-fatal error (8). Since non-fatal error(8) is the last severity level specified, it will be the severity level used.