IBM Support

How to define ICM properties as "long string"

Question & Answer


Question

According to Knowledge Center below, properties as "long string" can be defined to make allocation size to less size. How do you define them concretely ? Adding and reusing properties https://www.ibm.com/support/knowledgecenter/en/SSCTJ4_5.2.1/com.ibm.cas… Minimize database row sizes http://www.ibm.com/support/knowledgecenter/en/SSNW2F_5.2.1/com.ibm.p8.c… "Consider the data type used for a string property because it can affect the row size. A string property with a large allocation size takes far less space in the row if it is created as a long string data type; however, long strings have functional limitations. Using an integer for representing values takes less space compared to a string. For more information about the differences between short and long string data types, see "Short or long custom string properties" in Selected property descriptions."

[{"Product":{"code":"SSCTJ4","label":"IBM Case Manager"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"5.3.0;5.2.1;5.2.0","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
17 June 2018

UID

swg21997129

Page Feedback