Submitting your feedback...
Knowledge Base Article
3166OSI8 - How to edit the Timeout table or tuning parameters in PI
Product: PI Data Archive
Version(s): 3.4.370.76 and later
 

Issue

How to edit the Timeout Table (Timeout Database) or tuning parameters in PI.

Solution

The Timeout table contains the PI Data Archive timing parameters as well as many other tuning parameters. Adjustment of these parameters should be done by the PI Data Archive Administrator.

You can modify timeout parameters using PI SMT Tuning Parameters plug-in or piconfig. It is possible to edit these parameters remotely if using the PI SMT 3 host plug-in with "piadmin" access (through a login or trust). 

Note that many changes require restarting the PI Data Archive or the related subsystem on the PI Data Archive in order to take effect. If you are editing the table remotely using PI SMT3, you can use the Operation > PI Services plug-in in PI SMT to restart the PI Data Archive or any subsystem. If you are on the PI Data Archive, you can use the Administrative Tools > Services console, or 'net stop ' and 'net start ' commands.

To edit the Timeout table using PI SMT 3:

You must have piadmin rights and be running PI 3.4.363.60 or later on Windows or UNIX in order to edit the Timeout table with PI SMT. If you have an earlier version of PI, you must use piconfig to edit the table (see instructions below).
  1. Click Start > All Programs > PI System > PI System Management Tools.
  2. Select the PI Data Archive.
  3. Open the Operation>Tuning Parameters (or PI Timeout Table Editor tree if running earlier versions of PI SMT3).
  4. Select the tab which contains the parameter you want to edit. 
  5. Right-Click on the parameter you want to edit, and select "Edit...".
    NOTE: If you do not see the name of the parameter you are looking for in the Name list, you can add it by clicking on the blank page icon. Due to the large number of tuning parameters, only the most common parameters are presented, so you may need to add it first in order to edit it. (See Notes for where to find a list of parameters).
  6. Enter the desired value and click OK.
  7. In many cases, you will need to stop and re-start the PI Data Archive or the subsystem associated with that parameter for it to take effect. You can use the Operation > PI Services SMT plug-in to do this remotely.

To edit the Timeout Table using piconfig:

  1. Open a command window by clicking "Start...Run" and type "cmd" and press Enter.
  2. Change to the pi\adm directory.
  3. Type "piconfig" and press Enter.
  4. Type the following commands, pressing Enter after each line, substituting the parameter name (such as, "Archive_ShiftRatio") and value ("102") with those you want to change:
    @table pi_gen, pitimeout
    @mode create, t
    @istru name, value
    Archive_ShiftRatio, 102
    @ends
    @exit
    
  5. In many cases, you will need to stop and re-start the PI Data Archive or the subsystem associated with that parameter for it to take effect. See documentation for whether the read is "on startup" or it's picked up automatically.

Notes

Documentation: In the PI Server Reference Guide v3.4.370 pg. 25-36 there is a Timeout Database table of configurable parameters, their descriptions, default values, which subsystem they affect, and when the parameter is "read" ("on startup" indicates that subsystem needs to be restarted for the new parameter to be read). If the subsystem is the PI Network Manager, you should restart the whole PI Data Archive. Other chapters in the PI Server System Management Guide describe individual parameters in more detail. 
Article ID: 3166OSI8 Created: 2005-12-07
Article Type: How-To Last Updated: 2017-01-31