PSPMSYSDEFAULTS

(SQL Table)
Index Back

System Defaults

Performance monitor system default table. Holds values to be used when creating new systems.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTPHONYKEY Number(3,0) SMALLINT NOT NULL Key Field for ADS definition
2 PM_SELPROF_ITER Number(9,0) DECIMAL(9) NOT NULL Selective Profiling Iteration
3 PM_BUFF_INT Number(4,0) SMALLINT NOT NULL Agent Buffering Interval (sec)
4 PM_UM_BUFFERSIZE Number(6,0) INTEGER NOT NULL Buffer Size
5 USEMON_SW Number(3,0) SMALLINT NOT NULL Enable Usage Monitoring

Default Value: 0

6 PM_MAX_BUFF Number(9,0) DECIMAL(9) NOT NULL Agent Max Buffer Size (bytes)
7 PM_SAMPLE_INT Number(4,0) SMALLINT NOT NULL Agent Event Sample Rate (sec)
8 PM_PING_INT Number(4,0) SMALLINT NOT NULL Agent Heartbeat Interval (sec)
9 PM_MAX_HIST_AGE Number(4,0) SMALLINT NOT NULL Retention period (days)
10 PM_ARCHIVE_MODE Character(1) VARCHAR2(1) NOT NULL Archive Mode
0=Archive Nothing
1=Archive Data
2=Delete Data
3=Delete System

Default Value: 0

11 PM_MAX_TRANS_TMOUT Number(4,0) SMALLINT NOT NULL PMU Timeout (days)
12 PM_USER_TRACE Character(1) VARCHAR2(1) NOT NULL Allow Performance Trace

Y/N Table Edit

Default Value: N

13 PM_SAMPLING_RATE Number(5,0) INTEGER NOT NULL Agent PMU Sample Rate (1/X)
14 PM_FILTER_LEVEL2 Character(2) VARCHAR2(2) NOT NULL Reset All Filters
01=01-Standby
02=02-Error
03=03-Warning
04=04-Standard
05=05-Verbose
06=06-Debug
15 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.
16 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.