Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    121

    Unanswered: does LOB datatype needs any special maintenance ?

    it may be BLOB,CLOB etc. as after deleteing some rows and running runstats,reorg ,space is not reclaimed...

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    The data for BLOBs and CLOBs is not stored in the same space as the regular tablespace that is associated with the table. Also, LOB's do not utilize buffer pools and are read from disk each time (unless they are LOB's associated with the DB2 catalog, in which case they may be stored in the catalog cache).
    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
  •