The Log File

The PSDB interface generates a log file during execution. The name of this log file is controlled by options in the PSDB.INI file. What information is to be logged is also controlled by options in the PSDB.INI file. The log file can contain these parts:

• The first part shows various types of database information. The "info" option in the PSDB.INI file controls whether this entry is logged. In the second entry all statements are logged. This is controlled by the Statements option in the PSDB.INI. Statement ID specifies the name of the statement. The number of columns and parameters that are displayed inside the parentheses is also logged, whether the text is to be converted and whether the statement is kept simple. The Columns option in the PSMI.INI file controls if column data must also be logged.
• In the third part the communication with the database is logged. This takes place if the log level is set to 10.
• In the fourth entry the performance measurements are logged. The logging of performance measurements is controlled by the "performance" option in the PSMI.INI file. First the amount of time it takes to connect to the database and then the amount of time it takes to read and interpret the parameter file is logged. All statements are logged in the table by name and type. The statements that have been executed during this connection have an Execute time + # logged (the average amount of time for each execution and the number of executions). If the statement is a SELECT statement the block size is logged along with the array size. The maximum, minimum and average time the retrieval has taken, the number of retrievals and the number of times data was truncated are also logged. All measurements are logged in seconds.