回复 13# wp28556259 当然可以, 文档不是说了吗:)I just did a test. You see I created T1 in sample_data, and moved its index to SAMPLE_IND$db2 -tvf move1.sqlcreate table t1 (c1 int) in SAMPLE_DATADB20000I The SQL command complete...
显示全部回复 13# wp28556259 当然可以, 文档不是说了吗:)
I just did a test. You see I created T1 in sample_data, and moved its index to SAMPLE_IND
$db2 -tvf move1.sql
create table t1 (c1 int) in SAMPLE_DATA
DB20000I The SQL command completed successfully.
insert into t1 values (1)
DB20000I The SQL command completed successfully.
create index i1 on t1 (c1)
DB20000I The SQL command completed successfully.
CALL SYSPROC.ADMIN_MOVE_TABLE( 'DB2ADMIN', 'T1', 'SAMPLE_DATA', 'SAMPLE_IND', 'SAMPLE_DATA', '', '', '', '', '', 'MOVE')
Result set 1
--------------
KEY VALUE
-------------------------------- --------------------------------------------------------------------------------------
AUTHID DB2ADMIN
CLEANUP_END 2011-12-29-21.07.18.449000
CLEANUP_START 2011-12-29-21.07.18.324000
COPY_END 2011-12-29-21.07.17.652000
COPY_OPTS ARRAY_INSERT,NON_CLUSTER
COPY_START 2011-12-29-21.07.17.495000
COPY_TOTAL_ROWS 1
INDEXNAME I1
INDEXSCHEMA DB2ADMIN
INDEX_CREATION_TOTAL_TIME 0
INIT_END 2011-12-29-21.07.17.433000
INIT_START 2011-12-29-21.07.16.886000
REPLAY_END 2011-12-29-21.07.18.089000
REPLAY_START 2011-12-29-21.07.17.652000
REPLAY_TOTAL_ROWS 0
REPLAY_TOTAL_TIME 0
STATUS COMPLETE
SWAP_END 2011-12-29-21.07.18.292000
SWAP_RETRIES 0
SWAP_START 2011-12-29-21.07.18.167000
VERSION 09.07.0001
21 record(s) selected.
Return Status = 0
收起