Db2 (On Premises and Cloud)

Expand all | Collapse all

New: New options for the ADMIN_MOVE_TABLE

  • 1.  New: New options for the ADMIN_MOVE_TABLE

    Posted Mon March 30, 2020 11:22 AM
    The ADMIN_MOVE_TABLE now includes two new options: REPORT and TERM. The REPORT option can be used to monitor the progress of table moves. The TERM option can be used to terminate a table move in progress.


  • 2.  RE: New: New options for the ADMIN_MOVE_TABLE

    Posted Wed March 31, 2021 01:00 PM
    Do these new options, REPORT and TERM, extend to db2convert (column organized table conversion)?


  • 3.  RE: New: New options for the ADMIN_MOVE_TABLE

    Posted Thu April 08, 2021 09:34 AM
    db2convert is unchanged in V11. What is your expectation ?


  • 4.  RE: New: New options for the ADMIN_MOVE_TABLE

    Posted Mon March 30, 2020 11:23 AM

    Well, we can already stop db2convert, and the report it gives is pretty nice too, so I'm not unhappy with it or expect it to change.

    I just didn't know if there was anything special about the REPORT and TERM  features for ADMIN_MOVE_TABLE that db2convert could benefit from. I haven't tried these new features, so I was unsure as to what they gave us and since db2convert uses ADMIN_MOVE_TABLE under the covers, was just wondering if it had something like - report as an option...