Start of Content Area

Object documentation USEOSTIME (Informix)  Locate the document in its SAP Library structure

Definition

The USEOSTIME parameter in the Informix ONCONFIG file lets you specify that the database server is to use subsecond granularity when it obtains the current time from the operating system for SQL statements. If you set USEOSTIME to nonzero, the performance of your system worsens.

Use

For up-to-date recommendations, see SAP Note 41360.

Normally, set this parameter to 0. However, if you want to monitor SQL statements, set it to 1. Only do this for a short period.

For more information, see Checking SQL Statements (Informix).