Release 9.2.0.1.0 for UNIX
Part No. A96196-01
 Contents |
 Index |
|
Oracle® Procedural Gateway and Tools for IBM MQSeries Installation and User's Guide
Release 9.2.0.1.0 for UNIX Part No. A96196-01 |
|
The following tables describe the views for heterogeneous outbound and inbound propagation schedules.
The DBA views described in the appendix are:
| Column Name | Null? | Type | Description |
|---|---|---|---|
| SCHEMA | NOT NULL | VARCHAR2(30) | Schema for AQ source queue |
| QNAME | NOT NULL | VARCHAR2(30) | AQ source queue name |
| DESTINATION | NOT NULL | VARCHAR2(128)
|
Database link to a gateway for access to the destination queues at the non-Oracle message queuing system. |
| PROTOCOL |
|
NUMBER | Propagation protocol number |
| TRANSMIT_QUEUE | NOT NULL | VARCHAR2(30) | Transmit-queue for remote propagation |
| EXCEPTION_QUEUE | NOT NULL | VARCHAR2(30) | Propagation-exception queue |
| START_DATE |
|
DATE | Date to start propagation |
| START_TIME |
|
VARCHAR2(8) | Time to start propagation |
| PROPAGATION_WINDOW |
|
NUMBER | Duration in seconds for the propagation windows |
| NEXT_TIME |
|
VARCHAR2(128) | Function to compute the start of next propagation window |
| LATENCY |
|
NUMBER | Maximum wait time to propagate a message |
| LAST_DATE |
|
DATE | Most recent date this schedule executed successfully |
| LAST_TIME |
|
VARCHAR2 | Time of day of the last successful execution of this schedule |
| FAILURES |
|
NUMBER | Number of times the execution failed |
| DISABLED |
|
VARCHAR2 | N if enabled, Y if disabled and schedule will not be executed |
| ERROR_TIME |
|
DATE | Date and time of last unsuccessful execution |
| ERROR |
|
VARCHAR2 | Oracle error number |
| ERROR_MSG |
|
VARCHAR2 | Error message text |
| THIS_DATE |
|
DATE | Date the current execution of this schedule started. Null if not currently executing. |
| THIS_TIME |
|
VARCHAR2 | Time of day the current execution of this schedule started. Null if not currently executing. |
| SID |
|
VARCHAR2 | Session ID of the job executing this schedule. Null if not currently executing. |
| TOTAL_TIME |
|
NUMBER | Total time, in seconds, spent by the system in executing this schedule. |
| AVG_NUM |
|
NUMBER | Average number of messages propagated in a propagation window. |
| MAX_NUM |
|
NUMBER | Maximum number of messages propagated in a propagation window. |
| AVG_SIZE |
|
NUMBER | Average size of a propagated message in bytes. |
| MAX_SIZE |
|
NUMBER | Maximum size of a propagated message in bytes. |
| AVG_TIME |
|
NUMBER | Average time, in seconds, to propagate a message. |
| Column Name | Null? | Type | Description |
|---|---|---|---|
| SCHEMA | NOT NULL | VARCHAR2(30) | Schema for AQ source queue |
| QNAME | NOT NULL | VARCHAR2(30) | AQ source queue name |
| SOURCE | NOT NULL | VARCHAR2(128)
|
Database link to a gateway for access to the source queues at the non-Oracle message queuing system. |
| CONSUMER |
|
VARCHAR2 | Name of AQ consumer |
| PROTOCOL |
|
NUMBER | Propagation protocol number |
| EXCEPTION_QUEUE | NOT NULL | VARCHAR2(30) | Propagation-exception queue |
| START_DATE |
|
DATE | Date to start propagation |
| START_TIME |
|
VARCHAR2(8) | Time to start propagation |
| PROPAGATION_WINDOW |
|
NUMBER | Duration, in seconds, for the propagation windows |
| NEXT_TIME |
|
VARCHAR2(128) | Function to compute the start of next propagation window |
| LATENCY |
|
NUMBER | Maximum wait time to propagate a message |
| LAST_DATE |
|
DATE | Most recent date this schedule executed successfully |
| LAST_TIME |
|
VARCHAR2 | Time of day of the last successful execution of this schedule |
| FAILURES |
|
NUMBER | Number of times the execution failed |
| DISABLED |
|
VARCHAR2 | N if enabled, Y if disabled and schedule will not be executed |
| ERROR_TIME |
|
DATE | Date and time of last unsuccessful execution |
| ERROR |
|
VARCHAR2 | Oracle error number |
| ERROR_MSG |
|
VARCHAR2 | Error message text |
| THIS_DATE |
|
DATE | Date the current execution of this schedule started. Null if not currently executing. |
| THIS_TIME |
|
VARCHAR2 | Time of day the current execution of this schedule started. Null if not currently executing. |
| SID |
|
VARCHAR2 | Session ID of the job executing this schedule. Null if not currently executing. |
| TOTAL_TIME |
|
VARCHAR2 | Total time, in seconds, spent by the system in executing this schedule. |
| AVG_NUM |
|
NUMBER | Average number of messages propagated in a propagation window. |
| MAX_NUM |
|
NUMBER | Maximum number of messages propagated in a propagation window. |
| AVG_SIZE |
|
NUMBER | Average size of a propagated message in bytes. |
| MAX_SIZE |
|
NUMBER | Maximum size of a propagated message in bytes. |
| AVG_TIME |
|
NUMBER | Average time, in seconds, to propagate a message. |
|
 Copyright © 2001, 2002 Oracle Corporation All rights reserved |
|