Results 1 to 2 of 2

Thread: db2move help

  1. #1
    Join Date
    May 2009

    Unanswered: db2move help

    Hi all,
    I am using IBM DB2 9.5.
    I want to export data of all tables in IXf files. for that purpose i have used the command...
    db2move sample export -u userid -p password
    but this creates ixf files but that don't have table name as file name.
    for eg. for table ASSC it should create ASSC.ixf , but instead of that it creates tab1.ixf

    Please help me to resolve this issue.

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    You cannot use db2move to do what you want. Generate a script to do it:

    select 'export to c:\temp\'||rtrim(tabname)||'.ixf of ixf select * from '||rtrim(tabschema)||'.'||rtrim(tabname)||';' from syscat.tables where type - 'T'


Posting Permissions

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