Hi

IMPORT FROM D:\Deployment\28112003\DB\ecm_template.IXF of ixf lobs from D:\Deployment\28112003\DB\lobpath modified by lobsinfile insert_update into ECM_TEMPLATE


I have run the above in 8.1.3 WSE(WIN2K) and 7.2.7 EE(WIN2K) without facing error but when running from 7.2.7 admin client(WIN2K) and 8.1.3 WSE(AIX), I'm encountering the following

SQL3040N Unable to use the lobpath/lobfile parameters as
specified. Reason code: "1".

From DB2 message documentaion
=======================
Explanation :

The utility is unable to use the lobpath or lobfile parameters as
specified for the reason given by "<reason-code>". The codes are
listed below.

User Response:

Given for each reason code:


1 The lobpath is not a valid sqlu_media_list or the values
provided are not valid. The media_type must be SQLU_LOCAL_MEDIA
and all pathnames must be terminated with a valid path
separator.
....

I have tried
1. changing the path, changing '/' etc related to the lobpath
2. tried export first before importing
3. run in the actual db server for the AIX machine

but the error is still the same. Any assistance greatly appreciated.

I would use the Control Center to generate the import command syntax and do a Show Command (without submitting) to see what syntax they generate.

the command is indeed derived from the control center... any other tips?

Try putting the path in quotes as in:

IMPORT FROM “D:\Deployment\28112003\DB\ecm_template.IXF” of ixf lobs from “D:\Deployment\28112003\DB\lobpath” modified by lobsinfile insert_update into ECM_TEMPLATE

hi marcus

tks for d prompt response. Still no luck. still same error.

I had the same problem. Try using a '\' after lobpath in your lobs from option. I am assuming the lob file is in the \lobpath directory.