as i posted here
import lob and xml on sametime

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

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

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?

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

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"

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.

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.

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..