The SQL transaction processing component of the DB2 UDB Option for CICS returns messages identified by “DB2 UDB Option for CICS error.”
These messages have a 5-digit message number and consist of two types:
DB2 messages forwarded from DB2 UDB to the client
Internal messages generated by the SQL transaction processor AMD2
The AMD2 message table handles both types of messages. This message processing table, which consists of a translation table and a text table, is created during installation of the DB2 UDB Option for CICS. It is an editable table that can be customized to suit customer requirements. For more information about the AMD2 message table and customizing the DB2 UDB Option for CICS messages, see Chapter 5, “Customizing the DB2 UDB Option for CICS Messages.”
DB2 errors generate messages that are returned to AMD2. The AMD2 message table processes the DB2 SQLCODEs and forwards the DB2 message and any additional information, such as SQL codes, to the client.
The AMD2 message table processes the DB2 UDB Option for CICS internal messages and sends them to the client.
