Start of change

ADD_MIGRATION_HOST_TABLE_ENTRY procedure

The ADD_MIGRATION_HOST_TABLE_ENTRY procedure registers an IP address and its associated host names to be modified on the target node to the IBM i Migrate While Active environment. The modification will occur on the target node during the cutover stage.

Host table entries that have been defined can be displayed using MIGRATION_HOST_TABLE_ENTRY_INFO view.

Authorization: The caller must have *IOSYSCFG special authority. To understand any additional authority needed to use this procedure, see Db2® Mirror services authorization.

Read syntax diagramSkip visual syntax diagram ADD_MIGRATION_HOST_TABLE_ENTRY ( CUTOVER_ACTION =>  cutover-action ,IP_ADDRESS =>  ip-address ,HOST_NAME =>  host-name ,TEXT_DESCRIPTION => text-description )

The schema is QSYS2.

cutover-action
The migration cutover action to be performed by the Migration Manager for the host table entry.
ADD ON TARGET
Add the host table entry on the target node.
REMOVE FROM TARGET
Remove the host table entry from the target node.
ip-address
A character string that specifies the IP address to add to the host table. It must be an IPv4 address.
host-name
A character string that specifies the host name corresponding to ip-address.
text-description
A character string that specifies up to 50 characters of text that describes the host table entry.
If this parameter is omitted, no text description is included.

Examples

  • Define a short host name to be added to the target node during the cutover stage.
    CALL QSYS2.ADD_MIGRATION_HOST_TABLE_ENTRY(
               CUTOVER_ACTION=> 'ADD ON TARGET', 
               IP_ADDRESS => '123.45.67.8', 
               HOST_NAME=> 'ETHERNETHOSTNAME', 
               TEXT_DESCRIPTION => 'ETHERNETHOST on Ethernet subnet');
  • Add 5 host names associated with the same IP address.
    CALL QSYS2.ADD_MIGRATION_HOST_TABLE_ENTRY(
                   CUTOVER_ACTION=> 'ADD ON TARGET', 
                   IP_ADDRESS => '123.4.5.789', 
                   HOST_NAME=> 'SYSTEM1.SALES.ABC.COM', 
                   TEXT_DESCRIPTION => 'Entry verified by D. Jones'); 
    CALL QSYS2.ADD_MIGRATION_HOST_TABLE_ENTRY(
                   CUTOVER_ACTION=> 'ADD ON TARGET', 
                   IP_ADDRESS => '123.4.5.789', 
                   HOST_NAME=> 'system1.sales.abc');
    CALL QSYS2.ADD_MIGRATION_HOST_TABLE_ENTRY(
                   CUTOVER_ACTION=> 'ADD ON TARGET', 
                   IP_ADDRESS => '123.4.5.789', 
                   HOST_NAME=> 'System1.Distribution.Abc.Com');
    CALL QSYS2.ADD_MIGRATION_HOST_TABLE_ENTRY(
                   CUTOVER_ACTION=> 'ADD ON TARGET', 
                   IP_ADDRESS => '123.4.5.789', 
                   HOST_NAME=> 'System1.Marketing.Abc.Com');
    CALL QSYS2.ADD_MIGRATION_HOST_TABLE_ENTRY(
                   CUTOVER_ACTION=> 'ADD ON TARGET', 
                   IP_ADDRESS => '123.4.5.789', 
                   HOST_NAME=> 'System1.Marketing.Abc');
End of change