Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2004
    Posts
    54

    Unanswered: DB2 Udb v8.2.9 - db2move, load with error SQL3025N (-3025)

    Hi!!
    With my DB2 Administration Client (Linux) I'm trying to use db2move utility to start an import (I copy it from my Enterprise server, path bin and bnd), but I have the error below:

    *** ERROR -3025. Check message file tab283.msg!
    *** SQLCODE: -3025 - SQLSTATE:
    *** SQL3025N A parameter specifying a filename or path is not valid.

    The syntax that I'm using is:
    db2move <db name> load -u <username> -p <password>

    From "Message reference":
    "
    For LOAD, verify that each entry in the parameters of type sqlu_media_list: datafile should contain valid filenames; lobpaths copytarget, and workdirectory should contain valid paths on the server including the final separator and a null terminator.
    "

    My problem is that I don't know where are the parameters indicated (sqlu_media_list datafile lobpaths copytarget workdirectory).
    I tried, without success, with -l option..

    Have you idea?

    Best regards,
    Fabio

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Did you
    Check message file tab283.msg
    ? What did you find there?
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Apr 2004
    Posts
    54
    Hi Nick,
    I find some of this:
    SQL3025N A parameter specifying a filename or path is not valid.
    .
    .
    .
    SQL3025N A parameter specifying a filename or path is not valid.

    thanks,
    Fabio

  4. #4
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    you are going to post command that you ran, right?
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  5. #5
    Join Date
    Apr 2004
    Posts
    54
    Yes..but db2move it's not an utility included in Administration client.
    I had to take it from the Enterprise server (same version and fixpack) with db2move.bnd, and then I had to submit on client the instructions below:
    connect to <db name>
    bind /opt/IBM/db2/V8.1/bnd/db2move.bnd blocking all grant public
    connect reset

    thanks,
    F

Posting Permissions

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