Table of Contents
This appendix describes the columns of the tables created when the Persistence store is set to JDBC in JEUS MQ.
The following table contains information about JEUS MQ's persistence store.
| Item | Type | Description |
|---|---|---|
| SERVER_NAME | VARCHAR(255) | JEUS MQ server name |
| VERSION | BIGINT | JEUS MQ version |
The following table contains information about destinations.
| Item | Type | Description |
|---|---|---|
| DT_ID | BIGINT | Destination ID |
| DT_NAME | VARCHAR(255) | Destination name |
| DT_QUEUE | BIT | Indicates whether the destination is a Queue or Topic.
|
| DT_VALID | BIT | Indicates whether the destination is valid. |
| DT_LVID | BIGINT | Current version of the destination |
| DT_DYNAMIC | BIT | Indicates whether the destination is created dynamically or not |
| DT_OBJECT | BLOB | Binary data of the destination |
The following table contains information about durable subscribers.
| Item | Type | Description |
|---|---|---|
| DS_ID | BIGINT | Durable subscriber ID |
| DS_CLIENT_ID | VARCHAR(255) | Client ID assigned to the durable subscriber |
| DS_NAME | VARCHAR(255) | Durable subscriber name |
| DS_SELECTOR | VARCHAR(255) | Message selector assigned to the durable subscriber |
| DS_VALID | BIT | Indicates whether the durable subscriber is valid |
| DS_LVID | BIGINT | Current version of the durable subscriber |
| DT_ID | BIGINT | ID of the topic linked to the durable subscriber |
| DT_LVID | BIGINT | Version of the topic linked to the durable subscriber |
The following table contains information about messages.
| Item | Type | Description |
|---|---|---|
| MG_ID | BIGINT | Message ID |
| MG_TYPE | TINYINT | Message type |
| MG_LENGTH | INTEGER | Message length |
| MG_OBJECT | TINYINT[] | Binary data of the message |
| MG_STATUS | SMALLINT | Message status |
| MG_GLOBAL_ORDER_CLOCK | SMALLINT | Time when the message's Global Order was set |
| MG_PERSISTENT | TINYINT[] | Indicates whether a message is set as persistent or not. |
| DT_ID | BIGINT | ID of the message's destination |
| DT_LVID | BIT | Version of the message's destination |
| MG_HEADER_LENGTH | INTEGER | Message header length |
| MG_HEADER_OBJECT | TINYINT[] | Binary data of the message header |
The following table contains information about durable subscriber messages.
| Item | Type | Description |
|---|---|---|
| DM_ID | BIGINT | Durable subscriber message ID |
| DM_STATUS | SMALLINT | Status of the durable subscriber message |
| DM_LVID | BIGINT | Current version of the durable subscriber message |
| MG_ID | BIGINT | ID of the actual message |
| DS_ID | BIGINT | ID of the durable subscriber that contains the durable subscriber message |