DBCON entry does not exist for CCMS_DB2_

[#1]

In SAP Collector Settings when I "Check Status" for "Alert Router" I get this message:

• "DBCON entry does not exist for CCMS_DB2_<sid>"

When I attempt to add CCMS_DB2_<sid> entry I get this message:

• Password invalid (choose another password)

My understanding is that for CCMS entries all we need to define are SSID,Collection Id, Schema, Database Name, Port Number & IP Address|Host

Why am I being prompted for a Password when I haven't specified a User Name?

Regards
Bruce

[former_member580103]

I'm glad to see you received an answer via SAP incident 601057 / 2019.

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Reply 26.11.2019 10:08:05
Hello,
Since you're using IP addresses in db2dsdriver.cfg you need to add DB2MISC parameter

CCMS_DB2_DBCON_HOSTNAME_FORMAT='IP_ADDRESS'

as per note 2068561.

In addition, in IB1 server and affinity lists are not unique in db2dsdriver.cfg:

..

alternateserverlist>

<server name="IB1" hostname="10.31.35.175" port="06501"/>

<server name="IB1" hostname="10.31.35.176" port="06505"/>

</alternateserverlist>

<affinitylist>

<list name="list1" serverorder="IB1"/>

<list name="list2" serverorder="IB1,IB1"/>

</affinitylist>

..

Correct it according to your requirements.

Kind regards

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++