HP Insight Management 7.3 DMT White Paper

Appendix G: Running the fix_fqdn_dmt.pl script

This script updates existing values in the primary CMS database to be consistent with the current

secondary CMS FQDN. Use this script to fix the FQDN on secondary CMSs only, because the

primary CMS FQDN is automatically handled by the migration process. Before running the script,

make sure Perl and Microsoft SQL Server SQLCMD are installed on the primary CMS. The input

file is required, it must be formatted correctly, and it must not contain blank lines (even at the

end).

Input file format

• One line is composed of the following:

<source_secondary_cms_fqdn>, <target_secondary_cms_fqdn>

• Each line is composed of a pair <from>, <to>. A file may be composed of multiple

lines.

Example of an input file

oldsecondary1.company.domain,newsecondaryA.company.domain

oldsecondary2.company.domain,newsecondaryB.company.domain

Migration of high availability environments

If the secondary CMSs are HA, include the HP SIM virtual server FQDN of the secondary CMSs

into the list.

Input file format

One line is composed of the following:

• <source_secondary_HPSIMVirtualServer_FQDN>,<target_secondary

_HPSIMVirtualServer_FQDN>

Example of an input file with only the primary CMS in HA configuration

oldsecondary1.company.domain,newsecondaryA.company.domain

oldsecondary2.company.domain,newsecondaryB.company.domain

Example of an input file for both primary and secondaries in HA configuration

oldsecondary1-sim.company.domain,newsecondaryA-sim.company.domain

oldsecondary2-sim.company.domain,newsecondaryB-sim.company.domain

Summary

• The secondary CMS always needs to be added into the input file (HA environment or

not).

• Specify the <HPSIMVirtualServer>_fqdn instead of the usual <CMS FQDN> for

all nodes that are configured as HA.

Running the script

1. Log in to the primary CMS and open a prompt window.

2. Go to <IO_Install Path/support> and run the script:

fix_fqdn_dmt.pl -f <INPUT_FILE> -s <DATABASE_SERVER>

Usage

fix_fqdn_dmt.pl -f <INPUT_FILE> [-s <SERVER>] [-p <PORT>] [-i

<INSTANCE>] [-u <USERNAME>] [-w <PASSWORD>]