# DB_ENV->set_tx_timestamp

`

###

    #include <db.h>

    int
    DB_ENV->set_tx_timestamp(DB_ENV *dbenv, time_t *timestamp);

# Description

Recover to the time specified by timestamp rather than to the most current possible date. The timestamp argument should be the number of seconds since 0 hours, 0 minutes, 0 seconds, January 1, 1970, Coordinated Universal Time; that is, the Epoch.

Once a database environment has been upgraded to a new version of Berkeley DB involving a log format change (see Upgrading Berkeley DB installations), it is no longer possible to recover to a specific time before that upgrade.

The DB_ENV->set_tx_timestamp interface may be used only to configure Berkeley DB before the DB_ENV->open interface is called.

The DB_ENV->set_tx_timestamp function returns a non-zero error value on failure and 0 on success.

# Errors

The DB_ENV->set_tx_timestamp function may fail and return a non-zero error for the following conditions:

EINVAL
  An invalid flag value or parameter was specified.

  It is not possible to recover to the specified time using the log files currently present in the environment.

The DB_ENV->set_tx_timestamp function may fail and return a non-zero error for errors specified for other Berkeley DB and C library or system functions. If a catastrophic error has occurred, the DB_ENV->set_tx_timestamp function may fail and return DB_RUNRECOVERY, in which case all subsequent Berkeley DB calls will fail in the same way.

# See Also

DB_ENV->set_tx_max, DB_ENV->set_tx_recover, DB_ENV->set_tx_timestamp, txn_abort, txn_begin, txn_checkpoint, txn_commit, txn_discard, txn_id, txn_prepare, txn_recover, and txn_stat.`

Copyright Sleepycat Software