"Failed to establish connection to the host" Error adding new DB2 agents for instances on a Windows host (4310956)

User is unable to add DB2 monitoring to a Windows host.

Error when setting up DB2 instances in Foglight.

Cause 1

* this is the most common issue *

Insufficient WMI permissions

Cause 2

Incorrect DB2 hostname used in the installer

Cause 3

DB2 host is unavailable

Cause 4

DB2 credentials are incorrect

Cause 5

Remote Registry service is not running

Cause 6

Ports for WMI are blocked

Resolution 1

* this is the most common issue *

When using DCOM/WMI
DB2 agents that connect to Windows machines using the Agent Manager’s WindowsShellService need to make the following specific registry changes to allow the connection.

Two keys mainly required for Windows monitoring host. The others are for scenario when FglAMs are installed on Unix/Linux hosts and need to make WMI connections to Windows DB2 hosts

Windows relevant keys:

{72C24DD5-D70A-438B-8A42-98424B88AFB8} (Windows Script Host Shell Object)

{0D43FE01-F093-11CF-8940-00A0C9054228} (FileSystem Object)

Please refer to KB 65870 to enable WindowsShellService access on registry keys.

When using WinRM
The user can connect via WinRM instead of using DCOM and in doing so will not need to change any registry settings.

The DB2 agent does not support the short domain userid, such as corp\db2admin, this may require adding a compatible local ID into DB2.

• When WinRM is using Basic authentication, the userID must be the local user, without any domain.
• When WinRM is using Negotiate authentication, the userID must be the domain user with full qualified domain name, and this authentication requires to configure the krb.

Resolution 2

Verify that the DB2 hostname is correct, that it can be resolved from the agent manager server, and that ports are open between the FglAM and monitored host.

 

Resolution 3

Confirm that the DB2 host is available and online

Resolution 4

Check that the specified OS credentials are trusted and are granted with required permissions to establish a connection with the host. Also confirm that the correct credentials are entered into the installer and that the accounts can access DB2 and/or the OS from outside of Foglight.

Resolution 5

The Remote Registry service must be running in Windows to allow agents remote access to the registry.

Resolution 6 

Please ensure that the following ports are open bidirectionally between the FglAM and DB2 host with WMI connections

• DB2 specific port (e.g. default 50000)

• 135 (DCE/RPC Locator service, WindowsShellService, WMIConnection Service)

• 139 (NetBIOS Session Service),

• 445 (Windows shares)