dbcolhisto – compute a histogram over a column of Fsdb data Synopsisdbcolhisto [-ag] [-W BucketWidth] [-S BucketStart] [-E BucketEnd] [-N NumberOfBuckets] column DescriptionThis program computes a histogram over a column of data. Records containing non-numeric data are considered null do not contribute to the stats (optionally they are treated as zeros). Defaults to 10 buckets…
dbcoldefine – define the columns of a plain text file to make it an Fsdb file Synopsisdbcoldefine [-F x] [column…] DescriptionThis program writes a new header before the data with the specified column names. It does not do any validation of the data contents; it is up to the user to verify that, other than…
dbcolcreate – create new columns Synopsis dbcolcreate NewColumn1 [NewColumn2]or dbcolcreate -e DefaultValue NewColumnWithDefaultDescriptionCreate columns "NewColumn1", etc. with an optional "DefaultValue". Options-e EmptyValue or –empty Specify the value newly created columns get. -f or –first Put all new columns as the first columns of each row. By default, they go at the end of each row….
dbcolcopylast – create new columns that are copies of prior columns Synopsis dbcolcopylast [-e EMPTY] [column…]DescriptionFor 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 module also…
dbcol – select columns from an Fsdb file Synopsisdbcol [-v] [-e -] [column…] DescriptionSelect 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 safer way to…
dbclient – lightweight SSH client Synopsisdbclient [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],… Descriptiondbclient 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 user’s shell. The…
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…
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…