NAME dbcolcopylast – create new columns that are copies of prior columns SYNOPSIS dbcolcopylast[-e EMPTY][column…] DESCRIPTION For each COLUMN, create a new column copylast_COLUMN that is the last value for that column—that is, the value of that column from the row before. OPTIONS -e EmptyValue or –empty Specify the value newly created columns get. This…
NAME dbcol – select columns from an Fsdb file SYNOPSIS dbcol [-v] [-e -] [column…] DESCRIPTION Select one or more columns from the input database. If a value is given for empty columns with the -e option, then any named columns which don’t exist will be created. Otherwise, non-existent columns are an error. Note: a…
NAME dbclient – lightweight SSH client SYNOPSIS dbclient [flag arguments] [-p port] [-i id] [-L l:h:p] [-R l:h:p] [-l user] host [more flags] [command] dbclient [args] [user1]@host1[^port1],[user2]@host2[^port2],… DESCRIPTION dbclient is a small SSH client OPTIONS command A command to run on the remote host. This will normally be run by the remote host using the…
NAME 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…
NAME 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…
NAME db_tuner – analyze and tune btree database SYNOPSIS db_tuner [-c cachesize] -d file [-h home] [-s database] [-v] DESCRIPTION The 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…
NAME db_to_html_table – convert db to an HTML table SYNOPSIS db_to_html_table [-g N] <source.fsdb >dest.html DESCRIPTION Covert 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),…
NAME db_to_csv – convert fsdb to the comma-separated-value file-format SYNOPSIS db_to_csv [-C] DESCRIPTION Covert 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…
NAME 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…
NAME db_replicate – Provide replication services SYNOPSIS db_replicate [-MVv] [-h home] [-L file] [-P password] [-T num-threads] [-t secs] DESCRIPTION The 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…
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…