Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2002
    Location
    ATL
    Posts
    170

    Unanswered: Export in IXF format

    I have bunch of tables in a tablespace. I want to export all these tables and recreate them in the same tablespace.

    If i export in IXF format , does it gather all the views , triggers , aliases , grants associated with these tables ?

  2. #2
    Join Date
    Jul 2002
    Location
    ATL
    Posts
    170
    Looks like IXF format only export the table structure with indexes.

    What is the best way to extract every depending object of a table.

    I tried db2look with -t option and it is not of much help. Any suggestions !!!!

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    db2look should get what you want, but you may have to use some other options in addtion to the -t. I will let you do the detail research on that.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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