Section 1: user commands and tools
NAME db5.3_recover – Restore the database to a consistent state SYNOPSIS db5.3_recover [-ceVv] [-h home] [-P password] [-t [[CC]YY]MMDDhhmm[.SS]]] DESCRIPTION The db5.3_recover utility must be run after an unexpected application, Berkeley DB, or system failure to restore the database to a consistent state. All committed transactions are guaranteed to appear after db5.3_recover has run, and…
NAME db5.3_printlog – Dumps Berkeley DB log files in a human-readable format SYNOPSIS db5.3_printlog [-NrV] [-b start-LSN] [-e stop-LSN] [-h home] [-P password] DESCRIPTION The db5.3_printlog utility is a debugging utility that dumps Berkeley DB log files in a human-readable format. OPTIONS -b Display log records starting at log sequence number (LSN) start-LSN; start-LSN is…
NAME db_log_verify – Verify log files of a database environment SYNOPSIS db_log_verify [-cNvV] [-h home-to-verify] [-H temporary-home] [-P password] [-C cache-size] [-b start-lsn] [-e end-lsn] [-s start-time] [-z end-time] [-d database-filename] [-D database-name] DESCRIPTION The db_log_verify utility verifies the log files of a specific database environment. This utility verifies a specific range of log records,…
NAME db5.3_load – Load data from standard input SYNOPSIS db5.3_load [-nTV] [-c name=value] [-f file] [-h home] [-P password] [-t btree | hash | queue | recno] file db5.3_load [-r lsn | fileid] [-h home] [-P password] file DESCRIPTION The db5.3_load utility reads from the standard input and loads it into the database file. The…
NAME db5.3_hotbackup – Create "hot backup" or "hot failover" snapshots SYNOPSIS db5.3_hotbackup [-cDuVv] [-d data_dir …] [-h home] [-l log_dir] [-P password] -b backup_dir DESCRIPTION The db5.3_hotbackup utility creates "hot backup" or "hot failover" snapshots of Berkeley DB database environments. The db5.3_hotbackup utility performs the following steps: 1. If the -c option is specified, checkpoint…
NAME db5.3_dump – Write database to flat-text format SYNOPSIS db5.3_dump [-klNpRrV] [-d ahr] [-f output] [-h home] [-P password] [-s database] file DESCRIPTION The db5.3_dump utility reads the database file file and writes it to the standard output using a portable flat-text format understood by the db5.3_load utility. The file argument must be a file…
NAME db5.3_deadlock – Detect and abort deadlocks SYNOPSIS db5.3_deadlock [-Vv] [-a e | m | n | o | W | w | y] [-h home] [-L file] [-t sec.usec] DESCRIPTION The db5.3_deadlock utility traverses the database environment lock region, and aborts a lock request each time it detects a deadlock or a lock request…
Berkeley DB NAME db5.3_codegen – generate application code for Berkeley DB SYNOPSIS [-Vv [-a api ] ] [-i file ] [-o prefix ] DESCRIPTION The utility generates application code to create and configure Berkeley DB database environments and databases based on a simple description language and writes it to one or more output files. The…
NAME db5.3_checkpoint – Periodically checkpoint transactions SYNOPSIS db5.3_checkpoint [-1Vv] [-h home] [-k kbytes] [-L file] [-P password] [-p min] DESCRIPTION The db5.3_checkpoint utility is a daemon process that monitors the database log, and periodically calls DB_ENV->txn_checkpoint to checkpoint it. OPTIONS -1 Checkpoint the log once, regardless of whether or not there has been activity since…
NAME db5.3_archive – Find unused log files for archiving purposes SYNOPSIS db5.3_archive [-adlsVv] [-h home] [-P password] DESCRIPTION The db5.3_archive utility writes the pathnames of log files that are no longer in use (for example, no longer involved in active transactions), to the standard output, one pathname per line. These log files should be written…
db5.3_verify – Verifies the structure databases Synopsis db5.3_verify [-NoqV] [-h home] [-P password] file … Description The db5.3_verify utility verifies the structure of one or more files and the databases they contain. Options -h Specify a home directory for the database environment; by default, the current working directory is used. -o Skip the database checks…
db5.3_upgrade – Upgrade the Berkeley DB version to the current release version. Synopsis db5.3_upgrade [-NsVv] [-h home] [-P password] file … Description The db5.3_upgrade utility upgrades the Berkeley DB version of one or more files and the databases they contain to the current release version. Options -h Specify a home directory for the database environment;…
db5.3_stat – Display statistics for Berkeley DB environments Synopsis db5.3_stat -d file [-fN] [-h home] [-P password] [-s database] db5.3_stat [-cEelmNrtVZ] [-C Aclop] [-h home] [-L A] [-M A] [-R A] [-P password] Description The db5.3_stat utility displays statistics for Berkeley DB environments. Options -C Display internal information about the locking subsystem. (The output from…
db5.3_recover – Restore the database to a consistent state Synopsis db5.3_recover [-ceVv] [-h home] [-P password] [-t [[CC]YY]MMDDhhmm[.SS]]] Description The db5.3_recover utility must be run after an unexpected application, Berkeley DB, or system failure to restore the database to a consistent state. All committed transactions are guaranteed to appear after db5.3_recover has run, and all…
db5.3_printlog – Dumps Berkeley DB log files in a human-readable format Synopsis db5.3_printlog [-NrV] [-b start-LSN] [-e stop-LSN] [-h home] [-P password] Description The db5.3_printlog utility is a debugging utility that dumps Berkeley DB log files in a human-readable format. Options -b Display log records starting at log sequence number (LSN) start-LSN; start-LSN is specified…
db5.3_load – Load data from standard input Synopsis db5.3_load [-nTV] [-c name=value] [-f file] [-h home] [-P password] [-t btree | hash | queue | recno] file db5.3_load [-r lsn | fileid] [-h home] [-P password] file Description The db5.3_load utility reads from the standard input and loads it into the database file. The database…
db5.3_hotbackup – Create "hot backup" or "hot failover" snapshots Synopsis db5.3_hotbackup [-cDuVv] [-d data_dir …] [-h home] [-l log_dir] [-P password] -b backup_dir Description The db5.3_hotbackup utility creates "hot backup" or "hot failover" snapshots of Berkeley DB database environments. The db5.3_hotbackup utility performs the following steps: 1. If the -c option is specified, checkpoint the…
db5.3_dump – Write database to flat-text format Synopsis db5.3_dump [-klNpRrV] [-d ahr] [-f output] [-h home] [-P password] [-s database] file Description The db5.3_dump utility reads the database file file and writes it to the standard output using a portable flat-text format understood by the db5.3_load utility. The file argument must be a file produced…
db5.3_deadlock – Detect and abort deadlocks Synopsis db5.3_deadlock [-Vv] [-a e | m | n | o | W | w | y] [-h home] [-L file] [-t sec.usec] Description The db5.3_deadlock utility traverses the database environment lock region, and aborts a lock request each time it detects a deadlock or a lock request that…
Berkeley DB Name db5.3_codegen – generate application code for Berkeley DB Synopsis [-Vv [-a api ] ] [-i file ] [-o prefix ] Description The utility generates application code to create and configure Berkeley DB database environments and databases based on a simple description language and writes it to one or more output files. The…