DISPATCHERNAMEMACHINENAMEAPPSERVER_PATHDATASEQNOPSAPMSGQUEUESET(SQL Table) |
Index Back |
|---|---|
IB Message Queue Status |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DISPATCHERNAME |
Character(15) | VARCHAR2(15) NOT NULL | Dispatcher Name |
| 2 | MACHINENAME |
Character(30) | VARCHAR2(30) NOT NULL | Machine Name |
| 3 | APPSERVER_PATH |
Character(64) | VARCHAR2(64) NOT NULL | Application Server Path |
| 4 | DATASEQNO |
Signed Number(11,0) | DECIMAL(10) NOT NULL | Data Sequence Number |
| 5 | IB_QUEUESET_STATUS | Number(1,0) | SMALLINT NOT NULL | Queue Set Status |
| 6 | IB_QUEUESET_SLAVE | Number(1,0) | SMALLINT NOT NULL | QueueSet Secondary |
| 7 | IB_QUEUESLAVEBUSY | Number(1,0) | SMALLINT NOT NULL | Queue Secondary Busy |
| 8 | IB_DISPATCH_COUNT | Number(5,0) | INTEGER NOT NULL | Queue Status Dispatch Count |
| 9 | IB_HDLR_COUNT | Number(5,0) | INTEGER NOT NULL | Handler Count |
| 10 | IB_QUEUESETLONG | Image / Attachment | CLOB | MIME Data Long |