Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2002
    Posts
    8

    Unhappy Unanswered: How to use db2move ? Please help!!!

    Hi,

    1. I have a set of data files and I use this command to import to an existing DB:

    db2move TestDB IMPORT -u MyuserName -p Mypassword
    it works fine,

    2. My question is: HOW do I export from an existing DB ?

    I appreciate very much for your help.

    Pho Nguyen

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: How to use db2move ? Please help!!!

    db2move TestDB EXPORT -u Username -p Password

    In addition, you have the following options:

    tc -- To export tables created by the user
    tn -- Tablenames to export
    sn -- schema names

    eg:

    db2move TestDB EXPORT -tn EMP -u username -p password

    HTH

    Cheers

    Sathyaram








    Originally posted by phonhonguyen
    Hi,

    1. I have a set of data files and I use this command to import to an existing DB:

    db2move TestDB IMPORT -u MyuserName -p Mypassword
    it works fine,

    2. My question is: HOW do I export from an existing DB ?

    I appreciate very much for your help.

    Pho Nguyen

Posting Permissions

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