Results 1 to 8 of 8
  1. #1
    Join Date
    Oct 2010
    Posts
    33

    Unanswered: import lob image from client to server

    as i posted here
    http://www.dbforums.com/db2/1660921-...-sametime.html

    i have found solution for importing lob image
    but i have new problem to import lob image from client(xp) to server(debian)

    i have created input.del file
    c:\photo.gif

    and execute command below
    import from c:\input.del of del lobs from c:\input.del modified by lobsinfile insert into figure

    photo.gif and input.del are under c: in client pc

    import success to database on my pc, but failed to database on server

    any tips will be grateful
    thank you

  2. #2
    Join Date
    Jan 2010
    Posts
    335
    Hi,

    the Load-Command searches for the lob-files on the Server. There's a hint in the Documentation that for load-client the lobs-file have to be stored on the DB-Server (and the instance-owner needs access to the Files).
    It's not specified for the Import-Command, but i guess it's the reason for your issue. Try to copy the LOBs to the Server and specify the local path (on the server) in the import-file.

    Cheers
    nvk

  3. #3
    Join Date
    Oct 2010
    Posts
    33
    thank you for your tips

    i uploaded those 2 files(input.del & photo.gif) under my home directory on db2 server.. (\home\me\)

    so i changed input.del file
    from c:\photo.gig to \home\me\photo.gif

    i executed
    import from \home\me\input.del of del lobs from \home\me\input.del modified by lobsinfile insert into figure

    ... but still no success

    or i have to upload under db2 instance directory?

  4. #4
    Join Date
    Jan 2010
    Posts
    335
    Hi,

    could you post the error-message, please? I've to guess now.

    Two Points:
    - Linux uses / instead of \.
    - The Instance Owner might not have access to your Home-Directory. I'ld copy the files to /tmp-Directory

  5. #5
    Join Date
    Oct 2010
    Posts
    33
    sorry the error message in japanese

    the error message kinda sound like this

    SQL3235N utility "LOB" path "/home/db2inst1/db2inst1/pic/input.del" cannot use parameter. code "3"

  6. #6
    Join Date
    Jan 2010
    Posts
    335
    db2 ? SQL3235N

    Explanation:

    One of the following reason codes may apply:

    1 Either the path "<path-name>" is not a valid sqlu_media_list or
    the values provided are not valid. The media_type must be
    SQLU_LOCAL_MEDIA and all path names must be terminated with a
    valid path separator.

    2 There is not enough space on the paths provided for the EXPORT
    utility to hold all the data of type "<type>".

    3 The path "<path-name>" cannot be accessed.

  7. #7
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    LOBS FROM must specify a directory path, not a file, as far as I know. The main data file should only contain file names, without directories.

  8. #8
    Join Date
    Oct 2010
    Posts
    33
    thanks for all your tips above..

    so i have put these 2 files under /tmp on debian server
    - input.del
    - figure.gif

    text inside the input.del file look like this..
    figure.gif

    and run command below
    IMPORT FROM input.del OF DEL LOBS FROM /tmp MODIFIED BY LOBSINFILE INSERT INTO pic

    still no success..

Posting Permissions

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