Using DB2’s ADMIN_MOVE_TABLE to Move Tables from One Tablespace to Another

You may also like...

2 Responses

  1. Nice article Ember and thanks for sharing some great example. Just wanted to add couple of points to the above, as many of us use this ADMIN table option unknowingly.

    This utility is indeed useful in Db2 V10.5 aka BLU as well. While you are required to convert a Row Organized table into a Column Organized table in BLU, we use the db2convert utility in 10.5 and that tool itself calls ADMIN_MOVE_TABLE in the background.

  2. raghu says:

    Hi Ember, nice reference, this helped me resolve an issue quickly.

    Found out that SQL may need correction here.

    TYPENAME like ‘%LOB’

    Cheers!!

Leave a Reply

Your email address will not be published. Required fields are marked *