Delphix Products

  • 1.  where+can+i+find+the+provision+date+of+a+vdb

    Posted 06-02-2016 01:36:00 PM
    I want to know the date a vdb was provisioned from


  • 2.  RE: where+can+i+find+the+provision+date+of+a+vdb

    Posted 06-02-2016 02:04:00 PM
    Hi Christine,

    The creation date isn't presented in the GUI, but you can get to it via the CLI.
    Just ssh to the Delphix Engine as the same user/password you use in the GUI, and run (changing "vdb1" for whatever database you want):

    /database/select vdb1  ls

    You will then get a listing of various details, including the "creationTime".

    Hope that helps,

    Scott.


  • 3.  RE: where+can+i+find+the+provision+date+of+a+vdb

    Posted 06-02-2016 02:16:00 PM

    Thanks!


    I don't see creationTime - but it does show currentTimeflow -

    currentTimeflow: 'DB_PROVISION@2014-10-15T13:27:40'

    I assume that is my provision time - thanks a lot.




  • 4.  RE: where+can+i+find+the+provision+date+of+a+vdb

    Posted 06-02-2016 02:27:00 PM
    Hi Christine,

    That time will also be the creation time, but only while you're on the original timeflow, if you refresh or rewind the VDB, then the timeflow name will change to reflect that, and the timstamp will refer to that time instead of when the VDB was actually created. If the timeflow name starts with "DB_PROVISION" then it can be read as creation time.

    On my test server (running 5.0.3.0) I get these first few lines, creation date is listed on 4th line:

        type: OracleDatabaseContainer
        name: vdb1
        contentType: NON_CDB
        creationTime: 2016-05-25T09:53:50.973Z
        crossPlatformReady: false
        currentTimeflow: 'DB_PROVISION@2016-05-25T10:53:55'
        databaseFraction: false ...

    perhaps this changed in one of the releases, can you tell me which version you are running and I'll look into it?






  • 5.  RE: where+can+i+find+the+provision+date+of+a+vdb

    Posted 06-02-2016 02:33:00 PM
    I am on 4.2.4.0 currently - plan is place to upgrade to 5.0.3.0 next week.


  • 6.  RE: where+can+i+find+the+provision+date+of+a+vdb

    Posted 06-03-2016 08:34:00 AM
    Hi Christine,
    I installed a release 4.2.4.0 Engine, added a dSource and provisioned a VDB.
    When I then list this in the CLI I am still getting the creationTime reported:
    delphix4240 database 'vdb2'> ls
    Properties
        type: OracleDatabaseContainer
        name: vdb2
        contentType: NON_CDB
        creationTime: 2016-06-03T09:21:13.464Z             <<< Here.
        crossPlatformReady: false
        currentTimeflow: 'DB_PROVISION@2016-06-03T02:21:19'
        ...
    could you paste the full output you are getting here? You should be seeing this on the version you are running.

    Thanks,

    Scott.


  • 7.  RE: where+can+i+find+the+provision+date+of+a+vdb

    Posted 06-10-2016 05:54:00 AM
    Hi Christine - I wanted to let you know that we've logged the enhancement request to display the provision date for a VDB in the GUI, and will see about implementing that in a future release. 

    Thanks!