Results 1 to 3 of 3

Thread: Clob

  1. #1
    Join Date
    Jan 2009
    Posts
    153

    Unanswered: Clob

    HI Experts,

    How much data can be stored in CLOB and BLOB datatypes?

    Can anyone please tell ,where can i get all the details of all datatypes on DB2?

    TIA

  2. #2
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    This is for DB2 LUW:
    DB2 Database for Linux, UNIX, and Windows

    The limit for BLOB and CLOB is 2GB
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    If you want to use HADR, the max is 1 GB because DB2 will not log a LOB larger than that.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •