Delphix Toolkits (dxToolkit and dxmToolkit)

Expand all | Collapse all

Exclude few DBs from dx_ctl_db stop operation

  • 1.  Exclude few DBs from dx_ctl_db stop operation

    Posted 24 days ago
    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 24 days ago
    Edited by Mouhssine Saidi 24 days ago
    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
    ------------------------------



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

    Posted 24 days ago

    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
    ------------------------------



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

    Posted 24 days ago
    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
    ------------------------------



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

    Posted 24 days ago
    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
    ------------------------------



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

    Posted 24 days ago
    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
    ------------------------------



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

    Posted 24 days ago
    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
    ------------------------------