1.1

ContentsNullableLengthTypeColumn Name
The identifier of the thread
that was running when the
statement was captured.
No32672VARCHARXPLAIN_THREAD_ID
The internal transaction
identifier.
No32672VARCHARTRANSACTION_ID
The internal identifier of
the session that was active
No32672VARCHARSESSION_ID
when this statement was
executed.
The name of the database
that was used when this
statement was executed.
No128VARCHARDATABASE_NAME
In a network environment,
this column contains an
Yes32672VARCHARDRDA_ID
internal identifier for the
network connection that
was active when this
statement was captured. In
an embedded
environment, this column
is NULL.
This field is NULL unless
SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING
Yes36CHARTIMING_ID
has been called to enable
statistics timing. If
statistics timings are being
captured, then this column
contains the ID of the row
in
SYSXPLAIN_STATEMENT_TIMINGS,
which records the
statement timing.
SYSALIASES
Describes procedure result processors that are installed in the distributed system.
See Configuring a Custom Result Processor on page 154.
Table 16: SYSALIASES system table
ContentsNullableLengthTypeColumn Name
Unique identifier for the
alias.
No36CHARALIASID
The alias itself.No128VARCHARALIAS
Reserved for future use.Yes36CHARSCHEMAID
The Java class name of the
procedure result processor.
No32,700LONG VARCHARJAVACLASSNAME
'P' (procedure)No1CHARALIASTYPE
'P' (procedure),No1CHARNAMESPACE
643
System Tables