Results 1 to 7 of 7
  1. #1
    Join Date
    Nov 2003
    Location
    singapore
    Posts
    7

    Question Unanswered: fail to import lob in DB2

    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.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Nov 2003
    Location
    singapore
    Posts
    7
    Originally posted by Marcus_A
    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?

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Nov 2003
    Location
    singapore
    Posts
    7
    Originally posted by Marcus_A
    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.

  6. #6
    Join Date
    Jan 2004
    Posts
    2
    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.

  7. #7
    Join Date
    Jan 2010
    Posts
    67
    Thank you fitzgrad, you saved my life!!!!

Posting Permissions

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