DBMS_MGWADM, 6 of 6

Summary of Database Views

The views listed in Table 31-36 provide Messaging Gateway configuration, status, and statistical information. Unless otherwise indicated, the SELECT privilege is granted to MGW_ADMINISTRATOR_ROLE so that only Messaging Gateway administrators have access to the views. All views are owned by SYS.

Table 31-36 Database Views

Name	Description
MGW_GATEWAY View	Lists configuration and status information for Messaging Gateway
MGW_LINKS View	Lists the name and types of messaging system links currently created
MGW_MQSERIES_LINKS View	Lists messaging system properties for MQSeries links
MGW_FOREIGN_QUEUES View	Lists the queue properties of registered queues
MGW_SUBSCRIBERS View	Lists subscriber properties, status, and statistical information
MGW_SCHEDULES View	Lists schedule properties and status

MGW_GATEWAY View

This view lists configuration and status information for Messaging Gateway, as shown in Table 31-37.

Table 31-37 MGW_GATEWAY Properties

Name	Type	Description
`AGENT_STATUS`	`VARCHAR2`	Status of the gateway agent. Values: `NOT_STARTED` if the gateway agent has not been started. `START_SCHEDULED` if gateway agent has been scheduled to start; this indicates the gateway has been started using `DBMS_MGWADM.STARTUP` but the queued job used to start the gateway agent has not been executed. `STARTING` if gateway agent is starting; this indicates the queued job has been executed and the gateway agent is starting up. `INITIALIZING` if gateway agent has started and is initializing. `RUNNING` if gateway agent is running. `SHUTTING_DOWN` if gateway agent is shutting down.
`AGENT_PING`	`VARCHAR2`	Gateway agent ping status. Values: `NULL` if no ping attempt was made. `REACHABLE` if ping attempt was successful. `UNREACHABLE` if ping attempt failed. `AGENT_PING` attempts to contact the gateway agent. There is a short delay (up to 5 seconds) if the ping attempt fails. No ping is attempted if the `AGENT_STATUS` is `NOT_STARTED` or `START_SCHEDULED`.
`AGENT_JOB`	`NUMBER`	Job number of the queued job used to start the Messaging Gateway agent process. The job number is set when the Messaging Gateway is started and cleared when it shuts down.
AGENT_USER	VARCHAR2	Database user name used by the gateway agent to connect to the database
AGENT_DATABASE	VARCHAR2	The database connect string used by the gateway agent. `NULL` indicates that a local connection is used.
`LAST_ERROR_DATE`	`DATE`	Date of last Messaging Gateway agent error. The last error information is cleared when Messaging Gateway is started. It is set if the Messaging Gateway agent fails to start or terminates due to an abnormal condition.
`LAST_ERROR_TIME`	`VARCHAR2`	Time of last Messaging Gateway agent error
`LAST_ERROR_MSG`	`VARCHAR2`	Message for last Messaging Gateway agent error
`MAX_CONNECTIONS`	`NUMBER`	Maximum number of messaging connections to the Oracle database
`MAX_MEMORY`	`NUMBER`	Maximum heap size used by gateway agent (in MB)

MGW_LINKS View

This view lists the names and types of messaging system links currently defined.

Table 31-38 MGW_LINKS Properties

Name	Type	Description
`LINK_NAME`	`VARCHAR2`	Name of the messaging system link
`LINK_TYPE`	`VARCHAR2`	Type of messaging system link. Values: `MQSERIES`
`LINK_COMMENT`	`VARCHAR2`	User comment for the link

MGW_MQSERIES_LINKS View

This view lists information for the MQSeries messaging system links. The view includes most of the messaging system properties specified when the link is created.

Table 31-39 MGW_MQSERIES_LINKS Properties

Name	Type	Description
`LINK_NAME`	`VARCHAR2`	Name of the messaging system link
`QUEUE_MANAGER`	`VARCHAR2`	Name of the MQSeries queue manager
`HOSTNAME`	`VARCHAR2`	Name of the MQSeries host
`PORT`	`NUMBER`	Port number
`CHANNEL`	`VARCHAR2`	Connection channel
`INTERFACE_TYPE`	`VARCHAR2`	Messaging interface type. Values: BASE_JAVA for the MQSeries Base Java interface
`MAX_CONNECTIONS`	`NUMBER`	Maximum number of messaging connections
`INBOUND_LOG_QUEUE`	`VARCHAR2`	Inbound propagation log queue
`OUTBOUND_LOG_QUEUE`	`VARCHAR2`	Outbound propagation log queue
`OPTIONS`	`SYS.MGW.PROPERTIES`	Link options
`LINK_COMMENT`	`VARCHAR2`	User comment for the link

