Version 4.3.2
 —  Field Reference  —

Adabas Command Log Fields (CLOG)

Field Description
ASSOIO The number of "Associator I/Os" for the command processed.
CALLTYPE   Contains the type of the Adabas call that was issued. Possible values are:
PHYSICAL standard Adabas call
SPAT-BEF a call to the triggers and stored procedures facility before an Adabas call
SPAT-AFT a call to the triggers and stored procedures facility after an Adabas call

Note:
You can collect all trigger and stored procedure calls by specifying the processing rule CALLTYPE=S*.

CMDTYPE The 1-byte command type field of the Adabas command log record that describes the internal Adabas status for the command. For example, a command type of 01 is a simple command and a command type of 42 is a complex command. The CMDSTAT field provides this translation.
DATAIO The number of Adabas "Data Storage I/Os" for the command processed.
DBID The unique Adabas database identification number.
DESUPD Contains the number of descriptors that were updated for an Adabas call.
DURATION The amount of time that the command spent in the Adabas thread, including time spent waiting for I/O operations to complete. This field is expressed in seconds and is accurate to 4 decimal places. The field ADADURA contains the same value accurate to 6 decimal places.
ECBS Contains the number of event control blocks posted in the Adabas command queue.
ORGDURA Corresponds to the (original) value of the "duration" field contained in the command log record. The time is expressed in units of 16 microseconds. With CLOGLAYOUT=5 (required for Adabas Review), the "duration" field value is calculated in such a way that ORGDURA contains a value that is nearly equal to the Review field TOTDURA.
PRIORITY Contains the operating system priority for the user issuing the Adabas call.
SEQUENCE Contains the Adabas command sequence number. The value is incremented by one for each Adabas command processed.
SRCHTYPE Contains the type of search or search algorithm. If this field contains the value 'NONDES', a nondescriptor search occurred.
THREAD Contains the Adabas thread number in which the Adabas command was processed.
USERID Contains the 28-byte Adabas communication ID of the user for whom the command was processed.
WORKIO Contains the number of I/O operations performed against the Adabas Work dataset for the command processed.

Top of page