PSPMSYSDEFN

 index back

System identifiers.

Performance monitor system identifier table.

  • Related language record: PSPMSYSDEFN_LNG

    • PeopleSoft Field Name Field Type Column Type Description
    PM_SYSTEMID Number(5,0) INTEGER NOT NULL Performance Monitor System Identifier.
    DBNAME Character(8) VARCHAR2(8) NOT NULL Database Name
    DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    PM_BUFF_INT Number(4,0) SMALLINT NOT NULL Agent Buffering Interval (sec)
    PM_MAX_BUFF Number(9,0) DECIMAL(9) NOT NULL Agent Max Buffer Size (bytes)
    PM_SAMPLE_INT Number(4,0) SMALLINT NOT NULL Agent Event Sample Rate (sec)
    PM_PING_INT Number(4,0) SMALLINT NOT NULL Agent Heartbeat Interval (sec)
    PM_MAX_HIST_AGE Number(4,0) SMALLINT NOT NULL Retention period (days)
    PM_ARCHIVE_MODE Character(1) VARCHAR2(1) NOT NULL Archive Mode
    0=Archive Nothing
    1=Archive Data
    2=Delete Data
    3=Delete System

    Default: 0

    PM_MAX_TRANS_TMOUT Number(4,0) SMALLINT NOT NULL PMU Timeout (days)
    GUID Character(36) VARCHAR2(36) NOT NULL Unique Identifier
    PM_USER_TRACE Character(1) VARCHAR2(1) NOT NULL Allow Performance Trace

    Y/N Table Edit

    Default: N

    PM_SAMPLING_RATE Number(5,0) INTEGER NOT NULL Agent PMU Sample Rate (1/X)
    PM_FILTER_LEVEL3 Character(2) VARCHAR2(2) NOT NULL Sample Filter Override
    00=00-No Change
    01=01-Standby
    04=04-Standard
    05=05-Verbose
    06=06-Debug

    Default: 00

    LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    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.
    PM_THRESHOLD Number(9,0) DECIMAL(9) NOT NULL Notification Threshold (sec)
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20