where+can+i+find+the+provision+date+of+a+vdb

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I want to know the date a vdb was provisioned from
Photo of Christine Gerber

Christine Gerber

  • 90 Points 75 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Scott MacDonald

Scott MacDonald, Staff Engineer

  • 2,522 Points 2k badge 2x thumb
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.
Photo of Christine Gerber

Christine Gerber

  • 90 Points 75 badge 2x thumb

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.


Photo of Joshua Solomin

Joshua Solomin

  • 60 Points
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!
Photo of Scott MacDonald

Scott MacDonald, Staff Engineer

  • 2,522 Points 2k badge 2x thumb
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?




Photo of Christine Gerber

Christine Gerber

  • 90 Points 75 badge 2x thumb
I am on 4.2.4.0 currently - plan is place to upgrade to 5.0.3.0 next week.
Photo of Scott MacDonald

Scott MacDonald, Staff Engineer

  • 2,522 Points 2k badge 2x thumb
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.