OS/DB Migration Question

[Former Member]

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

[former_member709110]

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