IBM Books

Maximum Time Difference Among Nodes (max_time_diff)

Configuration Type
Database manager

Applies To
Partitioned Database Server with local and remote clients

Parameter Type
Configurable

Default [Range]
60 [1-1 440]

Unit of Measure
Minutes

Each database partition server has its own system clock. This parameter specifies the maximum time difference, in minutes, that is permitted among the database partition servers listed in the db2nodes.cfg file.

If two or more database partition servers are associated with a transaction and their clocks are not synchronized to within the time specified by this parameter, the transaction is rejected and a warning or an error message is logged in the db2diag.log file. (The transaction is rejected only if data modification is associated with it.)

DB2 Universal Database Extended Enterprise Edition uses Coordinated Universal Time, (UTC) so different time zones are not a consideration when you set this parameter. The Coordinated Universal Time is the same as Greenwich Mean Time.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]