Delphix Products

We know that using Delphix tool kit , we can create bookmark and delete bookmark, however

1. How to schedule to create bookmark for all the containers in the Delphix engine
2. How to report ( using email notification ) report the Delphix self service user to remind to delete the bookmark ( what is the dxtoolkit file name to achieve this)

Please share any documents available in delphix to acheive this. Appreciate any help and support from the Delphix community.

------------------------------
PETER SURESH JAYARAJ
DBA
Israel Discount Bank of New York
------------------------------

Hi Peter.

1. There is no feature in DXToolkit to schedule bookmark creation. If you want to schedule an action you will have to use some external tool, i.e. crontab, to execute that script that: retrieves all the containers in a given engine (dx_get_js_containers) and creates a bookmark for each of them (dx_ctl_js_bookmarks).
2. Again, there is no DXToolkit feature to send notifications via email. If you want to do this you will need an external tool. In any case, you can agree with the end users on the expire date for the bookmarks and set one upon bookmark creation with the -expireat parameter.

We know that using Delphix tool kit , we can create bookmark and delete bookmark, however

1. How to schedule to create bookmark for all the containers in the Delphix engine
2. How to report ( using email notification ) report the Delphix self service user to remind to delete the bookmark ( what is the dxtoolkit file name to achieve this)

Please share any documents available in delphix to acheive this. Appreciate any help and support from the Delphix community.

------------------------------
PETER SURESH JAYARAJ
DBA
Israel Discount Bank of New York
------------------------------

Hi Jose,

Appreciate your response on my questions and is very helpful to focus further on the available opportunities to make it happen. Thank you so much.

 -expireat   > Will  this parameter remove the bookmarks created automatically after certain condition ( time)

Thanks,
Peter

------------------------------
PETER SURESH JAYARAJ
DBA
Israel Discount Bank of New York

Original Message:
Sent: 03-05-2024 03:04:51 AM
From: Jose Manuel Rodriguez Prieto
Subject: Bookmark creation automation and notify self service user about expired bookmarks

Hi Peter.

1. There is no feature in DXToolkit to schedule bookmark creation. If you want to schedule an action you will have to use some external tool, i.e. crontab, to execute that script that: retrieves all the containers in a given engine (dx_get_js_containers) and creates a bookmark for each of them (dx_ctl_js_bookmarks).
2. Again, there is no DXToolkit feature to send notifications via email. If you want to do this you will need an external tool. In any case, you can agree with the end users on the expire date for the bookmarks and set one upon bookmark creation with the -expireat parameter.

------------------------------
Jose Manuel Rodriguez Prieto
Technical Account Manager
Delphix

Original Message:
Sent: 03-02-2024 07:03:49 PM
From: PETER SURESH JAYARAJ
Subject: Bookmark creation automation and notify self service user about expired bookmarks

We know that using Delphix tool kit , we can create bookmark and delete bookmark, however

1. How to schedule to create bookmark for all the containers in the Delphix engine
2. How to report ( using email notification ) report the Delphix self service user to remind to delete the bookmark ( what is the dxtoolkit file name to achieve this)

Please share any documents available in delphix to acheive this. Appreciate any help and support from the Delphix community.

------------------------------
PETER SURESH JAYARAJ
DBA
Israel Discount Bank of New York
------------------------------

In addition,

I am using dxtoolkit2-v2.4.13-win64-installer. ( Is any latest version available)

 help command shows that bookmark creation time (Shown above), however when I run the command against the Delphix engine, the bookmark creation time shows as NA.

.\dx_get_js_bookmarks -help

EXAMPLES
    List all bookmarks

     dx_get_js_bookmarks -d Landshark5

     Appliance            Bookmark name                  Bookmark time                  Template name                  Container name                 Branch name
     -------------------- ------------------------------ ------------------------------ ------------------------------ ------------------------------ --------------------
     Landshark5           Before insert                  2016-10-25 08:41:34 IST        Oracle dSource template        Dev container                  default
     Landshark5           BookmarkNOW                    2016-11-08 16:46:35 GMT        Oracle dSource template        Dev container                  default

Actual command output,

.\dx_get_js_bookmarks -d < Engine_Name> 

Use of uninitialized value in string eq at C:\Users\...\AppData\Local\Temp\7\par-4442412d53514c2d41646d696e2d554154\cache-b962869b006bc53eb3f769c7ae52fa114d6f7c17\inc\lib/Engine.pm line 1059.

Appliance            Bookmark name                  Bookmark time                  Template name                  Container name                 Branch name          Branch full name
-------------------- ------------------------------ ------------------------------ ------------------------------ ------------------------------ -------------------- ------------------------------
<Engine_Name>  Test                           N/A                            N/A                            Appli_ENV-Appli-3        default              N/A/Applit_ENV-Appli-3/de

