Delphix Toolkits (dxToolkit and dxmToolkit)

 View Only

  • 1.  Exclude few DBs from dx_ctl_db stop operation

    Posted 10-01-2021 05:49:00 AM
    Hi,

    We have requirement to shutdown all the VDBs in each Engine except few VDBs.
    I don't find any such option to specify exclude list in dx_ct_db command.

    Please check and suggest how this can be achieved, as this is always an issue during most of the maintenance activity and we need some fix/workaround for this.

    Thanks,
    Sushil

    ------------------------------
    Sushil Krishn
    [Database Administrator]
    Unisys
    ------------------------------


  • 2.  RE: Exclude few DBs from dx_ctl_db stop operation

    Posted 10-01-2021 07:15:00 AM
    Edited by Mouhssine Saidi 10-01-2021 07:16:54 AM
    Hi Sushil,

    First of all the "name" parameter takes only one value so you can't provied it with a list.

    Did you look into other options you can use with those parameters :

    -group group_name
    -host host_name
    -olderthan
    -dsource dsource_name
    -envname

    If you can still not achieve your need with any, you ca, mix up shell with dxtoolkit to get something sweeting your goal.

    Sample script using shell with a provided list of vdbnames to control with dxtoolkit

    for VDBNAME in vdb1 vdb2 vdb3 vdb4; do

      # stop a list of databases
    dx_ctl_db -d Landshark5 -name $VDBNAME -action stop

    done 

    Best,

    ------------------------------
    Mouhssine Saidi
    Technical Services
    Delphix
    ------------------------------

    Original Message


  • 3.  RE: Exclude few DBs from dx_ctl_db stop operation

    Posted 10-01-2021 07:23:00 AM
    Hi Mouhssine, 
    Thanks for the update. But, we have more than 15 Engines and 50+ different groups, managing through custom shell script etc can't be appropriate option as it also restrict to set parallel options.

    We have exclusion requirement for one specific group only.
    If a command switch available to exclude can be provided it will be really helpful, and may be good for others as well for any similar requirement.
    Hoping the dxtoolkit developers can review this to consider on priority.

    Regards,
    Sushil


    ------------------------------
    Sushil Krishn
    [Database Administrator]
    Unisys
    ------------------------------

    Original Message


  • 4.  RE: Exclude few DBs from dx_ctl_db stop operation

    Posted 10-01-2021 07:31:00 AM

    Hi Sushil,

    Maybe best you have to talk with your delphix sales rep. regarding (DCT - aka Data Contro Tour).

    You can find more about it in our public documentation https://docs.delphix.com/dct

    Best



    ------------------------------
    Mouhssine Saidi
    Technical Services
    Delphix
    ------------------------------

    Original Message


  • 5.  RE: Exclude few DBs from dx_ctl_db stop operation

    Posted 10-01-2021 08:27:00 AM
    I think DCT is a different topic itself. We are already in touch with our Customer Success Manager and DCT team on that.

    I posted this dxtoolkit concern to simply provide an easy option as filter option/switch to exclude something. Hope this will be reviewed by dxtoolkit developers for appropriate action, if it looks feasible to implement.

    Regards,
    Sushil

    ------------------------------
    Sushil Krishn
    [Database Administrator]
    Unisys
    ------------------------------

    Original Message


  • 6.  RE: Exclude few DBs from dx_ctl_db stop operation

    Posted 10-01-2021 09:52:00 AM
    Hi Sushil,

    If I understand you correctly - you would like to have a command to works like this

    dx_ctl_db -type VDB -group "! groupname"

    and it will shut down all VDB but not the one in the groupname specified ? 

    I wonder if you have different use cases as well ?

    regards,
    Marcin

    ------------------------------
    Marcin Przepiorowski
    Technical Manager
    Delphix
    ------------------------------

    Original Message


  • 7.  RE: Exclude few DBs from dx_ctl_db stop operation

    Posted 10-01-2021 11:12:00 AM
    Hi Marcin,

    You are right, this is exactly what I am suggesting to have, good to consider for stop/start both options.
    Can you review if this is possible to implement this. As of now this is what I am looking for.

    Thanks,
    Sushil

    ------------------------------
    Sushil Krishn
    [Database Administrator]
    Unisys
    ------------------------------

    Original Message


  • 8.  RE: Exclude few DBs from dx_ctl_db stop operation

    Posted 02-17-2022 10:16:00 AM
    Hi Marcin,

    Following-up on this request from Oct 2021, can you check if its possible to incorporate option to exclude a group for start/stop of DB operation?
    This is something we need for every maintenance and is very much needed.

    Thanks,
    Sushil

    ------------------------------
    Sushil Krishn
    [Database Administrator]
    Unisys
    ------------------------------

    Original Message


  • 9.  RE: Exclude few DBs from dx_ctl_db stop operation

    Posted 03-01-2022 09:34:00 AM
    Hi,

    I am sorry but this feature is not yet implemented.

    regards,
    Marcin

    ------------------------------
    Marcin Przepiorowski
    Director, Technical Services
    Delphix
    ------------------------------

    Original Message


Related Content