db5.3_upgrade – Upgrade the Berkeley DB version to the current release version. Synopsisdb5.3_upgrade [-NsVv] [-h home] [-P password] file … DescriptionThe 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; by default, the…
db_tuner – analyze and tune btree database Synopsisdb_tuner [-c cachesize] -d file [-h home] [-s database] [-v] DescriptionThe db_tuner utility analyzes the data in a btree database, and suggests a page size that is likely to deliver optimal operation. Options-c cachesize Specify a value of the cachesize, otherwise, the default value will be set. -d…
db_to_html_table – convert db to an HTML table Synopsis db_to_html_table [-g N] <source.fsdb >dest.htmlDescriptionCovert an existing dbtable to an HTML table. The output is a fragment of an HTML page; we assume the user fills in the rest (head and body, etc.). Input is fsdb format. Output is HTML code (not fsdb), with HTML-specific characters…
db_to_csv – convert fsdb to the comma-separated-value file-format Synopsis db_to_csv [-C]DescriptionCovert an existing fsdb file to comma-separated value format. Input is fsdb format. Output is CSV-format plain text (not fsdb). Options-C or <–omit-comments> Also strip all comments. This module also supports the standard fsdb options: -d Enable debugging output. -i or –input InputSource Read from…
db5.3_stat – Display statistics for Berkeley DB environments Synopsisdb5.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] DescriptionThe db5.3_stat utility displays statistics for Berkeley DB environments. Options-C Display internal information about the locking subsystem. (The output from this option is…
db_replicate – Provide replication services Synopsisdb_replicate [-MVv] [-h home] [-L file] [-P password] [-T num-threads] [-t secs] DescriptionThe db_replicate utility is a daemon process that provides replication/HA services on a transactional environment. This utility enables you to upgrade an existing Transactional Data Store application to an HA application with minor modifications. Options-h home Specify a…
db5.3_recover – Restore the database to a consistent state Synopsisdb5.3_recover [-ceVv] [-h home] [-P password] [-t [[CC]YY]MMDDhhmm[.SS]]] DescriptionThe 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 uncommitted transactions…
db5.3_printlog – Dumps Berkeley DB log files in a human-readable format Synopsisdb5.3_printlog [-NrV] [-b start-LSN] [-e stop-LSN] [-h home] [-P password] DescriptionThe 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 as a file…
db_log_verify – Verify log files of a database environment Synopsisdb_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] DescriptionThe db_log_verify utility verifies the log files of a specific database environment. This utility verifies a specific range of log records, or changed log…
db5.3_load – Load data from standard input Synopsisdb5.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 DescriptionThe db5.3_load utility reads from the standard input and loads it into the database file. The database file is…
db5.3_hotbackup – Create "hot backup" or "hot failover" snapshots Synopsisdb5.3_hotbackup [-cDuVv] [-d data_dir …] [-h home] [-l log_dir] [-P password] -b backup_dir DescriptionThe 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 source home…
db5.3_dump – Write database to flat-text format Synopsisdb5.3_dump [-klNpRrV] [-d ahr] [-f output] [-h home] [-P password] [-s database] file DescriptionThe 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 using the…
db5.3_deadlock – Detect and abort deadlocks Synopsisdb5.3_deadlock [-Vv] [-a e | m | n | o | W | w | y] [-h home] [-L file] [-t sec.usec] DescriptionThe 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 has timed…
Berkeley DB Namedb5.3_codegen – generate application code for Berkeley DB Synopsis[-Vv [-a api ] ] [-i file ] [-o prefix ] DescriptionThe 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 generated code may…
db5.3_checkpoint – Periodically checkpoint transactions Synopsisdb5.3_checkpoint [-1Vv] [-h home] [-k kbytes] [-L file] [-P password] [-p min] DescriptionThe 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 the last checkpoint and…
db5.3_archive – Find unused log files for archiving purposes Synopsisdb5.3_archive [-adlsVv] [-h home] [-P password] DescriptionThe 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 to backup media…
db5.3_verify – Verifies the structure databases Synopsisdb5.3_verify [-NoqV] [-h home] [-P password] file … DescriptionThe 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 for btree and…
db5.3_upgrade – Upgrade the Berkeley DB version to the current release version. Synopsisdb5.3_upgrade [-NsVv] [-h home] [-P password] file … DescriptionThe 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; by default, the…
db5.3_stat – Display statistics for Berkeley DB environments Synopsisdb5.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] DescriptionThe db5.3_stat utility displays statistics for Berkeley DB environments. Options-C Display internal information about the locking subsystem. (The output from this option is…
db5.3_recover – Restore the database to a consistent state Synopsisdb5.3_recover [-ceVv] [-h home] [-P password] [-t [[CC]YY]MMDDhhmm[.SS]]] DescriptionThe 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 uncommitted transactions…