Could anyone explain what was the reason and how to mitigate?

Thanks,

Peter

------------------------------
PETER SURESH JAYARAJ
DBA
Israel Discount Bank of New York

Original Message:
Sent: 03-07-2024 03:06:55 PM
From: PETER SURESH JAYARAJ
Subject: Bookmark creation automation and notify self service user about expired bookmarks

Hi Jose,

Appreciate your response on my questions and is very helpful to focus further on the available opportunities to make it happen. Thank you so much.

 -expireat   > Will  this parameter remove the bookmarks created automatically after certain condition ( time)

Thanks,
Peter

------------------------------
PETER SURESH JAYARAJ
DBA
Israel Discount Bank of New York

Original Message:
Sent: 03-05-2024 03:04:51 AM
From: Jose Manuel Rodriguez Prieto
Subject: Bookmark creation automation and notify self service user about expired bookmarks

Hi Peter.

1. There is no feature in DXToolkit to schedule bookmark creation. If you want to schedule an action you will have to use some external tool, i.e. crontab, to execute that script that: retrieves all the containers in a given engine (dx_get_js_containers) and creates a bookmark for each of them (dx_ctl_js_bookmarks).
2. Again, there is no DXToolkit feature to send notifications via email. If you want to do this you will need an external tool. In any case, you can agree with the end users on the expire date for the bookmarks and set one upon bookmark creation with the -expireat parameter.

------------------------------
Jose Manuel Rodriguez Prieto
Technical Account Manager
Delphix

Original Message:
Sent: 03-02-2024 07:03:49 PM
From: PETER SURESH JAYARAJ
Subject: Bookmark creation automation and notify self service user about expired bookmarks

We know that using Delphix tool kit , we can create bookmark and delete bookmark, however

1. How to schedule to create bookmark for all the containers in the Delphix engine
2. How to report ( using email notification ) report the Delphix self service user to remind to delete the bookmark ( what is the dxtoolkit file name to achieve this)

Please share any documents available in delphix to acheive this. Appreciate any help and support from the Delphix community.

------------------------------
PETER SURESH JAYARAJ
DBA
Israel Discount Bank of New York
------------------------------

In addition,

I am using dxtoolkit2-v2.4.13-win64-installer. ( Is any latest version available)

 help command shows that bookmark creation time (Shown above), however when I run the command against the Delphix engine, the bookmark creation time shows as NA.

.\dx_get_js_bookmarks -help

EXAMPLES
    List all bookmarks

     dx_get_js_bookmarks -d Landshark5

     Appliance            Bookmark name                  Bookmark time                  Template name                  Container name                 Branch name
     -------------------- ------------------------------ ------------------------------ ------------------------------ ------------------------------ --------------------
     Landshark5           Before insert                  2016-10-25 08:41:34 IST        Oracle dSource template        Dev container                  default
     Landshark5           BookmarkNOW                    2016-11-08 16:46:35 GMT        Oracle dSource template        Dev container                  default

Actual command output,

.\dx_get_js_bookmarks -d < Engine_Name> 

Use of uninitialized value in string eq at C:\Users\...\AppData\Local\Temp\7\par-4442412d53514c2d41646d696e2d554154\cache-b962869b006bc53eb3f769c7ae52fa114d6f7c17\inc\lib/Engine.pm line 1059.

Appliance            Bookmark name                  Bookmark time                  Template name                  Container name                 Branch name          Branch full name
-------------------- ------------------------------ ------------------------------ ------------------------------ ------------------------------ -------------------- ------------------------------
<Engine_Name>  Test                           N/A                            N/A                            Appli_ENV-Appli-3        default              N/A/Applit_ENV-Appli-3/de

Could anyone explain what was the reason and how to mitigate?

Thanks,

Peter

------------------------------
PETER SURESH JAYARAJ
DBA
Israel Discount Bank of New York

Original Message:
Sent: 03-07-2024 03:06:55 PM
From: PETER SURESH JAYARAJ
Subject: Bookmark creation automation and notify self service user about expired bookmarks

Hi Jose,

Appreciate your response on my questions and is very helpful to focus further on the available opportunities to make it happen. Thank you so much.

 -expireat   > Will  this parameter remove the bookmarks created automatically after certain condition ( time)

Thanks,
Peter

------------------------------
PETER SURESH JAYARAJ
DBA
Israel Discount Bank of New York

Original Message:
Sent: 03-05-2024 03:04:51 AM
From: Jose Manuel Rodriguez Prieto
Subject: Bookmark creation automation and notify self service user about expired bookmarks

Hi Peter.

