System Tables

Certain system tables support multiplex functionality.

• ISYSIQINFO System Table
  This table indicates the database characteristics as defined when the SAP Sybase IQ database was created using CREATE DATABASE. It always contains only one row.
• ISYSIQLOGICALSERVER System Table
  ISYSIQLOGICALSERVER stores logical server and the correspondence between logical server and associated logical server policy information.
• ISYSIQLOGINPOLICYLSINFO System Table
  ISYSIQLOGINPOLICYLSINFO stores the login policy logical server assignment information.
• ISYSIQLSLOGINPOLICYOPTION System Table
  ISYSIQLSLOGINPOLICYOPTION stores the login policy option values that have logical server level settings.
• ISYSIQLSMEMBER System Table
  ISYSIQLSMEMBER stores the logical server membership information.
• ISYSIQLSPOLICY System Table
  ISYSIQLSPOLICY stores logical server policies.
• ISYSIQLSPOLICYOPTION System Table
  ISYSIQLSPOLICYOPTION stores the logical server policy options.
• ISYSIQMPXSERVER System Table
  ISYSIQMPXSERVER stores membership properties and version status data for a given multiplex node.
• ISYSIQMPXSERVERAGENT System Table
  ISYSIQMPXSERVERAGENT stores agent login information for each multiplex node.