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: [email protected] ([email protected])

    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 <[email protected]> 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
    [email protected]
    http://members.iiug.org/mailman/listinfo/informix-list

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