Understanding Dirty Reads in PeopleSoft Query

Dirty Reads mode—also called Read Only mode—enables you to configure your servers to avoid table locking while running PeopleSoft queries. When Dirty Read mode is enabled for PeopleSoft Query, the performance is increased as queries do not lock on other INSERT and UPDATE operations.

Dirty Read mode is set in configuration files for PeopleSoft Application server and PeopleSoft Process Scheduler server:

• In PeopleSoft Application server, under section [PSQRYSRV], the setting ‘Use dirty-read’ controls behavior for PSAPPSRV, PSQCKSRV, and PSQRYSRV.

• In PeopleSoft Process Scheduler server, under section [PSAESRV], the setting ‘scheduledquery-dirtyread’ controls behavior for scheduled query process executing under PSAESRV process.