Section 1: user commands and tools
NAME dbsort – sort rows based on the the specified columns SYNOPSIS dbsort[-M MemLimit][-T TemporaryDirectory][-nNrR] column[column…] DESCRIPTION Sort all input rows as specified by the numeric or lexical columns. Dbsort consumes a fixed amount of memory regardless of input size. (It reverts to temporary files on disk if necessary, based on the -M and -T…
NAME dbsessmgr – session state database manager SYNOPSIS mono dbsessmgr.exe [options] DESCRIPTION dbsessmgr allows you to manage the ASP.NET session state database. OPTIONS –clean Remove all expired sessions. –remove Delete all sessions. –show Display session data. CONFIGURATION You can choose the assembly and type used to connect to your database backend and also set the…
NAME dbscan – scans a Directory Server database index file and dumps the contents SYNOPSIS dbscan -f <filename> [-R] [-t <size>] [-K <entry_id>] [-k <key>] [-l <size>] [-G <n>] [-n] [-r] [-s] DESCRIPTION Scans a Directory Server database index file and dumps the contents. OPTIONS A summary of options is included below: -f <filename> specify…
NAME dbrvstatdiff – evaluate statistical differences between two random variables SYNOPSIS dbrvstatdiff[-f format][-c ConfRating] [-h HypothesizedDifference] m1c sd1c n1c m2c sd2c n2c OR dbrvstatdiff[-f format][-c ConfRating] m1c n1c m2c n2c DESCRIPTION Produce statistics on the difference of sets of random variables. If a hypothesized difference is given (with "-h"), to does a Student’s t-test. Random…
NAME dbrowuniq – eliminate adjacent rows with duplicate fields, maybe counting SYNOPSIS dbrowuniq [-cFLB] [uniquifying fields…] DESCRIPTION Eliminate adjacent rows with duplicate fields, perhaps counting them. Roughly equivalent to the Unix uniq command, but optionally only operating on the specified fields. By default, all columns must be unique. If column names are specified, only those…
NAME dbroweval – evaluate code for each row of a fsdb file SYNOPSIS dbroweval[-f CodeFile] code[code…] DESCRIPTION Evaluate code for each row of the data. Typical actions are things like reformatting and other data transformations. Code can include embedded column names preceded by underscores; these result in the value of that column for the current…
NAME dbrowenumerate – enumerate rows, starting from zero SYNOPSIS dbrowenumerate DESCRIPTION Add a new column “count”, incremented for each row of data, starting with zero. Use dbrowaccumulate for control over initial value or increment; this module is just a wrapper around that. OPTIONS -N or –new-name N Name the new column N. Defaults to "count"….
NAME dbrowdiff – compute row-by-row differences of some column SYNOPSIS dbrowdiff [-B|-I] column DESCRIPTION For a given column, compute the differences between each row of the table. Differences are output to two new columns, "absdiff" and "pctdiff". Differences are either relative to the previous column (incremental mode), or relative to the first row (baseline mode),…
NAME dbrowcount – count the number of rows in an Fsdb stream SYNOPSIS dbrowcount DESCRIPTION Count the number of rows and write out a new fsdb file with one column (n) and one value: the number of rows. This program is a strict subset of dbcolstats. Although there are other ways to get a count…
NAME dbrowaccumulate – compute a running sum of a column SYNOPSIS dbrowaccumulate [-C increment_constant] [-I initial_value] [-c increment_column] [-N new_column_name] DESCRIPTION Compute a running sum over a column of data, or of a constant incremented per row, perhaps to generate a cumulative distribution. What to accumulate is specified by "-c" or "-C". The new column…
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…