SYSIQLOGICALSERVER System View

Presents a readable version of the ISYSIQLOGICALSERVER system table.

The ISYSIQLOGICALSERVER system table stores logical server information and associated logical server policy information.

Column name

Column type

Description

ls_id

UNSIGNED BIGINT NOT NULL

The ID number of the logical server.

ls_object_id

UNSIGNED BIGINT NOT NULL

The logical server object ID number.

ls_policy_id

UNSIGNED BIGINT NOT NULL

The ID number of the logical server policy.

ls_name

CHAR(128) NOT NULL UNIQUE

The logical server name.

Constraints on underlying system table:
  • Primary key(ls_id)

  • object_id foreign key(ISYSOBJECT)

  • ls_policy_id foreign key(ISYSIQLSPOLICY)