-
Notifications
You must be signed in to change notification settings - Fork 34
dx_get_hierarchy
Marcin Przepiorowski edited this page Dec 23, 2021
·
5 revisions
dx_get_hierarchy [-engine|d <delphix identifier> | -all ]
[-group group_name | -name db_name | -host host_name | -type dsource|vdb | -instancename instname]
[-parent_engine <delphix identifier>]
[-printhierarchy [c2p|p2c]]
[-format csv|json ]
[-help|? ] [ -debug ]
Get the information about databases hierarchy
Delphix Engine selection - if not specified a default host(s) from dxtools.conf will be used.
- -engine|d Specify Delphix Engine name from dxtools.conf file
- -all Display databases on all Delphix appliance
- -configfile file Location of the configuration file. A config file search order is as follow:
- configfile parameter
- DXTOOLKIT_CONF variable
- dxtools.conf from dxtoolkit location
Filter databases using one of the following filters
- -group Group Name
- -name Database Name
- -host Host Name
- -type Type (dsource|vdb)
- -envname Environment name
- -dsource dsourcename Dsource name
- -instancename instname Instance name
- -reponame name Filter using reponame
Specify a instance number (only with combination with host)
- -instance inst_no Instance number
- -parent_engine delphix identifier When replication between engines is configured, specify a parent engine to the engine from -d parameter.
- -printhierarchy Display a hierarchy of databases (from VDB to dSource) or (from dSource to VDB) c2p represents "child to parent". p2c represents "parent to child" If no value is provided this "child to parent" (c2p) is used.
- -format Display output in csv or json format If not specified pretty formatting is used.
- -help Print this screen
- -debug Turn on debugging
- -nohead Turn off header output
dS snapshot - time of dSource snapshot used to create/refresh a VDB. If there is a chain of VDB's it's a snapshot used to create first one Physical DB - name of physical database used to create dSource First child DB - name of first VDB in chain.
Print database hierarchy on single engine
dx_get_hierarchy -d Landshark51
Appliance Database Group Type dSource dS snapshot Physical DB First child DB
---------- ------------------------------ --------------- -------- ------------------------------ ----------------------------------- ------------------------------ ------------------------------
Landshark5 autotest Analytics VDB Oracle dsource 2017-02-08 09:00:35 EST orcl autotest
Landshark5 AdventureWorksLT2008R2 Sources dSource N/A AdventureWorksLT2008R2 N/A
Landshark5 Oracle dsource Sources dSource N/A orcl N/A
Landshark5 racdba Sources dSource N/A racdba N/A
Landshark5 Sybase dsource Sources dSource N/A pubs3 N/A
Print database hierarchy on replication target engine
dx_get_hierarchy -d Delphix33
Appliance Database Group Type dSource dS snapshot Physical DB First child DB
---------- ------------------------------ --------------- -------- ------------------------------ ----------------------------------- ------------------------------ ------------------------------
Delphix33 racdb@delphix32-2 Sources@delphix dSource N/A racdb N/A
Delphix33 mask1@delphix32-4 Test@delphix32- VDB dSource on other DE N/A N/A N/A
Delphix33 maskedms@delphix32-4 Test@delphix32- VDB dSource on other DE N/A N/A N/A
Delphix33 cloneMSmas Untitled VDB dSource on other DE N/A N/A N/A
Delphix33 mask1clone Untitled VDB dSource on other DE N/A N/A N/A
Delphix33 maskclone Untitled VDB parent deleted N/A N/A N/A
Delphix33 Vracdb_70C Untitled VDB racdb@delphix32-2 2016-09-28 14:57:16 GMT racdb Vracdb_70C
Print database hierarchy on replication target engine with connection to replication source
dx_get_hierarchy -d Delphix33 -parent_engine Delphix32
Appliance Database Group Type dSource dS snapshot Physical DB First child DB
---------- ------------------------------ --------------- -------- ------------------------------ ----------------------------------- ------------------------------ ------------------------------
Delphix33 racdb@delphix32-2 Sources@delphix dSource N/A racdb N/A
Delphix33 mask1@delphix32-4 Test@delphix32- VDB test1 2017-01-30 13:02:53 GMT test1 man
Delphix33 maskedms@delphix32-4 Test@delphix32- VDB tpcc 2017-02-03 12:05:15 GMT tpcc maskedms
Delphix33 cloneMSmas Untitled VDB tpcc 2017-02-03 12:05:15 GMT tpcc maskedms
Delphix33 mask1clone Untitled VDB test1 2017-01-30 09:15:28 GMT test1 man
Delphix33 maskclone Untitled VDB parent deleted N/A N/A N/A
Delphix33 Vracdb_70C Untitled VDB racdb@delphix32-2 2016-09-28 14:57:16 GMT racdb Vracdb_70C
Print database hierarchy chain starting with VDB up to dSource (c2p)
dx_get_hierarchy -d Delphix33 -parent_engine Delphix32 -printhierarchy c2p
Delphix33 : racdb@delphix32-2
Delphix33 : mask1@delphix32-4 --> mask1 --> man --> test1
Delphix33 : maskedms@delphix32-4 --> maskedms --> tpcc
Delphix33 : cloneMSmas --> maskedms@delphix32-4 --> maskedms --> tpcc
Delphix33 : mask1clone --> mask1@delphix32-4
Delphix33 : maskclone
Delphix33 : Vracdb_70C --> racdb@delphix32-2
Print database hierarchy chain starting with dSource up to VDB (p2c)
dx_get_hierarchy -d Delphix33 -parent_engine Delphix32 -printhierarchy p2c
Delphix33 : racdb@delphix32-2
Delphix33 : test1 --> man --> mask1 --> mask1@delphix32-4
Delphix33 : tpcc --> maskedms --> maskedms@delphix32-4
Delphix33 : tpcc --> maskedms --> maskedms@delphix32-4 --> cloneMSmas
Delphix33 : mask1@delphix32-4 --> mask1clone
Delphix33 : maskclone
Delphix33 : racdb@delphix32-2 --> Vracdb_70C
Delphix