Delphix Toolkits (dxToolkit and dxmToolkit)

 View Only
  • 1.  Getting physical size info for each engine

    Posted 01-05-2024 02:45:00 AM
    Edited by Emrah Kaan Akyol 01-05-2024 03:21:51 AM

    Hi All,

    With one of our customer, we would like to get physical size of source databases for each engine.

    We have executed below command and get the result. Can someone confirm if the size seen below (bold) is the physical size of source database?

    Command:

    dx_get_db_env -engine delphix01-type dsource -format json -debug >delphix01.txt

    Result:

       "results" : [
          {
             "Hostname" : "CLUSTER",
             "Group" : "1.1 XX_SRC",
             "Type" : "dSource",
             "Database" : "XX_SRC",
             "SourceDB" : "",
             "Enabled" : "enabled",
             "Appliance" : "delphix01",
             "VDB refresh time" : "N/A",
             "Parent snapshot" : "N/A",
             "Used [GB]" : "    108.21",
             "Parent time" : "N/A",
             "VDB creation time" : "2022-09-05 05:50:02",
             "Unique Name" : "XX",
             "Status" : "RUNNING"
          },
          {
             "Status" : "RUNNING",
             "Unique Name" : "YY",
             "Parent time" : "N/A",
             "VDB creation time" : "2022-09-05 11:38:33",
             "Used [GB]" : "    276.80",
             "SourceDB" : "",
             "Enabled" : "enabled",
             "Parent snapshot" : "N/A",
             "Appliance" : "delphix01",
             "VDB refresh time" : "N/A",
             "Hostname" : "CLUSTER",
             "Type" : "dSource",
             "Group" : "1.2 YY_SRC",
             "Database" : "YY_SRC"
          }
       ]
    }

    Thanks in advance

    #documentation #knowledgebase #dxToolkit #DevOpsDataPlatform

    ------------------------------
    Emrah Kaan Akyol
    Customer Operations Director
    Accuras DMCC
    ------------------------------



  • 2.  RE: Getting physical size info for each engine
    Best Answer

    Posted 01-05-2024 05:58:00 AM

    Below command gave what is needed;

    dx_get_dsourcesize -d delphix01 -license -format json -debug >delphix01_size.txt



    ------------------------------
    Emrah Kaan Akyol
    Customer Operations Director
    Accuras DMCC
    ------------------------------