1. There is no feature in DXToolkit to schedule bookmark creation. If you want to schedule an action you will have to use some external tool, i.e. crontab, to execute that script that: retrieves all the containers in a given engine (dx_get_js_containers) and creates a bookmark for each of them (dx_ctl_js_bookmarks).
2. Again, there is no DXToolkit feature to send notifications via email. If you want to do this you will need an external tool. In any case, you can agree with the end users on the expire date for the bookmarks and set one upon bookmark creation with the -expireat parameter.

------------------------------
Jose Manuel Rodriguez Prieto
Technical Account Manager
Delphix

Original Message:
Sent: 03-02-2024 07:03:49 PM
From: PETER SURESH JAYARAJ
Subject: Bookmark creation automation and notify self service user about expired bookmarks

We know that using Delphix tool kit , we can create bookmark and delete bookmark, however

1. How to schedule to create bookmark for all the containers in the Delphix engine
2. How to report ( using email notification ) report the Delphix self service user to remind to delete the bookmark ( what is the dxtoolkit file name to achieve this)

Please share any documents available in delphix to acheive this. Appreciate any help and support from the Delphix community.

------------------------------
PETER SURESH JAYARAJ
DBA
Israel Discount Bank of New York
------------------------------

Hi Jose,

Appreciate your response on my questions and is very helpful to focus further on the available opportunities to make it happen. Thank you so much.

 -expireat   > Will  this parameter remove the bookmarks created automatically after certain condition ( time)

Thanks,
Peter

Hi Peter.

1. There is no feature in DXToolkit to schedule bookmark creation. If you want to schedule an action you will have to use some external tool, i.e. crontab, to execute that script that: retrieves all the containers in a given engine (dx_get_js_containers) and creates a bookmark for each of them (dx_ctl_js_bookmarks).
2. Again, there is no DXToolkit feature to send notifications via email. If you want to do this you will need an external tool. In any case, you can agree with the end users on the expire date for the bookmarks and set one upon bookmark creation with the -expireat parameter.

We know that using Delphix tool kit , we can create bookmark and delete bookmark, however

1. How to schedule to create bookmark for all the containers in the Delphix engine
2. How to report ( using email notification ) report the Delphix self service user to remind to delete the bookmark ( what is the dxtoolkit file name to achieve this)

Please share any documents available in delphix to acheive this. Appreciate any help and support from the Delphix community.

------------------------------
PETER SURESH JAYARAJ
DBA
Israel Discount Bank of New York
------------------------------

Hi Peter,

Are you aware that you can create a bookmark in the container template that all the containers can access - I'm not sure if this is what you want to achieve but it's a good way to create a common point in time that all of the containers can restore to.  Often this is done as a common Before End-of-day or After End-of-day backup; points in time that developers generally tend to be interested in!

To automate this you can place the bookmark creation script in the dSource pre-sync Hook API point.  It depends how often you sync of course as it may create too many bookmarks for your needs, in which case you'll need to take Jose's external tool approach.

------------------------------
Gary Hallam
Director, Channel Business EMEA, APAC

Original Message:
Sent: 03-07-2024 03:06:55 PM
From: PETER SURESH JAYARAJ
Subject: Bookmark creation automation and notify self service user about expired bookmarks

Hi Jose,

Appreciate your response on my questions and is very helpful to focus further on the available opportunities to make it happen. Thank you so much.

 -expireat   > Will  this parameter remove the bookmarks created automatically after certain condition ( time)

Thanks,
Peter

------------------------------
PETER SURESH JAYARAJ
DBA
Israel Discount Bank of New York

Original Message:
Sent: 03-05-2024 03:04:51 AM
From: Jose Manuel Rodriguez Prieto
Subject: Bookmark creation automation and notify self service user about expired bookmarks

Hi Peter.

1. There is no feature in DXToolkit to schedule bookmark creation. If you want to schedule an action you will have to use some external tool, i.e. crontab, to execute that script that: retrieves all the containers in a given engine (dx_get_js_containers) and creates a bookmark for each of them (dx_ctl_js_bookmarks).
2. Again, there is no DXToolkit feature to send notifications via email. If you want to do this you will need an external tool. In any case, you can agree with the end users on the expire date for the bookmarks and set one upon bookmark creation with the -expireat parameter.

------------------------------
Jose Manuel Rodriguez Prieto
Technical Account Manager
Delphix

Original Message:
Sent: 03-02-2024 07:03:49 PM
From: PETER SURESH JAYARAJ
Subject: Bookmark creation automation and notify self service user about expired bookmarks

We know that using Delphix tool kit , we can create bookmark and delete bookmark, however

