How to interpret messages
The Classic products issue messages to communicate system status and processing results. Messages are identifiable by unique message numbers. The format of a message number can help you understand what the message applies to and, in some cases, its severity.
The numbers that are assigned to messages are associated with specific services, components, or functional areas The following table identifies each set of messages and the service, component, or functional area associated with the message set.
| Message set | Service, component, or functional area |
|---|---|
| -nnnn | SQL errors |
| 0x0000 | General errors |
| 0x0002 | File management |
| 0x000b | Query processor |
| 0x0013 | JDBC driver |
| 0x002f | SQL data errors |
| 0x0042 | B-tree |
| 0x0049 | Query processor |
| 0x0056 | CLI and ODBC clients |
| 0x0057 | Metadata catalog |
| 0x0063 | Connection handler |
| 0x0065 | Configuration management |
| 0x0066 | Virtual messaging interface |
| 0x0067 | Local queue protocol |
| 0x0068 | TCP/IP SKT protocol |
| 0x0069 | Virtual communications interface (VCI) |
| 0x006a | z/OS® operating system |
| 0x006f | ICU/NLS |
0x0071
0x0072 0x0073 0x0074 |
Dynamic catalog update |
| 0x0076 | Metadata utility |
| 0x0079 | UNIX domain sockets protocol |
| 0x0092 | Change data capture engine-to-engine protocol |
| 0x0093 | Indexed list interface |
| 0x0103 | Replication capture service |
| 0x0109 | Replication log reader service |
| 0x010b | Classic replication monitoring service |
| 0x010c | Classic replication administration service |
| 0x010d | Classic replication runtime environment |
| 0x0112 | Intertask communication messages (ICMs) |
Messages that begin with the CAC and CEC prefixes are console messages. These sets of messages are in the following format:
CECM0001I- CEC
- The first three characters represent the Classic product.
- M
- The fourth character is the component identifier, which identifies the component that issued the message. In this example, M identifies the monitoring service.
- 0001
- The numeric identifier is three to four characters long and begins at the fifth character in the message. The numeric identifier is unique within the component.
- I
- The last character of the message is the message type code. The
message type codes include:
- A
- Action is required.
- E
- Error message.
- I
- Informational message.
- W
- Warning message.
| Message set | Service, component, or functional area |
|---|---|
| CAC0 | Data server |
| CACA | Controller service |
| CACB | Logger service and log print utility (CACPRTLG) |
| CACC | Connection handler service |
| CACD | Metadata catalog |
| CACE | Query processor service |
| CACF | Database access service |
| CECC | Capture service |
| CECD | DBMS specific messages Note: The following message sets apply to specific product features:
|
| CECL | General log reader service |
| CECM | Monitoring service |
| CECN | Administration service |