Presents group information from ISYSIQMPXLOGINPOLICYOPTION in a readable format.
ISYSIQMPXSYSPOLICYLOGIN stores information that allows a user to override the two login policy options (lock and max_connections) for a particular login policy on a per multiplex server basis.
Column name |
Column type |
Description |
|---|---|---|
login_policy |
UNSIGNED BIGINT NOT NULL |
The ID number of the login policy. |
server_id |
UNSIGNED INT NOT NULL |
The server name. Must be case insensitive unique. |
login_option_name |
CHAR(128) NOT NULL |
The option name to be overridden: locked or max_connections. |
login_option_value |
LONG VARCHAR NOT NULL |
The value of the login policy option. For values and their defaults, see Reference: Statements and Options. |
Constraints on underlying system table login_policy_id foreign key(ISYSLOGINPOLICY)
server_id foreign key(ISYSMPXSERVER)
