DB2 10.5 for Linux, UNIX, and Windows

Limitations for text fields and document attributes

There is a list of limitations for the text field and document attributes, as well as a list of tags that can be included in an HTML document model.

The following lists the limitations for text fields and document attributes:
  • Maximum number of fields in an index: 32767
  • Maximum number of values for one attribute of type STRING in one document: 1024
  • Maximum number of attributes of type STRING: 253
  • Number of characters in a STRING attribute value is truncated to 128
  • Maximum number of attributes of types DATE and NUMBER: 32766
  • Number of characters in a DATE or NUMBER attribute value is truncated to 128
  • For NUMBER attributes, a double precision floating point number is accepted as a value.
  • Maximum number of values that can be specified for one attribute of type DATE or NUMBER in one document: unlimited
These are the tags that can be included in an HTML document model:
  • <A>
  • <ADDRESS>
  • <AU>
  • <AUTHOR>
  • <H1>
  • <H2>, <H3>, <H4>, <H5>
  • <H6>
  • <TITLE>
Tags like <HEAD> and <BODY> that can contain other tags, cannot be specified in an HTML document model as a text field.