Try OpenEdge Now
skip to main content
Database Administration
Reference : PROUTIL Utility : PROUTIL DBANALYS qualifier : Database analysis output : Output file format
 
Output file format
By default, the text files contain lines of output, where each column is delimited by a space (ASCII character 0x20). Character values are quoted (“”) and numeric values represent the number of bytes and are raw numbers. You can modify the separator by specifying an alternative with the -fieldsep parameter, as shown:
proutil db-name -C dbanalys -csoutput -fieldsep sep-value
Acceptable values for sep-value are:
*Any ASCII character between 0x21 and 0x7E
*sp — to denote a space (the default)
*tab — to denote a the TAB character (<\t> or ASCII character 0x09)
By default, the text files contain only data. If you want to add column headings, you can add the parameter -verbose to the command line, as shown:
proutil db-name -C dbanalys -csoutput -verbose
The resulting output file contains column headings in the first line.
The contents of the files are described in the following table.
Table 95. Text file contents for -csoutput
File type
Column header
Chain (dbname.ch.txt)
Time Stamp
DBUID
DB name
Area
Area #
Partition Type
Tenancy
Tenancy #
Partition
Partition #
Object type
Owner
Object
Object #
Chain Type
Num Blocks
Index (dbname.ix.txt)
Time Stamp
DBUID
DB name
Area
Area #
Partition Type
Tenancy
Tenancy #
Partition
Partition #
Owner
Table
Table #
Index
Index #
Fields
Levels
Blocks
Size
Utilization
Factor
Table (dbname.tab.txt)
Time Stamp
DBUID
DB name
Area
Area #
Partition Type
Tenancy
Tenancy #
Partition
Partition #
Owner
Table
Table #
Records
Size
Min
Max
Mean
Frag Count
Frag Factor
Scatter Factor
LOB (dbname.lob.txt)
Time Stamp
DBUID
DB name
Area
Area #
Partition Type
Tenancy
Tenancy #
Partition Policy
Partition
Partition #
Owner
Table
LOB Obj #
LOBs
Size
Min
Max
Mean
Block (dbname.block.txt)
Time Stamp
DBUID
DB name
Area
Area #
Block Type
Num Blocks
Additional information to note about the contents of the text files:
*Totals are not reported
*The time stamp of each row is identical, indicating that each row came from a single run of the analysis
*The DBUID is provided to identify rows if the output from multiple sources is loaded into a trending database
*The CHANALYS output does NOT contain the dbkey information, it only include the chain analysis summary information as in the dbanalys report.