Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Posts
    4

    Unanswered: db2move export large amount of LOB data

    Hi,

    HP-UX 11.11


    UDB 7.2 Fixpak 6

    I'm trying to export a database using db2move.
    No matter how many lobpaths I specify using db2move -l syntax
    it only uses the first lobpath spcified in sequence.

    This results in SQL3040N and I can't get the LOB data exported.

    Using the export command it would mean tht I have to specify
    about 2000 lobfile to get this 2 million row of lobdata exported.

    Is there a better way ? ( I hope)

    thx,

    Peter

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: db2move export large amount of LOB data

    I came across a similar problem (+ lot of other problems) ... So ended up splitting the data based on date created ...

    HTH

    Cheers

    Sathyaram

    Originally posted by pveck
    Hi,

    HP-UX 11.11


    UDB 7.2 Fixpak 6

    I'm trying to export a database using db2move.
    No matter how many lobpaths I specify using db2move -l syntax
    it only uses the first lobpath spcified in sequence.

    This results in SQL3040N and I can't get the LOB data exported.

    Using the export command it would mean tht I have to specify
    about 2000 lobfile to get this 2 million row of lobdata exported.

    Is there a better way ? ( I hope)

    thx,

    Peter

  3. #3
    Join Date
    May 2003
    Posts
    4

    Re: db2move export large amount of LOB data

    Originally posted by sathyaram_s
    I came across a similar problem (+ lot of other problems) ... So ended up splitting the data based on date created ...

    HTH

    Cheers

    Sathyaram
    I m afraid it is going to be something like that. No command in place ( yet) to do this kind of thing. Anyway I was just curious if you could get db2move
    or a similar command to exceed this limit in handling this type of LOB size/quantity.

    thx,

    Peter

Posting Permissions

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