Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    Near D.C.
    Posts
    56

    Unanswered: db2move cleanup dmt

    Is there an option that automatically cleans up the left over DMT_randomname tables after a db2move?

    I'd rather use that, than create drop statement/script afterwards.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    What is a DMT table?
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Oct 2003
    Location
    Near D.C.
    Posts
    56
    https://www-304.ibm.com/support/docv...id=swg21409727

    they are permanent "temp" tables created when this is executed.
    one is created for each schema, each time it is run.
    after DMT_ the suffix part of the name is random system generated.
    unfortunately, they are left there after the fact.

    not huge, but still taking up room, not part of the normal organization.
    and if you have a daily process or more, they will accumulate...

    I was hoping to find a cleanup option.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •