sm_host_appl table

The sm_host_appl table contains session availability and usage information for a specific host application. The information is used to produce the HostApplUsage and HostApplErrs reports.

Table definition

sm_host_appl:
  system_name varchar(15),
  appl_name varchar(15) not null,
  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

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