sm_host_link table

The sm_host_link table contains session availability and usage information for a specific host link. The information is used to produce the HostLinkUsage and HostLinkErrs reports.

Table definition

sm_host_link:
  system_name varchar(15),
  link_name varchar(15) not null,
  link_active int,
  max_LU_config int,
  max_LU_available int,
  max_LU_used int,
  max_LU_disabled int,
  LU_failures int,
  LU_comm_errs int,
  LU_script int,
  time_stamp timestamp

Fields

link_name
The host link.
link_active
Number of minutes the link was active.
LU_failures
Maximum number of session failures for all host applications for reasons other than being manually disabled.
LU_comm_errs
Maximum number of session failures due to lack of physical access to the host link.
LU_script
Maximum number of sessions aborted by the 3270 server script due to a script ABORT command.
max_LU_config
Maximum number of sessions configured for host applications.
max_LU_available
Maximum number of sessions available to host applications.
max_LU_used
Maximum number of sesssions that were invoked by the 3270 executor.
max_LU_disabled
Maximum number of sessions that were manually disabled across host applications.
system_name
The Blueworx Voice Response system to which the data applies.
time_stamp
A 30 minute time period (date and time).