Delphix Products

  • 1.  How to determine which DB2 logs can be purged via snapshot metadata?

    Posted 04-09-2019 12:49:00 PM
    I am currently testing the new ability to ingest DB2 LUW logs in the newest version of Delphix.  I am having trouble telling which logs can be purged after a snapshot though.  If I purge all the logs that were present at the time of the snapshot, it doesn't seem to ingest the next set of logs correctly.  If I put those logs back in place then it seems to work.  

    From the documentation it says:

    Logs can be purged from your log location after the snapshot operation. The Toolkit will preserve the list of logs which are eligible for purging in the snapshot's metadata. The snapshot metadata can be accessed via the Delphix CLI or API.

    My question is, how do I go about accessing this information?  This isn't something I have done before.

    Thanks
    Jim
    #Virtualization


  • 2.  RE: How to determine which DB2 logs can be purged via snapshot metadata?

    Posted 04-09-2019 01:33:00 PM
    I think I found my answer.

    You have to log into the CLI, then cd to snapshots.  From there select that snapshot you want to view and then in the metadata attribute there is an attribute called listLogPurge which contains a list of the log files that can be purged.




  • 3.  RE: How to determine which DB2 logs can be purged via snapshot metadata?

    Posted 04-09-2019 02:20:00 PM
    Hi Jim,
    I can confirm that the listLogPurge attribute does contain the list of those logs that can be purged. 

    Nicely done, sir.

    Michael


  • 4.  RE: How to determine which DB2 logs can be purged via snapshot metadata?

    Posted 04-09-2019 02:25:00 PM
    If I wanted to build clean-up in to the post script hook, I can do that via the CLI or API I assume, but will I have to supply the login information inside that script?


  • 5.  RE: How to determine which DB2 logs can be purged via snapshot metadata?

    Posted 04-09-2019 03:05:00 PM
    I would like to answer the query.
    You can use either CLI or API to remove the logs. You need to provide login information to access the metadata.

    Another way to achieve the same is :
    1. Create a bash script on your staging host and provide the login information into it.
    2. Execute the bash script using post-Hook.


  • 6.  RE: How to determine which DB2 logs can be purged via snapshot metadata?
    Best Answer

    Posted 04-30-2019 04:29:00 PM