DB2 CLOB Dbclob

DB2 has three types of large print segments:

CLOB (Character Large OBjects)

For storing single-byte strings, we should consider using CLOB when we want to save more characters than the maximum length of varchar (32K).

Dbclob (double-byte Character Large OBjects)

Dbclob storing double-byte strings

Blob (Binary Large OBjects)

BLOBs store binary strings that are suitable for storing UDTs (user-defined Distinct Types), so we can store images, sounds, and so on.

The maximum length of varchar is determined by the table space of DB2, and the size of a row of data in DB2 cannot exceed the pagesize of the table space. The Clob,dbclob and blob sizes are 2GB.

In general, to improve performance, the database needs to create a dedicated table space for large fields, and the large columns of the data table should store the data in the corresponding table space, because it is not read directly by memory (buffer pool).

DB2 CLOB Dbclob