What is BLOB/LOB/DBCLOB?
- A large object is a data type used by DB2 to manage unstructured data. DB2 provides three built-in data types for storing large objects
Creating BLOB Table space:
Ref:Craig mullins article.
CREATE LOB TABLESPACE TDORGCHT
USING STOGROUP DB2NNN
DSSIZE 64 G
CREATE AUXILIARY TABLE DEPT_ORGCHART_TAB
IN DSN8D10A. TDORGCHT
LOB(Large object data) will be stored in different format. We will have LOB locator in Auxilary table.
BLOB is a datatype of the column. In Both Oracle and DB2 the datatypes are the same. Check fo details.