Cloud Integration Hub

Back Next

Hosted publication repository size specifications

If you use a hosted publication repository when you create topic tables, verify that they don't exceed the maximum allowed row and storage sizes. If topic tables exceed the maximum allowed row or storage size on a hosted publication repository, topic table creation fails.

Maximum row size: Row size is the total length of all the columns in a topic table and is dependent on the character set.
The maximum allowed row size for a topic table is 8,000 bytes.
Maximum storage size: The storage requirements for individual columns determine how many columns fit within the maximum storage size for a topic table.
The maximum allowed storage size for a topic table row is 64,000 bytes, and the total allowed storage size is 25 GB.

Refer to the following table for the row and storage sizes that the columns occupy, based on their data type:

Data Type	Row Size in Bytes	Storage Size in Bytes
String, precision lower than or equal to 85	For data that contains ASCII characters: Precision + 1 For data that contains Unicode characters: (Precision × 3) + 2	(Precision × 3) + 2
String, precision higher than 85	22	(Precision × 3) + 2
Decimal	20	20
Double	8	8
INT32	4	4
INT64	8	8
Text	22	12
Date time	8	8

An encrypted column in a topic table occupies a row size of 22 bytes and a storage size of 12 bytes.

For example, if a topic table contains 100 columns of data type string with a precision of 80, then it exceeds the maximum allowed row size of 8,000 bytes. If a topic table contains 84 columns of data type string with a precision of 255, then it exceeds the allowed storage size of 64,000 bytes.

Refer to the following table for the row sizes and storage sizes that the mandatory topic table fields occupy: