Managing dynamic location aliases
You can stop, cancel, modify, and start dynamic location aliases without stopping and restarting DDF or Db2.
Before you begin
Before you can modify existing dynamic location aliases, Db2 must be started.
About this task
Unlike statically defined location aliases, you cannot define or modify dynamic aliases by using the DSNJU003 utility, and the DSNJU004 utility does not print any information for dynamic location aliases.
When a static and dynamic location aliases are defined with the same name, Db2 accepts requests only to the dynamic location alias.
Procedure
To modify an existing dynamic location alias:
Example
- A port: 9000
- An IPv4 address: 1.1.1.1
However, you want to modify the ALIAS1 location alias to use following configuration:
- The default port
- No IPv4 address
- An IPv6 address: 3::3
You might issue the following sequence of example MODIFY DDF commands:
- The following command stops Db2 from accepting new connection requests to the ALIAS1 alias and cancels existing DBATs that are processing connections to it:
-MODIFY DDF ALIAS(ALIAS1) CANCEL
You can now modify the configuration of the alias.
- The following command removes the port value from the ALIAS1 alias:
-MODIFY DDF ALIAS(ALIAS1) NPORT
The group SQL port is now used instead.
- The following command removes the IPv4 address from the ALIAS1 alias.
-MODIFY DDF ALIAS(ALIAS1) NIPV4
The member-specific IP address is returned in the server list instead.
- The following command adds an IPv6 address the ALIAS1 alias.
-MODIFY DDF ALIAS(ALIAS1) IPV6(3::3)
- The following command starts the ALIAS1 alias:
-MODIFY DDF ALIAS(ALIAS1) START
DDF starts accepting new connections to the ALIAS1 alias and uses its new configuration.