Migrating DB2 BLOB to Oracle (1 of 2)

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.

Example:

CREATE LOB TABLESPACE TDORGCHT
  IN DSN8D10A
  LOG NO
  USING STOGROUP DB2NNN
        PRIQTY   144000
        SECQTY   144000
  LOCKSIZE LOB
  LOCKMAX 0
  BUFFERPOOL BP47
  DSSIZE 64 G
  GBPCACHE SYSTEM;
COMMIT;
CREATE AUXILIARY TABLE DEPT_ORGCHART_TAB
  IN DSN8D10A. TDORGCHT
  STORES DSN81010.DEPT
  COLUMN DEPT_ORG_CHART;COMMIT;

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.

About these ads

Have Something to Say? Post Your Comment

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s