1

Topic: Transfer of tables with foreign keys in other tabular spaces.

We have a DB on DB 9.7.10
Table PAY which now occupies 970 million records and is in USERSPASE1
Also there are two foreign keys on tables which also are in USERSPASE1
Deleted foreign keys
Launched transfer to other tabular space
call sysproc.admin_move_table (' PAYSUM ', ' PAY ', ' TS_PAYSUM ', ' TS_PAYSUM ', ' TS_PAYSUM ', ", ' '," ",",'move ');
Question?
It is necessary to transfer tables which  foreign keys with table PAY
Or the difference will not be
Only 7 tables.

2

Re: Transfer of tables with foreign keys in other tabular spaces.

Chumakov_JA;
Depends, I think, from for what you transfer table PAY in separate . If, for example, you plan to do reserve copying separate , that, probably, and costs.

3

Re: Transfer of tables with foreign keys in other tabular spaces.

Forgive passed DB2 9.7.10 ESE
And tabular space USERSPACE1 already is more 512
Therefore problems a part of tables begin transferred to other spaces but in them  foreign keys.