Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2013
    Posts
    80

    Unanswered: Import CLOB Column causing database halt

    hi All,
    Anyone encounter the database halt after perform import CLOB column whether using db2 load or import command ?

    Additional information, is the table is belongs to tablespace with raw device container. I will try to create a table with filesystem container to test load CLOB colummn records tmr.

    Thanks.

  2. #2
    Join Date
    Aug 2013
    Posts
    80
    Another information, I can insert 1 row but more than that will facing error and db will halt.

  3. #3
    Join Date
    Feb 2014
    Posts
    13
    what is the type of data for CLOB ?
    bufferpool size of that particular table residing tablespace ?

  4. #4
    Join Date
    Aug 2013
    Posts
    80
    Just tested that the table with LOB created in RAW DEVICE will encounter database halt, once I change the tablespace to use the FILESYSTEM, the problem resolved. But anyone can shed me some light why tablespace with raw device will encounter this issue ? Any special setting required ?

  5. #5
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by ckwan123 View Post
    why tablespace with raw device will encounter this issue ?
    I'm sure db2diag.log has more information about your problem than people on the other end of the internet.
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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