Skip to Content
author's profile photo
Former Member

OS/DB Migration Question

Dear All,

We are doing OS migration , ie from HP Unix to Linux with DB2 9.5 to 9.7

The database size is 2TB , The export has been completed now we are importing into the target database.

We have splitted some of large tables, I would like to know whether can I import splitted tables tables in parallel?

For example I have splitted the table called EBAN into 24(Splits)

my question is can I export and Import this table in parallel?

Export Import

EBAN-1

-


EBAN-1

EBAN-2----


EBAN-2

-


---?

I want to import EBAN-1 ,EBAN-2 ....parallel

But as per the note 454173.

The table is not loaded in parallel (splitted export).

DB2 allows only one LOAD process per table

Regards

Ravikiran.CH

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Posted on May 05, 2011 at 10:22 AM

    My experience is if you submit all the splits in parallel it wont report any error, but it would import sequentially only . So basically you will see more R3load process running than actually import taking place, so its a waste of resources. So spread them.

    And if you are not doing so, that is you have submitted all the splits together, you need to ensure LOCKTIMEOUT is set to -1 , otherwise the waiting R3load process might timeout.

    Regards,

    Neel

    Add comment
    10|10000 characters needed characters exceeded