Section 1: user commands and tools
NAME dbjoin – join two tables on common columns SYNOPSIS dbjoin[-Sid]– input table1.fsdb– input table2.fsdb[-nNrR] column[column…] OR cat table1.fsdb | dbjoin[-Sid]– input table2.fsdb[-nNrR] column[column…] DESCRIPTION Does a natural, inner join on TABLE1 and TABLE2 the specified columns. With the "-a" option, or with "-t outer" it will do a natural, full outer join. (Database review:…
NAME dbiproxy – A proxy server for the DBD::Proxy driver SYNOPSIS dbiproxy <options> –localport=<port> DESCRIPTION This tool is just a front end for the DBI::ProxyServer package. All it does is picking options from the command line and calling DBI::ProxyServer::main(). See DBI::ProxyServer for details. Available options include: –chroot=dir (UNIX only) After doing a bind(), change root…
NAME dbiprof – command-line client for DBI::ProfileData SYNOPSIS See a report of the ten queries with the longest total runtime in the profile dump file prof1.out: dbiprof prof1.out See the top 10 most frequently run queries in the profile file dbi.prof (the default): dbiprof –sort count See the same report with 15 entries: dbiprof –sort…
NAME dbilogstrip – filter to normalize DBI trace logs for diff’ing SYNOPSIS Read DBI trace file "dbitrace.log" and write out a stripped version to "dbitrace_stripped.log" dbilogstrip dbitrace.log > dbitrace_stripped.log Run "yourscript.pl" twice, each with different sets of arguments, with DBI_TRACE enabled. Filter the output and trace through "dbilogstrip" into a separate file for each run….
dbgen.pl – Random LDIF database creator Synopsis dbgen.pl [OPTIONS] -o output_file -n number Description Random LDIF database creator. Used to generate large LDIF files for use in testing the Directory Server. Options A summary of options is included below: -v Verbose output -q Quiet output -s suffix LDAP suffix. Default is ‘dc=example,dc=com’ -c CN naming…
NAME dbgen.pl – Random LDIF database creator SYNOPSIS dbgen.pl [OPTIONS] -o output_file -n number DESCRIPTION Random LDIF database creator. Used to generate large LDIF files for use in testing the Directory Server. OPTIONS A summary of options is included below: -v Verbose output -q Quiet output -s suffix LDAP suffix. Default is ‘dc=example,dc=com’ -c CN…
NAME dbformmail – write a shell script that will send e-mail to many people SYNOPSIS dbformmail [-m MECHANISM] format_file.txt DESCRIPTION Read a “form mail” message from the file FORMAT_FILE.TXT, filling in underscore-preceded column-names with data. Output a shell script which will send each message through some mail transport MECHANISM. Do not use this program for…
NAME dbfilevalidate – insure the source input is a well-formed Fsdb file SYNOPSIS dbfilevalidate [-vc] DESCRIPTION Validates the input file to make sure it is a well-formed fsdb file. If the file is well-formed, it outputs the whole file and exits with a good exit code. For invalid files, it exits with an error exit…
NAME dbfilestripcomments – remove comments from a fsdb file SYNOPSIS dbfilestripcomments [-h] DESCRIPTION Remove any comments in a file, including the header. This makes the file unreadable by other Fsdb utilities, but perhaps more readable by humans. With the -h option, leave the header. OPTIONS -h or –header Retain the header. This module also supports…
NAME dbfilepivot – pivot a table, converting multiple rows into single wide row SYNOPSIS dbfilepivot [-e empty] -k KeyField -p PivotField [-v ValueField] DESCRIPTION Pivot a table, converting multiple rows corresponding to the same key into a single wide row. In a normalized database, one might have data with a schema like (id, attribute, value),…
NAME dbfilediff – compare two fsdb tables SYNOPSIS dbfilediff[-Eq][-N diff_column_name]– input table1.fsdb– input table2.fsdb OR cat table1.fsdb | dbfilediff [-sq] –input table2.fsdb DESCRIPTION Dbfilediff compares two Fsdb tables, row by row. Unlike Unix diff(1), this program assumes the files are identical line-by-line and we compare fields. Thus, insertion of one extra row will result in…
NAME dbfilecat – concatenate two files with identical schema SYNOPSIS dbfilecat– input A.fsdb[–input B.fsdb…] or echo A.fsdb | dbfilecat –xargs DESCRIPTION Concatenate all provided input files, producing one result. We remove extra header lines. Inputs can both be specified with "–input", or one can come from standard input and the other from "–input". With "–xargs",…
NAME dbfilealter – alter the format of an Fsdb file, changing the row/column separator SYNOPSIS dbfilealter [-c] [-F fs] [-R rs] [-Z compression] [column…] DESCRIPTION This program reformats a Fsdb file, altering the row ("-R rs") or column ("-F fs") separator. It verifies that this action does not violate the file constraints (for example, if…
dbfdump.pl – Dump the record of the dbf file Format dbfdump.pl [options] files where options are –rs output record separator (default newline) –fs output field separator (default colon) –fields comma separated list of fields to print (default all) –undef string to print for NULL values (default empty) –memofile specifies unstandard name of attached memo file…
NAME dbench – Measure disk throughput for simulated netbench run SYNOPSIS dbench [options]numclients tbench [options]numclientsserver tbench_srv [options] DESCRIPTION This manual page documents briefly the dbench and tbench benchmarks. This manual page was written for the Debian GNU/Linux distribution because the original program does not have a manual page. However, it has fairly easy to read…
NAME dbcolstatscores – compute z-scores or t-scores for each value in a population SYNOPSIS dbcolstatscores [-t] [–tmean=MEAN] [–tstddev=STDDEV] column DESCRIPTION Compute statistics (z-score and optionally t-score) over a COLUMN of numbers. Creates new columns called “zscore”, “tscore”. T-scores are only computed if requested with the "-t" option, or if "–tmean" or "–tstddev" are explicitly specified…
NAME dbcolstats – compute statistics on a fsdb column SYNOPSIS dbcolstats [-amS] [-c ConfidenceFraction] [-q NumberOfQuantiles] column DESCRIPTION Compute statistics over a COLUMN of data. Records containing non-numeric data are considered null do not contribute to the stats (with the "-a" option they are treated as zeros). Confidence intervals are a t-test (+/- (t_{a/2})*s/sqrt(n)) and…
NAME dbcolsregression – compute linear regression between two columns SYNOPSIS dbcolsregression [-a] column1 column2 DESCRIPTION Compute linear regression over "column1" and "column2". Outputs slope, intercept, and correlation coefficient. OPTIONS -a or –include-non-numeric Compute stats over all records (treat non-numeric records as zero rather than just ignoring them). -f FORMAT or –format FORMAT Specify a printf(3)-style…
NAME dbcolsplittorows – split an existing column into multiple new rows SYNOPSIS dbcolsplittorows [-C ElementSeperator] [-e null] [-E] [-N enumerated-name] column [column…] DESCRIPTION Split column into pieces, outputting one row for each piece. By default, any empty fields are ignored. If an empty field value is given with -e, then they produce output. When a…
NAME dbcolsplittocols – split an existing column into multiple new columns SYNOPSIS dbcolsplittocols [-E] [-C ElementSeparator] column [column…] DESCRIPTION Create new columns by splitting an existing column. The fragments of the column are each divided by ElementSeparator (default is underscore). This command is the opposite of dbcolmerge. Names of the new columns are given by…