Results 1 to 3 of 3

Thread: load reorg

  1. #1
    Join Date
    Oct 2007
    Posts
    246

    Unanswered: load reorg

    hi

    export the in del and ixf format

    do load of ixf or del file on table and recreation on index requires
    reorg again ??

    kindly suggest
    regds
    paul

  2. #2
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    I'd say no. Even when you have a clustered index the load-process load the data sorted in the right order. Needless to say that a runstats cannot be omitted.

  3. #3
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399
    from 9.5 documention:

    Data is loaded in the sequence that appears in the input file, except when using multidimensional clustering (MDC) tables, partitioned tables, or the anyorder file type modifier. If a particular sequence is desired, sort the data before attempting a load operation. If clustering is required, the data should be sorted on the clustering index prior to loading.

    see Loading data

    which means that yes, you need to reorg it. Or I guess you can sort it when you export data from source table so you get pre-sorted data file.
    Last edited by MarkhamDBA; 01-21-10 at 14:38.
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

Posting Permissions

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