What is the maximum character length for the value field of a custom string attribute?

Document ID:  TEC1593728
Last Modified Date:  06/08/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA Spectrum

Releases

  • CA Spectrum:Release:10.0
  • CA Spectrum:Release:10.1
  • CA Spectrum:Release:10.1.1
  • CA Spectrum:Release:10.2
  • CA Spectrum:Release:10.2.1
  • CA Spectrum:Release:10.1.2
  • CA Spectrum:Release:9.3
  • CA Spectrum:Release:9.4
  • CA Spectrum:Release:9.4.1
  • CA Spectrum:Release:9.4.2
  • CA Spectrum:Release:9.4.2.1
  • CA Spectrum:Release:9.4.3

Components

  • CORE / SPECTROSERVER:SPCCSS
Question:

We are using Model Type Editor (MTE) to create some custom attributes that will display text as their value, and would like to know what is the maximum character length Spectrum supports?

Answer:

The character limits are controlled by the Berkeley database, which is used for the SSdb database in Spectrum. The database limits for the SSdb are controlled by what can fit into the memory space to be returned to the application. Some of the Berkeley database interfaces may return both the key and data items to the application. So, the key/data pair must fit simultaneously into memory.

 

Therefore, there is not a hard-set character length for the custom attributes. Essentially the character length is unlimited, up to the point where the system, application, and Berkeley database can handle it. For the current release of Spectrum 10.2.x, the most upper limit is 4GB of text, which is not recommended. In general, you should not be as concerned with the character length of the text, but more concerned with the file size, and memory size of the overall text.

 

CA Sustaining Engineering recommends not trying to store huge text strings across the entire database, since this will drive up the memory usage of the SpectroSERVER. For example, if the text string is 10k in size, and it is displayed against 100,000 models (10k string * 100k models), this would at the very least consume an extra 1GB of memory. This is more problematic for the older 32-bit SpectroSERVERs than it is for the 64-bit SpectroSERVERs, but should be taken into consideration during your customization planning.

 

Additional Information:

https://docs.oracle.com/cd/E17275_01/html/programmer_reference/am_misc_dbsizes.html

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