MGW_FOREIGN_QUEUES View

This view lists information for foreign queues. The view includes most of the queue properties specified when the queue is registered.

Table 31-40 MGW_FOREIGN_QUEUES Properties

Name	Type	Description
`NAME`	`VARCHAR2`	Name of the registered queue
`LINK_NAME`	`VARCHAR2`	Name of the messaging system link
`PROVIDER_QUEUE`	`VARCHAR2`	Message provider (native) queue name
`DOMAIN`	`VARCHAR2`	Queue domain type. Values: `NULL` if automatically determined by messaging system `QUEUE` for a queue (point-to-point) model `TOPIC` for a topic (publish-subscribe) model
`OPTIONS`	`SYS.MGW.PROPERTIES`	Optional queue properties
`QUEUE_COMMENT`	`VARCHAR2`	User comment for the foreign queue

MGW_SUBSCRIBERS View

This view lists configuration and status information for Messaging Gateway subscribers. The view includes most of the subscriber properties specified when the subscriber is added, as well as other status and statistical information.

Table 31-41 MGW_SUBSCRIBERS Properties

Name	Type	Description
`SUBSCRIBER_ID`	`VARCHAR2`	Propagation subscriber identifier
`PROPAGATION_TYPE`	`VARCHAR2`	Propagation type. Values: `OUTBOUND` for AQ to non-Oracle propagation `INBOUND` for non-Oracle to AQ propagation
`QUEUE_NAME`	`VARCHAR2`	Subscriber source queue
`DESTINATION`	`VARCHAR2`	Destination queue to which messages are propagated
`RULE`	`VARCHAR2`	Subscription rule
`TRANSFORMATION`	`VARCHAR2`	Transformation used for message conversion
`EXCEPTION_QUEUE`	`VARCHAR2`	Exception queue used for logging purposes
`STATUS`	`VARCHAR2`	Subscriber status. Values: `ENABLED` if the subscriber is enabled `DELETE_PENDING` if subscriber removal is pending; typically the case when `DBMS_MGWADM.REMOVE_SUBSCRIBER` has been called but certain cleanup tasks pertaining to this subscriber are still outstanding.
`FAILURES`	`NUMBER`	Number of propagation failures
`LAST_ERROR_DATE`	`DATE`	Date of last propagation error
`LAST_ERROR_TIME`	`VARCHAR2`	Time of last propagation error
`LAST_ERROR_MSG`	`VARCHAR2`	Message for last propagation error
`PROPAGATED_MSGS`	`NUMBER`	Number of messages propagated to the destination queue since the last time the agent was started
`EXCEPTIONQ_MSGS`	`NUMBER`	Number of messages moved to the propagation exception queue since the last time the agent was started

MGW_SCHEDULES View

This view lists configuration and status information for Messaging Gateway schedules. The view includes most of the schedule properties specified when the schedule is created, as well as other status information.

Table 31-42 MGW_SCHEDULES Properties

Name	Type	Description
`SCHEDULE_ID`	`VARCHAR2`	Propagation schedule identifier
`PROPAGATION_TYPE`	`VARCHAR2`	Propagation type. Values: `OUTBOUND` for AQ to non-Oracle propagation `INBOUND` for non-Oracle to AQ propagation
`SOURCE`	`VARCHAR2`	Propagation source
`DESTINATION`	`VARCHAR2`	Propagation destination
`START_DATE`	`DATE`	Schedule start date
`START_TIME`	`VARCHAR2`	Schedule start time
`PROPAGATION_WINDOW`	`NUMBER`	Duration of the propagation window (in seconds)
`NEXT_TIME`	`VARCHAR2`	Date function used to compute the start of the next propagation window
`LATENCY`	`NUMBER`	Propagation window latency (in seconds)
`SCHEDULE_DISABLED`	`VARCHAR2`	Indicates whether the schedule is disabled. Values: `Y` if schedule is disabled `N` if schedule is enabled