1. How to schedule to create bookmark for all the containers in the Delphix engine
2. How to report ( using email notification ) report the Delphix self service user to remind to delete the bookmark ( what is the dxtoolkit file name to achieve this)

Please share any documents available in delphix to acheive this. Appreciate any help and support from the Delphix community.

------------------------------
PETER SURESH JAYARAJ
DBA
Israel Discount Bank of New York
------------------------------

Hi Jose,

Appreciate your response on my questions and is very helpful to focus further on the available opportunities to make it happen. Thank you so much.

 -expireat   > Will  this parameter remove the bookmarks created automatically after certain condition ( time)

Thanks,
Peter

Hi Peter.

1. There is no feature in DXToolkit to schedule bookmark creation. If you want to schedule an action you will have to use some external tool, i.e. crontab, to execute that script that: retrieves all the containers in a given engine (dx_get_js_containers) and creates a bookmark for each of them (dx_ctl_js_bookmarks).
2. Again, there is no DXToolkit feature to send notifications via email. If you want to do this you will need an external tool. In any case, you can agree with the end users on the expire date for the bookmarks and set one upon bookmark creation with the -expireat parameter.

We know that using Delphix tool kit , we can create bookmark and delete bookmark, however

1. How to schedule to create bookmark for all the containers in the Delphix engine
2. How to report ( using email notification ) report the Delphix self service user to remind to delete the bookmark ( what is the dxtoolkit file name to achieve this)

Please share any documents available in delphix to acheive this. Appreciate any help and support from the Delphix community.

------------------------------
PETER SURESH JAYARAJ
DBA
Israel Discount Bank of New York
------------------------------

Yes. The parameter accepts a timestamp after which the bookmard will automatically be deleted provided there are no dependencies, i.e. no VDBs, branches, etc. have been created out of it.

Hi Jose,

Appreciate your response on my questions and is very helpful to focus further on the available opportunities to make it happen. Thank you so much.

 -expireat   > Will  this parameter remove the bookmarks created automatically after certain condition ( time)

Thanks,
Peter

Hi Peter.

1. There is no feature in DXToolkit to schedule bookmark creation. If you want to schedule an action you will have to use some external tool, i.e. crontab, to execute that script that: retrieves all the containers in a given engine (dx_get_js_containers) and creates a bookmark for each of them (dx_ctl_js_bookmarks).
2. Again, there is no DXToolkit feature to send notifications via email. If you want to do this you will need an external tool. In any case, you can agree with the end users on the expire date for the bookmarks and set one upon bookmark creation with the -expireat parameter.

We know that using Delphix tool kit , we can create bookmark and delete bookmark, however

1. How to schedule to create bookmark for all the containers in the Delphix engine
2. How to report ( using email notification ) report the Delphix self service user to remind to delete the bookmark ( what is the dxtoolkit file name to achieve this)

Please share any documents available in delphix to acheive this. Appreciate any help and support from the Delphix community.

------------------------------
PETER SURESH JAYARAJ
DBA
Israel Discount Bank of New York
------------------------------

Thank you Jose. Apologies for the delayed response. I will tty to make use of the parameter in the script.

Scheduling, notification I can use any external tool like crontab, PowerShell by combination of scripts.

Is there any dx tool kit parameter to take bookmark for all containers in the engine. Appreciate your help. 

Thanks,
Peter

Yes. The parameter accepts a timestamp after which the bookmard will automatically be deleted provided there are no dependencies, i.e. no VDBs, branches, etc. have been created out of it.

Hi Jose,

Appreciate your response on my questions and is very helpful to focus further on the available opportunities to make it happen. Thank you so much.

 -expireat   > Will  this parameter remove the bookmarks created automatically after certain condition ( time)

Thanks,
Peter

Hi Peter.

1. There is no feature in DXToolkit to schedule bookmark creation. If you want to schedule an action you will have to use some external tool, i.e. crontab, to execute that script that: retrieves all the containers in a given engine (dx_get_js_containers) and creates a bookmark for each of them (dx_ctl_js_bookmarks).
2. Again, there is no DXToolkit feature to send notifications via email. If you want to do this you will need an external tool. In any case, you can agree with the end users on the expire date for the bookmarks and set one upon bookmark creation with the -expireat parameter.

We know that using Delphix tool kit , we can create bookmark and delete bookmark, however

1. How to schedule to create bookmark for all the containers in the Delphix engine
2. How to report ( using email notification ) report the Delphix self service user to remind to delete the bookmark ( what is the dxtoolkit file name to achieve this)

Please share any documents available in delphix to acheive this. Appreciate any help and support from the Delphix community.

------------------------------
PETER SURESH JAYARAJ
DBA
Israel Discount Bank of New York
------------------------------