IBM Data & AI

Welcome to the idea forum for IBM Data & AI (Formerly Analytics) Clients! 


IBM Employees:

The correct URL for entering your ideas is



Our team welcomes any feedback  and suggestions you have for improving our offerings / products!  This forum allows us to connect your offering / product improvement ideas with IBM product and engineering teams.


If you have not registered on this portal please click on the following link and register.  To complete registration you will need to open the email you will receive from Aha to confirm your identity.


Temporal Tables by default in vNext Db2 Optim Directory

We want to set up an automated purge of Optim Archives but would like to preserve the metadata about each archive so we can do time travel queries to track the lifecycle of our archives.  This might, could or should be a requirement for records management. legal purposes.

  • Guest
  • Dec 14 2018
  • Need More Information
Customer Name
Role Summary Database Administrators, records manangement users
  • Attach files
  • Admin
    Peter Costigan commented
    December 14, 2018 17:59



    1.  Optim should be able to work fine with the Optim Directory tables in Db2 defined as System Temporal Tables.  Have you tried this already?

    2.  Is this request for Optim Distributed with its Optim Directory in Db2 LUW?  Or Optim native z/OS with its Optim Directory in Db2 for z/OS?

    Thank you,


  • Guest commented
    December 14, 2018 17:59

    Hi Peter,

    We have not tried it. I will add that to the agenda of our next team meeting to possibly give it a try. So it sounds like IBM would still support our directory then. We are running our Optim directories in Db2 V10.5 on RHEL.

NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "anonymous@euprivacy.out" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions