The PSDB.INI File

The file contains these elements:

[ODBC]
uid= 
	 
pwd= 
	 
dsn= 
	 
  
	 
[LOG] 
	 
type= 
	 
file= 
	 
statements= 
	 
columns= 
	 
performance= 
	 
info= 
	 
level= 
	 
  
	 
[DATABASE] 
	 
db2explain=

Lines starting with an exclamation mark "!" are skipped.

The various options explained further in these topics:

  • The ODBC Part
  • The [LOG] Part
  • The [DATABASE] Part

The [ODBC] Part

This part of the INI file contains options related to the ODBC connection:

  • UID. This option set the User ID used when logging on to the database.
  • PWD. This option set the password used when logging on to the database.
  • DSN. This option set the DSN (Data Source Name) for the used database.

The [LOG] Part

This part of the INI file contains options related to the logging facility:

Type:

This option defines whether the log entries are to be added to an existing log file or to a newly created file (thereby deleting an existing file with the same name). The option can have these values:

  • New: Always create a new log file.
  • Append: New log entries are added to the existing log file.

File:

This option states the naming convention that is used for the log files. The option can have these values:

  • Name: The log file will is named psdb.log.
  • Date: A new log file is generated each day. The name will be psdbmmdd.log, where mmdd is the month and day.

Statements:

This option defines whether SQL statements are logged. The statements are logged in the format in which they are sent to the database. In addition to the statements, information about array sizes etc. is also logged.

The option can have these values:

  • Yes: The statements are logged.
  • No: The statements are not logged.

Columns:

This option defines whether the definitions for the Infor M3 SWB fields are logged. Column type, size type, offset values, defined functions etc. are logged. The option can have these values:

  • Yes: Column definitions are logged.
  • No: Column definitions are not logged.

Performance.

This option is states whether performance measurements are logged. The PSDB interface measures the time used to connect to the database, the time it takes to read and interpret the parameter file and the number of times and average duration a statement uses when it is executed. If the statement is a SELECT statement, then PSDB also measures the number of retrievals, the minimum, maximum and average time the retrievals took and the number of times a data truncation occurred. All measurements are in seconds. The option can have these values:

  • Yes. Log performance measurements.
  • No: Do not log performance measurements .

This option states whether various database information are logged. Information about the database name, version, ODBC level, standards compliance, database limitations etc. is all logged. The option can have these values:

  • Yes: Database information are logged
  • No: Database information are not logged

Level:

This option states at which level errors and warnings are logged. The option can have these values:

  1. No errors or warnings are logged.
  2. Errors are logged.
  3. Errors and data-truncations are logged.
  4. Errors, data truncations and warnings are logged.
  1. All errors and warnings are logged.
  2. All data sent to the database and received from the database is logged.

The [DATABASE] Part

This part of the INI file contains special database settings:

Db2explain: 

This option can be used to apply the DB2 Visual Explain logging facility. Before DB2 Visual Explain can be used on a database some special database tables must be created. This is done by opening a DB2 Command prompt window, connecting to the database and specifying this command into the \SQLLIB\MISC directory:

DB2 -TF EXPLAIN.DDL

DB2 then creates the explanation tables.