MACHINENAMEAPPSERVER_PATHA=Active
I=Inactive
PSIBDOMSTATUSVW(SQL View) |
Index Back |
|---|
| SELECT MACHINENAME ,APPSERVER_PATH ,DOMAIN_STATUS ,IB_SLAVEMODE ,IBFAILOVERPRIORITY , IBFAILOVERGROUP FROM PSAPMSGDOMSTAT WHERE IB_SLAVEMODE <> 1 AND IB_SLAVEMODE <> 3 AND IB_SLAVEMODE <> 4 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MACHINENAME |
Character(30) | VARCHAR2(30) NOT NULL | Machine Name |
| 2 | APPSERVER_PATH |
Character(64) | VARCHAR2(64) NOT NULL | Application Server Path |
| 3 | DOMAIN_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Domain Status
A=Active I=Inactive |
| 4 | IB_SLAVEMODE | Number(1,0) | SMALLINT NOT NULL | Integration Broker Sec Mode |
| 5 | IBFAILOVERPRIORITY | Number(3,0) | SMALLINT NOT NULL | Failover Priority |
| 6 | IBFAILOVERGROUP | Number(3,0) | SMALLINT NOT NULL | Failover Group |