This chapter contains a survey of all runtime options. They can be specified when an ADABAS application is started.
CACHELIMIT(<cachelimit>)
CACHELIMIT defines the size of a cache buffer for result tables. This option overrides the value in a CONNECT statement or the predefined value. It affects only the database session with the number 1. A description of CACHELIMIT is included in the Reference manual.
ISOLATION LEVEL(<level number>)
A level number can be specified here under which the locks will be set to a database. This option only has an effect on the session with the number 1. It overrides the level number in the specified CONNECT statement and the level number passed during the precompiler run.
MFETCH (<number>)
This option can be used to optimize access for FETCH statements. Number indicates the number of 8k byte buffers into which rows of different result tables can be stored simultaneously, thus enabling faster access to the rows. <number> is preset to 1. If a trace option is active, the MFETCH option has no effect.
NODATE
This option can be used to suppress the specification of the START and END date as well as the START and END time in trace output.
NO SELECT DIRECT FAST
This option can be used to disable the optimization of the SELECT DIRECT statements. This is necessary especially if the error -9806 occurs. The optimization only has an effect when repeating the SELECT DIRECT statement.
PROFILE
This option can be used to enable a profile which calculates the complete time of processing. If the table SYSPROFILE is available for the LOCALSYSDBA, the values will be written to this table (see Section Profiling).
SERVERDB (<serverdb>)
This option has an effect on every session with the number 1. The option overrides the specifications of the CONNECT statement made in the application program or the predefined user specifications.
SERVERNODE (<servernode>)
This option has an effect on every session with the number 1. The option overrides the specifications of the CONNECT statement made in the application program or the predefined user specifications.
TIMEOUT (<timeout>)
This option can be used to specify the SESSION TIMEOUT for the session with the number 1. This option overrides the timeout specifications made in the indicated CONNECT statement. It has an effect on all sessions with the number 1.
TRACE ALT (<statement count>)
Trace output is made alternately to two files. When doing so, as many SQL statements are recorded in each file as are specified in <statement count>. If there are more SQL statements than indicated by <statement count>, the files will be overwritten cyclically. The trace files are named 'fn.pct' and 'fn.prot'. The SQL statements are recorded together with the contents of the host variables (trace long). Date and time specifications cannot be suppressed.
TRACE FILE (<trace filename>)
This option can be used to specify a name other than the default name to the trace output. If no other trace option was specified, the option TRACE SHORT is simultaneously enabled by default. The filename is standardized according to the operating system conventions in the platform-specific User Manuals. The name may also be specified (optionally) as a character string constant. This option overrides the option transferred during the precompiler run. Only trace files with default trace filenames are not buffered on output.
TRACE LONG
Each executed SQL statement is written into a file, together with the values of all SQL statements, the SQLCODE (if not equal to zero), the warnings (if warnings exist) and the SQLERRD (INDEX_3) value. This option overrides the option transferred during the precompiler run and the statements specified in the application program.
TRACE NO DATE/TIME
This option can be used to suppress the output of the date and time specifications for the start and end of the execution of an SQL statement made into the trace file.
TRACE SHORT
Each executed SQL statement is written into a file, together with the SQLCODE (if not equal to zero), the warnings (if warnings exist) and the SQLERRD (INDEX_3) value. This option overrides the option transferred during the precompiler run and the statements specified in the application program.
TRACE TIME (<seconds>)
Only SQL statements are recorded whose execution time is greater than or equal to <seconds>. The SQL statements are recorded together with the contents of the host variables (trace long). Date and time specifications cannot be suppressed.
USER (<userid> <password>)
If the application program is performed under a USER other than specified in the CONNECT statement or in the predefined user specifications, this user can be specified here. This option has an effect on all sessions with the number 1.
USERKEY(<userkey>)
A USERKEY can be specified here. The pertinent user, the database, TIMEOUT, CACHELIMIT, and isolation level are fetched from the XUSER file. The corresponding database can then be accessed by means of this user id. This option has only an effect on the session with the session number 1. It overrides either the user specification made in the CONNECT statement or the predefined user specifications.