PSPMSYSDEFAULTS(SQL Table) |
Index Back |
---|---|
System DefaultsPerformance 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. |