The developerWorks Connections platform will be sunset on December 31, 2019. On January 1, 2020, this blog will no longer be available. More details available on our FAQ.
with Tags:
commit
X
X
Can we control the COMMITs in different phases of Admin_move_table ?
On of our customers had this question about commits in different phases of the admin_move_table operation. Documenting our response here for the benefit of other customers as well. Question : In Admin_move_table, db2 will do 4 steps/phases -> INIT, COPY, REPLAY and SWAP. In COPY step, we can see COMMIT_AFTER_N_ROWS (default 10000 rows) is mentioned in KC document: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.db2.luw.sql.rtn.doc/doc/r0055069.html COMMIT_AFTER_N_ROWS - During the COPY... [More]
Tags: commit admin_move_table |
Problem of running index reorg immediately after table reorg
During the reorg we are going through a list of tables that need to be reorged one by one. For each table we are doing the table reorg first : db2 " reorg table $MYUSER.${i} inplace" (where $MYUSER.${i} is each of the table name) Then doing the index rerog : db2 " reorg indexes all for table $MYUSER.${i} allow write access" This might face problem. Even if we add the tablealt lock under the special register ("CURRENT LOCK TIMEOUT") it still might not work correctly. The reason being, Inplace... [More]
Tags: db2 reorg commit table luw index |
