Configure logical server access.
Assume that the root login policy allows access to logical servers ls4 and ls5 and login policy lp1 exists with no logical server assignment. The statement below effectively assigns login policy lp1 to logical servers ls4 and ls5.
Assign logical server ls1 to login policy lp1:
ALTER LOGIN POLICY lp1 ADD LOGICAL SERVER ls1
ALTER LOGIN POLICY lp1 ADD LOGICAL SERVER ls2, ls3
ALTER LOGIN POLICY lp1 ADD LOGICAL SERVER ls4
ALTER LOGIN POLICY lp1 DROP LOGICAL SERVER ls1, ls2
ALTER LOGIN POLICY lp1 SET LOGICAL SERVER ls3, ls4
Modify login policylp1 to deny access to any logical servers:
ALTER LOGIN POLICY lp1 SET LOGICAL SERVER NONE
ALTER LOGIN POLICY lp1 SET LOGICAL SERVER DEFAULT
Use only one ADD, DROP, or SET clause. Use SERVER, NONE, and DEFAULT clauses only with the SET clause. Specify a particular logical server name only once per ls-assignment list or ls-override list.
Any logical server specified with the ADD clause is already assigned to the login policy.
Any logical server specified with the DROP clause is currently not assigned to the login policy.
Logical server assignment change may cause a membership overlap among assigned logical servers.
SYS.ISYSIQLOGINPOLICYLSINFO stores logical server assignment information. For each logical-server override of a login policy option, a corresponding row exists in ISYSIQLOGINPOLICYLSINFO.