Chapter 5: Customizing the DB2 UDB Option for CICS Messages

Translate table properties

Each SYRTMAMX macro entry in the translate table consists of the following DB2 error message properties:

TYPE

The TYPE property indicates whether the SYRTMAMX macro entry is the initial (INITIAL) or final (FINAL) entry in the translate table, or is one of the entries in between (ENTRY). Therefore, TYPE=INITIAL occurs once at the beginning of the translate table; TYPE=FINAL occurs once at the end of the table. Examples of the TYPE=INITIAL and TYPE=FINAL are shown as follows:

 SYRTMAMX TYPE=INITIAL 
... (additional entries not shown)
     SYRTMAMX TYPE=FINAL

WARNING! Do not change the INITIAL or FINAL value.

SQLCODE

The SQLCODE property contains the SQLCODE, a numeric status indicator returned by DB2. For messages that DB2 does not generate, such as internal error messages that AMD2 generates, the value of SQLCODE is always 0. This property contains 3 digits and a plus (+) or minus (-) sign.

MSGNR

The text table uses the message number to identify the appropriate message to send to the client. It represents a single SQLCODE or a group of SQLCODEs about similar situations.

WARNING! Do not change the number of non-DB2 messages (those with SQLCODE equal to 0 and MSGNR greater than or equal to 32000).

LEVEL

The LEVEL property indicates the severity of the error. It corresponds to the following Adaptive Server severity levels:

01–10 Status information 11–16 Client application errors 17–18 Non-fatal software or hardware errors 19–24 Fatal system errors

STATEC

The STATEC class property, a 2-byte field, provides more information about DB2 errors. For non-DB2 errors, the value is 0.

STATESC

The STATESC subclass property, a 3-byte field, provides more information about DB2 errors. For non-DB2 errors, the value is 0.

LOG

The LOG (logging instruction) property indicates whether to log the error in the AMD2LOG file. Sybase recommends logging serious errors. To turn logging on, specify the Y value. To turn logging off, specify the N value.

SQLFATAL

The SQLFATAL (fatal error) property indicates whether AMD2 accepts more client requests in the current invocation.

Y means that yes, the error is fatal, and therefore, no further requests are accepted from the current client connection.
N means that no, the error is not fatal, and requests are processed as usual.

View this book as PDF