Administration Guide > Utilities > AE DB Reporting Tool > Creating Evaluation Reports

Creating Evaluation Reports

The utility creates reports in batch mode.

It can be called from the command line by using the following parameters:

UCYBDBRT -Xquery file [-Cclient -IINI file-Llanguage -Rreference date -S-Ooutput file-Tfile type]

All parameters are optional, except for the query file. A list of all values and a description is provided in the document that describes the start parameters.

In batch mode, this utility reads the information for the evaluation report directly from the AE databaseA database is an organized collection of data including relevant data structures.. You can specify the parameters for the database in the corresponding configurationA set of constituent components that make up a system. This includes information on how the components are connected including the settings applied. file UCYBDBRT.ini.

The following line shows an example. An evaluation report is created from the query defined for client 100 in the file jobtop10.d.xml.

UCYBDBRT -C0100 -XC:\AUTOMIC\Utilities\evaluation_reports\jobtop10.d.xml

The information that is provided in the report depends on the fields defined in your query. The fields shown below are available:

Field	Description	Definition	Forecast	Statistic
Archive 1	First archive key.
Archive 2	Second archive key.
Calendar in the workflow	Name of the workflow's Calendar object.
Calendar in the schedule	Name of the superordinate Schedule's Calendar object.
Calendar keyword in the workflow	Name of the calendar keyword in the workflow.
Calendar keyword in the schedule	Name of the superordinate schedule's calendar keyword.
Changed by	Name of the User object.
Changed on	Date of last object modification. Format: YYYY-MM-DD [HH:[MM:[SS]]]
Created by	Name of the User object.
Earliest start time	Earliest start time in the format YYYY.MM.DD HH:MM:SS.
End time	End time in the format HH:MM:SS.
Expected end	Expected end time in the format YYYY.MM.DD HH:MM:SS.
Expected runtime	Expected runtime in seconds.
Expected start time	Expected start time in the format YYYY.MM.DD HH:MM:SS.
Host	Name of the agent in jobs.
Host type	Job type. Allowed values: "BS2000", "GCOS8", "JMX", "MPE", "MVS", "NSK", "OS400", "R3", "SIEBEL", "UNIX", "VMS" and "WINDOWS"
Int. account	Internal account.
Interval	Interval of the Time-Event object.
Job content	Text contained in the script.
Workflow	Name of the superordinate workflow.
Last used on	Date of last object usage. Format: YYYY-MM-DD [HH:[MM:[SS]]]
Login object	Name of the Login object in jobs.
Login: user	Login information of the Login object in jobs.
Object name	Name of the object.
Object type	Short form of the object type (e.g.: JOBP)
Output device (R3_ACTIVATE_REPORT)	Name of the output device.
Report (R3_ACTIVATE_REPORT)	Name of the report.
Return code	Return code of the task.
RunID	Number of the execution.
Runtime	Duration of the execution in seconds.
SAP client	Client in SAP in Login objects of jobs.
SAP user	Name of the SAP user in Login objects of jobs.
Schedule	Name of the superordinate Schedule object.
Start time in the schedule	Start time in the format HH:MM:SS.
Start time	Start time in the format HH:MM:SS.
Status	For filter criteria: One or more system return codes are separated by commas (for example, 1900, 1920). In the analysis report: The long texts are output instead of the numbers (for example, ENDED_OK).
Time event	Name of the Time-Event object.
Title	Title of the object.
Type of parent object	Object type of the parent object.
Variant (R3_ACTIVATE_REPORT)	Name of the variant.
Version	Version number of the object.