Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    84

    Unanswered: exporting LOB related tables and loading back.

    Hi,
    I have a DB2 8.1.5 DB where I loaded data from Oracle using MTK.
    I want to export the data and load them back..(I inherited the script and responsible for maintaining from now on)..

    Here is the syntax I am using for importing data back into empty schema.
    -------------
    db2move agile import -io insert -u db2admin -p agile
    db2 import from tab8.ixf of ixf lobs from D:\Agile9DB2Tmp\ modified by lobsinfile insert into ADMIN_HISTORY_DETAILS
    -----------------------------
    db2move to load the regular data and db2 import to load LOB related tables.

    When I looked at the existing scripts, DB2 export is exporting the lob related tables as
    tab01.ixf, tab01.msg, tab1a.001 while for regular tables, it is exporting as tab02.ixf, tab02.msg only. What will be the export command that does that?
    Thanks.
    Kishore

  2. #2
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by kingno1
    Hi,
    I have a DB2 8.1.5 DB where I loaded data from Oracle using MTK.
    I want to export the data and load them back..(I inherited the script and responsible for maintaining from now on)..

    Here is the syntax I am using for importing data back into empty schema.
    -------------
    db2move agile import -io insert -u db2admin -p agile
    db2 import from tab8.ixf of ixf lobs from D:\Agile9DB2Tmp\ modified by lobsinfile insert into ADMIN_HISTORY_DETAILS
    -----------------------------
    db2move to load the regular data and db2 import to load LOB related tables.

    When I looked at the existing scripts, DB2 export is exporting the lob related tables as
    tab01.ixf, tab01.msg, tab1a.001 while for regular tables, it is exporting as tab02.ixf, tab02.msg only. What will be the export command that does that?
    Thanks.
    EXPORT TO xxx.ixf LOBS TO /directory/where/lobs/go LOBFILE tab1a modified by lobsinfile select...
    --
    Jonathan Petruk
    DB2 Database Consultant

Posting Permissions

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