Database analysis output
- Last Updated: August 17, 2026
- 1 minute read
- OpenEdge
- Version 13.1
- Documentation
Database analysis output
The output of the database analysis tools, DBANALYS,
IDXANALYS, CHANALYS,
LOBANALYS, and TABANALYS, can be exported to a set of
text files, in addition to the tabular reports output to the screen. You can easily import
these files to an OpenEdge database or spreadsheet for analysis and trending. Use command line
parameters to configure the text file names and content layout.
To create the text files, add the parameter -csoutput to
the command line, as shown:
|
The result is that the following files are created:
-
dbname
.ch.txt— For chain analysis output -
dbname
.ix.txt— For index analysis output -
dbname.
tab.txt— For table analysis output -
dbname
.block.txt— For block analysis output - dbname
.lob.txt— For LOB analysis output
DBANALYS produces all five text files; the remaining tools
produce the text file(s) specific to the command plus the block file.
If you restrict the analysis to a specific area with the use of the area parameter on the PROUTIL command line, the
file names are altered to include the area number before the final ”.txt” extension, dbname.blockarea#.txt. Any existing file is overwritten.
You can substitute the dbname prefix of the
file name by specifying the -csfilePrefix parameter,
and supply a different value. For example, if you wanted to add
a date to the file name prefix, you could enter:
|
and the following files are created:
- proddb_sep01
.ch.txt - proddb_sep01
.ix.txt - proddb_sep01.
tab.txt - proddb_sep01
.block.txt - proddb_sep01
.lob.txt