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

[bruce_williamson · Accepted solution]

There appears to be a FUDGE in order to add CCMS entries

1. N.B. This cannot be done from the DBA Cockpit
2. Use to TCode DBCO to access "Database Connections Overview"
3. Use <F5> (or click "New Entries")
4. Fill in details as per your site standards without "User Name" and "DB Password"
5. N.B. FUDGE Part 1: DO NOT SAVE AT THIS POINT!!!
6. Use <F3> (or click "Back") to exit
7. N.B. FUDGE Part 2: On the "Exit Maintenance" dialogue click "Yes" to save changes

Voila … you've successfully added a Database Connections without any validation by SAP

[bruce_williamson]

I believe you have somewhat missed the question which I was asking so I will highlight:

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

So when I use the DBCON t-code and try to enter a connection for CCMS I'm prompted for a password. This is a change from the original functionality which did not require a User Name/Password for CCMS connections

[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

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