Example: DBSERROR - TARA/ABU

Teradata Archive/Recovery Utility Reference

Product
TARA/ABU
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-01
dita:mapPath
utr1488824663491.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2412
lifecycle
previous
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.