Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2005

    Unanswered: optimizing load with lobs columns

    UDB V8.2 OS solaris.

    Friends ,

    I am trying to load a few tables which has LOB columns.
    One of such table is having a Blob column of BLOB(2097152).
    For this table the load took about 4 days to load about 2 millions of rows (1998509). How coulld i improve this process.

    I have removed the indexes before loading .

  2. #2
    Join Date
    May 2003
    I noticed that a load replace runs much faster than a load with LOBS, even on an empty table. This is especially true when doing a load replace using the db2move utility.
    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