When the option PROFILE is enabled during an application's run, the ADABAS kernel generates statistics on the processed OCI entries.
For every order, the date of runtime, number of calls and accumulated realtime is entered into the SYSPROFILE table of the local SYSDBA. The realtime consists of the time taken by the processing of a statement within an application program including all data conversions and time needed by the ADABAS kernel. The time needed to enter this information into the SYSPROFILE table is not included. The key of a row consists of the following specifications: user name, program name, module name, language of the application program, and line number of the statement within the application program related to the source and the internal parseid. With the enabled TRACE option, the time required for writing the trace to a file affects the profiling. Therefore, it is not convenient to activate the PROFILE and TRACE options at the same time.
The entries to the SYSPROFILE table are made within the transactions of the application program. Therefore, they are only stored in the table when the application program issues a COMMIT WORK.
When the option is enabled, old entries made for username, program name, and language are always deleted when executing the first CONNECT statement.