Table of Contents

Search

  1. Preface
  2. Introduction to Cloud Integration Hub
  3. Hub administration
  4. Project and Asset Management
  5. Applications
  6. Topics
  7. Data Integration tasks
  8. Publications
  9. Subscriptions
  10. Tracking and monitoring
  11. Cloud Integration Hub REST APIs
  12. Glossary

Cloud Integration Hub

Cloud Integration Hub

Hosted publication repository size specifications

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:
Field
Row Size in Bytes
Storage Size in Bytes
PUBLICATION_DATE_FIELD_TYPE
8
8
PUBLICATION_INSTANCE_ID
20
20