Delphix Toolkits (dxToolkit and dxmToolkit)

 View Only
Expand all | Collapse all

dx_snapshot_db use to take snapshot and list the timestamp

  • 1.  dx_snapshot_db use to take snapshot and list the timestamp

    Posted 02-08-2021 01:23:00 PM
    hi - with dx_snapshot_db i can take a snapshot ... Tested it and it works fine. As part of this job is there a way to list the timestamp of that snapshot ?

    ------------------------------
    Srividya Srinivasan
    Community Member
    Fidelity Technology Group, LLC
    ------------------------------


  • 2.  RE: dx_snapshot_db use to take snapshot and list the timestamp

    Posted 02-10-2021 12:05:00 PM
    Hello,

    dx_snapshot_db use the "job" API to query the job status. You can see the Properties and the Query Parameters that are retrievable with the "job" API by going to your Engine and appending "api" to the URL ( http://mydelphixengine.acme.com/api/#job for example). Unfortunately, the timestamp or name of the snapshot are not available as a part of the "job" API.

    There are lots of other types of jobs so I don't know that the snapshot "timestamp" really makes sense in the context of this API.

    You could use a different API to get details of the snapshot itself:
    % ./dx_get_snapshots -engine neal605.dcol1.delphix.com -type dsource -name delphix -startDate "2021-02-10 00:00:00"
    Engine Group Database Snapshot name Start time End time
    ------------------------------ -------------------- ------------------------------ ------------------------------ ------------------------------ ------------------------------
    neal605.dcol1.delphix.com ASE dSources delphix @2021-02-10T12:40:39.400 2021-02-10 12:40:39 EST 2021-02-10 12:40:39 EST


    ------------------------------
    Neal Stack
    Senior Member of Technical Staff
    Delphix
    ------------------------------