1. Forum
  2. Usenet
  3. COMP.DATABASES.INFORMIX

  • Running dbimport for two databases at the same time

    From Sean Baker@21:1/5 to All on Wed Sep 27 20:47:09 2017
    Hello,

    We're migrating to IDS 12.10.FC9 on RHEL 7.4 in a VMWare environment.

    Our main database takes 2.75 hours to dbimport, and the second largest takes 1.5 hours. We have one large dataspace/chunk for all data.

    I'd like to gain some time by running the dbimport for both databases at the same time. Is there any disadvantage to this? I guess the table data of the two databases will be interleaved? Would it be better to just import them separately?

    Thanks,

    Sean.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Spokey Wheeler@21:1/5 to Sean Baker on Wed Sep 27 22:05:53 2017
    Copy: informix-list@iiug.org (informix-list@iiug.org)

    It’s less likely to be a hassle if your extent sizing is good. If you just use the defaults, it’s going to be terrible.

    On 27 Sep 2017, at 21:47, Sean Baker <SBaker@moneymailer.com> wrote:

    Hello,

    We're migrating to IDS 12.10.FC9 on RHEL 7.4 in a VMWare environment.

    Our main database takes 2.75 hours to dbimport, and the second largest takes 1.5 hours. We have one large dataspace/chunk for all data.

    I'd like to gain some time by running the dbimport for both databases at the same time. Is there any disadvantage to this? I guess the table data of the two databases will be interleaved? Would it be better to just import them separately?

    Thanks,

    Sean.

    _______________________________________________
    Informix-list mailing list
    Informix-list@iiug.org
    http://members.iiug.org/mailman/listinfo/informix-list

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)