Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2013
    Posts
    2

    Unanswered: Loading blobs from del file

    I'm using IBM Data Movement Tool to migrate a database from DB2Z to DB2 LUW. This tool generates dump files with, for one table, blob data represented as hex within the delimited file. I wish to load this into an equivalent DB2 LUW table. The DB2 LOAD process loads the table without errors but the blob data got interpreted as text.

    My load command is something similar to the following:
    Code:
    load from "/path/to/file"
    of del
    modified by codepage=1208 coldel~ anyorder usedefaults chardel""
    delprioritychar dumpfile="/path/to/dumpfile"
    method p (1,2,3,4,5,6)
    messages "/path/to/messagefile"
    replace into "schema"."tablename"
    (
    "field1",
    "field2",
    "field3",
    "field4",
    "field5",
    "field6"
    )
    for exception "schema_exp"."tablename"
    nonrecoverable
    indexing mode autoselect
    ;
    Am I missing something here ? Any idea / suggestion is welcome.

    Thanks.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    To load LOBs properly you need to specify the LOBS TO and/or MODIFIED BY LOBSINFILE options on both export and load. If IDMT doesn't do it for you then you'd need to move that table manually.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Jul 2013
    Posts
    2
    Thanks for the prompt answer.

    It sounds like what I dreaded but it is strange that an IBM tool made to ease the migration of databases to DB2 is not able to generate "correct" del file, that's why I thought that I was missing something...

Posting Permissions

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