PSSERVERSTAT(SQL Table) |
Index Back |
|---|---|
Process Server Statistics |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SERVERNAME |
Character(8) | VARCHAR2(8) NOT NULL | Server Name |
| 2 | SERVERSTATUS | Character(2) | VARCHAR2(2) NOT NULL |
Server Status
0=Error 1=Down 2=Suspended 3=Running 4=Purging 5=Running With No Report Node 6=Suspended - Disk Low 7=Suspended - Offline 8=Running - Report Rep. Full 9=Overloaded |
| 3 | BEGINDTTM | DateTime(26) | TIMESTAMP | Begin Date/Time |
| 4 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 5 | SERVERACTION | Character(2) | VARCHAR2(2) NOT NULL |
Process Server Action
0=None 1=Stop 2=Suspended 3=Restart 4=Purge |
| 6 | SRVRHOSTNAME | Character(80) | VARCHAR2(80) NOT NULL | Server Hostname |
| 7 | DAEMONACTION | Character(1) | VARCHAR2(1) NOT NULL |
Daemon Action
0=No Action 1=Shutdown |
| 8 | DAEMONPROCESSID | Number(10,0) | DECIMAL(10) NOT NULL | Daemon Process ID |
| 9 | DAEMONPRCSINST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 10 | SCHDLROESRVCNT | Number(3,0) | SMALLINT NOT NULL | Opt. Eng. Tuxedo Server Count |
| 11 | SCHDLRAESRVCNT | Number(3,0) | SMALLINT NOT NULL | App Eng. Tuxedo Server Count |
| 12 | SCHDLRUSEAESRVFLAG | Number(1,0) | SMALLINT NOT NULL | Use AE Tuxedo Server |
| 13 | SCHDLRMASTERSTAT | Character(1) | VARCHAR2(1) NOT NULL |
Master Scheduler Status
0=Inactive 1=Master Scheduler Idle 2=Master Scheduler Active |
| 14 | MAXCPU | Number(3,0) | SMALLINT NOT NULL | Max. CPU Usage required |
| 15 | MINMEM | Number(3,0) | SMALLINT NOT NULL | Min. Memory Required |
| 16 | ORDERNO | Number(5,0) | INTEGER NOT NULL | Sort Order |
| 17 | PRCSTHRESHOLD | Number(8,0) | INTEGER NOT NULL | Disk Space Threshold |
| 18 | PRCSDISKSPACE | Number(8,0) | INTEGER NOT NULL | Disk Space Available |