Hierarchy of PI SQL Subsystem settings

Since it is possible to set parameters using more than one technique, some of the settings may be in conflict. The actual value of the settings employed follows this priority scheme:

• Initialization file settings

• PI SQL Subsystem (pisqlss) command-line arguments

• Client product settings

Settings made lower in the list override settings higher up. For example, if the SQL query timeout is set to 45 seconds in the initialization file and to 60 seconds on the pisqlss command-line, the value used is 60 seconds.