NAME dbcolmovingstats – compute moving statistics over a window of a column of data SYNOPSIS dbcolmovingstats [-am] [-w window-width] [-e EmptyValue] column DESCRIPTION Compute moving statistics 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 with "-a"). Currently we compute…
NAME dbcolmerge – merge multiple columns into one SYNOPSIS dbcolmerge [-C ElementSeparator] [columns…] DESCRIPTION For each row, merge multiple columns down to a single column, joining elements with ElementSeparator (defaults to a single underscore). OPTIONS -C S or –element-separator S Specify the separator used to join columns. (Defaults to a single underscore.) -e E or…
NAME dbcolize – DEPRICATED, now use dbfilealter Index
NAME dbcolhisto – compute a histogram over a column of Fsdb data SYNOPSIS dbcolhisto [-ag] [-W BucketWidth] [-S BucketStart] [-E BucketEnd] [-N NumberOfBuckets] column DESCRIPTION This 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…
NAME dbcoldefine – define the columns of a plain text file to make it an Fsdb file SYNOPSIS dbcoldefine [-F x] [column…] DESCRIPTION This 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…
NAME dbcolcreate – create new columns SYNOPSIS dbcolcreate NewColumn1 [NewColumn2] or dbcolcreate -e DefaultValue NewColumnWithDefault DESCRIPTION Create 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…
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…