InfoSphere Optim

 View Only
  • 1.  Older Process Reports

    Posted Fri September 17, 2021 05:43 AM
    Hi All ! 

    I need to see some log for my older archive and delete request's process reports. Is there any way ( or query to repository ) get older process reports ? 

    Best regards,

    ------------------------------
    GunesINAL
    ------------------------------

    #InfoSphereOptim
    #Optim


  • 2.  RE: Older Process Reports

    Posted Mon September 20, 2021 08:57 AM
    Hi,

    All the reports are stored in Optim Repository. Check OPTIM_AUDIT_RECORDS and OPTIM_TRANSACTION_CONTENT tables.

    Basic details are stored in OPTIM_AUDIT_RECORDS table and complete report is stored in OPTIM_TRANSACTION_CONTENT table in XMDATA Column.

    Regards,


    ------------------------------
    Tulasi Das Uppu
    ------------------------------