Why does case matter in my USM searches?

Document ID:  TEC1073488
Last Modified Date:  07/10/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA Unified Infrastructure Management

Components

  • UIM - USAGE_METERING/BILLING:UIMUSM
Question:

In UMP USM home page search box, when I search with upper-case caracters, I get different results than when I do a search with lower-case characters.  Why is this?

Answer:

The most likely explanation is that the UIM database is being hosted on an Oracle SQL server.  Oracle is case sensitive and will only return information on devices that match character and case.  Microsoft SQL server and MySql are not case sensitive and will return results in with same letters but any case.
This is expected behavior and can be changed by:
- Changing the probe which is the source of the QoS to use the case you would expect.  Here is one example of how to do this:
https://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.TEC000004223.html

- Change the Oracle server to eliminate case-sensitivity with an nls_sort or some other means.  Consult with your DBA for information regarding how to do this and what it's effect might be.

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >

Chat with CA

Just give us some brief information and we'll connect you to the right CA ExpertCA sales representative.

Our hours of availability are 8AM - 5PM CST.

All Fields Required

connecting

We're matching your request.

Unfortunately, we can't connect you to an agent. If you are not automatically redirected please click here.

  • {{message.agentProfile.name}} will be helping you today.

    View Profile


  • Transfered to {{message.agentProfile.name}}

    {{message.agentProfile.name}} joined the conversation

    {{message.agentProfile.name}} left the conversation

  • Your chat with {{$storage.chatSession.messages[$index - 1].agentProfile.name}} has ended.
    Thank you for your interest in CA.


    Rate Your Chat Experience.

    {{chat.statusMsg}}

agent is typing