NAME dbrow – select rows from an Fsdb file based on arbitrary conditions SYNOPSIS dbrow [-vw] CONDITION [CONDITION…] DESCRIPTION Select rows for which all CONDITIONS are true. Conditions are specified as Perl code, in which column names are be embedded, preceded by underscores. OPTIONS -v Invert the selection, picking rows where at least one condition…
NAME dbrecolize – DEPRICATED, now use dbfilealter Index
NAME dbprobe – database response time and availability information SYNOPSIS dbprobe.pl [delay] DESCRIPTION The dbprobe utility is used by pmdadbping(1) to measure response time from a database. A given query is executed on the database at the requested interval (delay, which defaults to 60 seconds). This response time measure can be exported via the Performance…
NAME dbpmda – debugger for Performance Co-Pilot PMDAs SYNOPSIS dbpmda [-efi] [-n pmnsfile] [-q timeout] [-U username] DESCRIPTION dbpmda is an interactive interface to the interactions between a Performance Metric Domain Agent (PMDA(3)) and the Performance Metric Collector Daemon (pmcd(1)). This allows PMDAs to be attached, initialized and exercised to test for correctness. dbpmda interactively…
NAME dbmultistats – run dbcolstats over each group of inputs identified by some key SYNOPSIS $0 [-dm] [-c ConfidencePercent] [-f FormatForm] [-q NumberOfQuartiles] -k KeyField ValueField DESCRIPTION The input table is grouped by KeyField, then we compute a separate set of column statistics on ValueField for each group with a unique key. Assumptions and requirements…
NAME dbmerge2 – merge exactly two inputs in sorted order based on the the specified columns SYNOPSIS dbmerge2– input A.fsdb– input B.fsdb[-T TemporaryDirectory][-nNrR] column[column…] or cat A.fsdb | dbmerge2 –input B.fsdb [-T TemporaryDirectory] [-nNrR] column [column…] DESCRIPTION Merge exactly two sorted input files, producing one sorted result. Inputs can both be specified with "–input", or one can come from…
NAME dbmerge – merge all inputs in sorted order based on the the specified columns SYNOPSIS dbmerge– input A.fsdb– input B.fsdb[-T TemporaryDirectory][-nNrR] column[column…] or cat A.fsdb | dbmerge –input – –input B.fsdb [-T TemporaryDirectory] [-nNrR] column [column…] or dbmerge [-T TemporaryDirectory] [-nNrR] column [column…] –inputs A.fsdb [B.fsdb …] DESCRIPTION Merge all provided, pre-sorted input files, producing one sorted result. Inputs can both be specified with…
NAME dbmapreduce – reduce all input rows with the same key SYNOPSIS dbmapreduce[-dMS][-k KeyField][-f CodeFile][-C Filtercode][–][ReduceCommand[ReduceArguments…]] DESCRIPTION Group input data by KeyField, then apply a function (the “reducer”) to each group. The reduce function can be an external program given by ReduceCommand and ReduceArguments, or an Perl subroutine given in CodeFile or FilterCode. If a…
NAME dblistize – DEPRICATED, now use dbfilealter Index
NAME dblatex – convert DocBook to LaTeX, DVI, PostScript, and PDF SYNOPSIS dblatex [options] {file | -} DESCRIPTION This manual page briefly documents the dblatex command. For more details read the PDF manual; see below. dblatex is a program that transforms your SGML/XML DocBook documents to DVI, PostScript or PDF by translating them into pure LaTeX…
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 Synopsisdbgen.pl [OPTIONS] -o output_file -n number DescriptionRandom LDIF database creator. Used to generate large LDIF files for use in testing the Directory Server. OptionsA 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 style Naming style…
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),…