-
Notifications
You must be signed in to change notification settings - Fork 33
dx_get_dsourcesize
Marcin Przepiorowski edited this page Jan 26, 2023
·
4 revisions
dx_get_dsourcesize [-engine|d <delphix identifier> | -all ]
[-group group_name | -name db_name | -host host_name | -envname env_name ]
[-output_unit K|M|G|T]
[-format csv|json ]
[-license ]
[-help|? ]
[-debug ]
Get the information about dSource sizes. If you want to use those data for ingestion model reporting please use -license option of the script.
Delphix can automatically calculate the usage for Oracle, SQL Server and ASE databases for each Delphix Engine. For other databases, and before the source is connected to the Delphix Engine, you will need to run a query on the source system for the relevant data.
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
- -envname Environment name
- -license Use License API to display dSource sizes
- -output_unit K|M|G|T Display usage using different unit. By default GB are used Use K for KiloBytes, G for GigaBytes and M for MegaBytes, T for TeraBytes
- -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
Display dSources sizes from engine
dx_get_dsourcesize.pl -d Landshark5
Appliance Env name Group Database Size [GB] Status Enabled
---------- -------------------- --------------- ------------------------------ ------------------------------ ------------------------------ ------------------------------
Landshark5 windows2012source Sources AdventureWorks2012 0.00 UNKNOWN disabled
Landshark5 LINUXSOURCE Sources Oracle 121 6.46 UNKNOWN disabled
Landshark5 LINUXSOURCE Sources Oracle 122 7.30 UNKNOWN disabled
Landshark5 LINUXSOURCE Sources test121 7.49 RUNNING enabled
Display dSources sizes from all configured engines in csv format
dx_get_dsourcesize.pl -all -format csv
#Appliance,Env name,Group,Database,Size [GB],Status,Enabled
Landshark5,windows2012source,Sources,AdventureWorks2012,0.00,UNKNOWN,disabled
Landshark5,LINUXSOURCE,Sources,Oracle 121,6.46,UNKNOWN,disabled
Landshark5,LINUXSOURCE,Sources,Oracle 122,7.30,UNKNOWN,disabled
Landshark5,LINUXSOURCE,Sources,test121,7.49,RUNNING,enabled
Display dSource sizes for license
dx_get_dsourcesize -d local -license
# Delphix can automatically calculate the usage for Oracle, SQL Server and ASE databases for each Delphix Engine.
# For other databases, and before the source is connected to the Delphix Engine
# you will need to run a query on the source system for the relevant data.
# No size for FS_ABC. Skipping
Appliance Type Database Size [GB] Timestamp
---------- ---------------------------------------- ---------------------------------------- ------------------------------ ------------------------------
613 MSSQL AdventureWorks2012 0.22 2022-05-13 11:23:03
613 ORACLE PDB19 0.78 2022-05-13 11:23:03
613 ORACLE test19 0.00 2022-05-13 11:23:03
613 ORACLE test19mt 1.97 2022-05-13 11:23:03
Delphix