Dirty Reads mode

This article will not help you to gain advanced knowledge in PS Query but I’m sure it helps you to know something new. Dirty Reads mode also called Read only mode. Enables you to configure your servers to avoid table locking while running your 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. Which will simply read the data’s in data blocks (i.e.) reading the uncommitted data’s also which can be rolled back. Dirty Read mode is set in configuration files for PeopleSoft Application server and PeopleSoft Process scheduler server.

To enable this set Use dirty-read=1 in application server configuration file and process scheduler file.