PMN_SRVRLIST

(SQL View)
 Index Back

Process Monitor Server List

This view is used to list server definitions in the Process Monitor.

SELECT A.SERVERNAME , A.BEGINDTTM , A.LASTUPDDTTM , A.SERVERSTATUS , A.SRVRHOSTNAME , X.XLATLONGNAME , B.DESCR , S.DESCR , B.DISTNODENAME , B.MAXAPIAWARE , B.SLEEPTIME , B.HEARTBEAT , B.DAEMONENABLED , B.DAEMONGROUP , B.DAEMONSLEEPTIME ,A.PRCSTHRESHOLD ,A.PRCSDISKSPACE ,B.SRVRLOADBALOPTN ,B.MAXCPU , B.MINMEM ,B.OPSYS FROM PSSERVERSTAT A , PS_SERVERDEFN B , PS_PRCSSRVROPSYS S , PSXLATITEM X WHERE A.SERVERNAME = B.SERVERNAME AND A.SERVERSTATUS = X.FIELDVALUE AND S.OPSYS = B.OPSYS AND X.FIELDNAME = 'SERVERSTATUS'

  • Related Language Record: PMN_SRVRLSTLANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SERVERNAME Character(8) VARCHAR2(8) NOT NULL Server Name
    2 BEGINDTTM DateTime(26) TIMESTAMP Begin Date/Time
    3 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.
    4 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
    5 SRVRHOSTNAME Character(80) VARCHAR2(80) NOT NULL Server Hostname
    6 SERVERSTATUSDESCR Character(30) VARCHAR2(30) NOT NULL Server Status
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
    9 DISTNODENAME Character(15) VARCHAR2(15) NOT NULL Report Distribution Node Name
    10 MAXAPIAWARE Number(3,0) SMALLINT NOT NULL Max API Aware Tasks
    11 SLEEPTIME Number(4,0) SMALLINT NOT NULL Sleep Time
    12 HEARTBEAT Number(4,0) SMALLINT NOT NULL Heartbeat
    13 DAEMONENABLED Character(1) VARCHAR2(1) NOT NULL Daemon Enabled
    14 DAEMONGROUP Character(8) VARCHAR2(8) NOT NULL Daemon Procedure Group
    15 DAEMONSLEEPTIME Number(9,4) DECIMAL(8,4) NOT NULL Daemon Sleep Time
    16 PRCSTHRESHOLD Number(8,0) INTEGER NOT NULL Disk Space Threshold
    17 PRCSDISKSPACE Number(8,0) INTEGER NOT NULL Disk Space Available
    18 SRVRLOADBALOPTN Character(2) VARCHAR2(2) NOT NULL Server Load Balancing Option
    0=Do Not Use for Load Balancing
    1=Use for Load Balancing
    19 MAXCPU Number(3,0) SMALLINT NOT NULL Max. CPU Usage required
    20 MINMEM Number(3,0) SMALLINT NOT NULL Min. Memory Required
    21 OPSYS Character(1) VARCHAR2(1) NOT NULL Operating System
    0=DOS
    1=NT/Win95 Client
    2=Windows
    3=OS/2
    4=UNIX
    5=VMS
    6=MPE/XL
    7=OS390
    8=NT
    9=OS/400