Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2015
    Posts
    7

    Unanswered: Import command from Db2 client

    Hello,

    Is it possible to use Db2 import command to import csv file to DB using Db2 client? I couldnt find db2 import command in Db2 client, I am using DB visualizer to connect to Db2.

    Thanks,

  2. #2
    Join Date
    May 2012
    Location
    Canberra, Australia
    Posts
    176
    Provided Answers: 6
    Yes but
    Utility access to Linux, UNIX, or Windows database servers from Linux, UNIX, or Windows clients must be a direct connection through the engine and not through a DB2 Connect™ gateway or loop back environment
    http://www-01.ibm.com/support/knowle...0%2F3-6-2-4-58
    Andy

    "All parts should go together without forcing. You must remember that the parts you are reassembling were disassembled by you. Therefore, if you can’t get them together again, there must be a reason. By all means, do not use hammer.” — IBM maintenance manual, 1975 "

  3. #3
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hello,

    Which import command exactly did you run, and which error did you get?
    Regards,
    Mark.

  4. #4
    Join Date
    Apr 2012
    Posts
    1,034
    Provided Answers: 18
    DBVis uses a jdbc driver to communicate with DB2 (normally an IBM supplied driver).
    While DBVis offers a GUI that lets you perform a bulk insert, this is a different activitiy than using a native DB2 import command.
    If you want to use a GUI, then do that, but don't confuse GUI activities with command-line activities.
    If you want instead to use a command-line tool (for example , to make automated scripts etc) then you need to have installed on your workstation a DB2 client, typically at the same-db2-version and same-db2-fixpack as the DB2-server version+fixpack, and most importantly the DB2 client has to include the import command. There are different flavours of DB2 client, some with tiny footprints and limited functionality, others with a large footprint and many commands and utilities - different tools for different job roles and different requirements. Choose the right DB2 client to match your job role and rollout requirements. All this information is available for free on the web at the DB2 Knowledge Center for your version of DB2 and your operating-system - you just have to study it and learn from it.

  5. #5
    Join Date
    May 2012
    Location
    Canberra, Australia
    Posts
    176
    Provided Answers: 6
    Data Studio will allow you do to do a an import/export/load. Consider using it instead as it is the strategic GUI for DB2 even though it has a few limitations/problems
    Andy

    "All parts should go together without forcing. You must remember that the parts you are reassembling were disassembled by you. Therefore, if you can’t get them together again, there must be a reason. By all means, do not use hammer.” — IBM maintenance manual, 1975 "

Tags for this Thread

Posting Permissions

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