Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2009
    Posts
    44

    Unanswered: import table command error

    Hi, I am using db2 V9.5 on windows. From the control center I exported a table in the IXF format using the GUI screens for export. The import of that table works fine when using the GUI, but when I try to import using CLI, it gives the following error. The sql for the import is the very same which is shown when we import using the GUI.
    Where am I going wrong??

    db2 IMPORT FROM "C:\SPs\met_table_export" OF
    IXF MESSAGES "xyz" CREATE INTO DB2ADMIN.metadata;

    SQL3035N The tablename parameter in the target specification is not valid.
    Is it expecting the DB2ADMIN.metadata table to exist already??

  2. #2
    Join Date
    Jul 2009
    Posts
    44
    Resolved.. was a connection issue, a DB restart did the trick

Posting Permissions

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