DP9 - deleting DFMF media

I have some DFMF media as part of an old file library. I managed to delete the file library but DP wont let me delete and export the media. How can I get rid of them??

  • Verified Answer

    Hi ,

    I had to do it today and found this solution in case you want to remove all DFMF File Library media from the IDB. If not, you need to tweak this statement accordingly.

    In any case create an IDB dump using omnidbutil -writedb in advance. Save the following statement as dfmf.sql and execute it using omnidbutil -run_script dfmf.sql -detail. Once done you can export the DFMF media from your pools.

    SELECT * FROM DP_MEDMNG_MEDIUM WHERE DF_SUBTYPE_ID = '4';
    UPDATE DP_MEDMNG_MEDIUM SET DF_SUBTYPE_ID = '0' WHERE DF_SUBTYPE_ID = '4';

    Regards,
    Sebastian Koehler

  • perfect!
    Saved me a lot of time today.
    Thank you so much!!!

    For a dryrun to just check the presence of Type 4 Media:

    SELECT * FROM DP_MEDMNG_MEDIUM WHERE DF_SUBTYPE_ID = '4';

    Row number output should match total media # in file lib pools.