# Getting Started

## Tracing

| All database accesses in Agile e6 are implemented as dynamically generated SQL commands. Under Tools> Trace you will find a series of functions which you can use to control custom program applications and for tracing program processes. With these functions, you can display the SQL commands used for each database transaction on the screen.
| The trace function contains the following sub-functions: SQL-Statements ... Trace New Trace Append Trace with EPQ New Trace with EPQ Append Trace Off Trace Info Show trace Select Module
| ### SQL-Statements ...
| Select Tools > Trace > SQL-Statements .... The SQL-Trace window will open. It displays the recordable transactions:

ERROR | Displaying system errors
TRANS | Displaying different transactions
DELETE | Deleting data records
INSERT | Inserting data records
UPDATE | Changing data records
SELECT | Searching data records
FETCH | Loading data records (as a block)
FETCH/SINGLE | Loading data records (as an individual data record)
CREATE TABLE | Creating tables
COPY TABLE | Copy tables
DROP TABLE | Deleting tables
READ TABLE | Reading the table structure

| #### Select Transactions
| Click in the check box beside the transaction to activate it. A tic marks the activated check box.
| #### Deselect Transactions
| Click in the activated check box beside the transaction. The tic is removed.
| The SQL Trace setting is maintained up to the next change or when leaving Agile e6.
| If a search query is carried out while the SELECT flag is set, a trace protocol will be created. In order to show the trace protocol, select the function Refresh in the menu SQL-Trace mask.
| ### Trace New
| With module Trace New, all actions carried out with Agile e6 are recorded if the actions are linked to the module trace.
| Select the modules you want to run the module trace for.
| Module selection
| To start the module trace select Tools > Trace > Trace New.
| The test functions integrated in Agile e6 record test information on up to 9 levels. Each test level is an individual information level. Test info is written in a test file whose name and path is displayed in a window.
| ### Trace Append
| You can pause the module trace and continue it with the Trace Append. The new test outputs are added to the last recorded test output.
| ### Trace with EPQ New
| This command starts the module Trace and records also the data base commands.
| #### Combined Module and SQL-Trace with EPQ New
| Select the SQL Trace Statement (Tools>Trace>SQL-Statements...), e.g. "Select".
| Select the module (Tool>Trace>Select Module), e.g. "BAS".
| Start the module trace with EPQ New (Tools>Trace>Trace with EPQ New).
| Select the function you want to trace (e.g. Start>Items, select an item and refresh the widget).
| Show Trace (Tools>Trace>Show trace).
| ### Trace with EPQ Append
| You can pause the module Trace with EPQ (records also the data base commands) and continues it with the module Trace Append command. The new test outputs are added to the last recorded test output.
| ### Trace Off
| With this command you can interrupt the module Trace.
| ### Trace Info
| With this function you can display the generated test files and the path to the saved data. In addition the module Trace Info shows the test levels (standard: nine level). Example:
| Messages after choosing Trace Info:
| Select the modules, you want to start the module Trace for, with Tools > Trace > Select Module.
| Select Trace New to start the record. In the chosen projects Agile e6 executes an import function to activate the module specific functions. The test file displays the test output. Test files start with tst and end with the suffix .trc. In addition the process-ID is indicated. The test file is saved in the tmp directory.
| ### Show Trace
| With this function you can view the trace protocol.
| You need to start the trace mode before using this function.
| Select Tools > Trace > Show trace. The Module Trace mask is opened.
| Click on the Select Module button to select a module.
| Select a module and click OK.
| Click to load the trace output.
| In the Windows Client, you can copy the trace output with CTRL+C or by Drag and Drop to another application.
| ### Select Modules
| Select the Select Module Command to select the modules you want to analyze.
| Select Tools > Trace > Select Module The window Select modules opens. The following image shows the window with some activated modules:
| Select the check box beside the modules you want to analyze.
| Click OK.
| Start the module trace with Trace New. An import function is carried out in the activated modules to activate the module functions. The module trace can be viewed in the specified test file. Test files always start with name tst and end with .trc. The process ID is also specified. The test file is saved in the directory tmp.
| Further information about tracing can be found in the General Administration online help, section Error Handling and Debugging.

##