Collection instructions for SQL.GZ files for Avamar profile

Live Optics Agent

Overview

Live Optics allows you, your Dell EMC technologists, or Dell EMC partner consultants to understand vital information about your Avamar environment. To start, it is important to gather the pertinent data files of your backup environment. Live Optics provides you with a simple process to gather, parse and, ultimately, present your data in a clear and understandable way, so that you can make informed decisions to optimize your backup infrastructure.

Pre-Requisites

In order to follow the instructions below, the End User collecting the Avamar SQL.GZ files must have administrative access to Avamar Grid.

Quick-Start Directions

  1. Login to Avamar using SSH
  2. Navigate to directory where SQL.GZ file will be saved
  3. Issue command to GZIP Avamar SQL files
  4. Verify the file was created successfully
  5. Send SQL.GZ file to Dell EMC sales rep or Dell EMC Partner for processing.  

Detailed Instructions

Step 1: Login to Avamar via SSH

  • Using your favorite SSH client, connect to your Avamar server 

Step 2: Navigate to directory where SQL.GZ file will be saved

  • Use the cd command to navigate to a directory where the Avamar file will be saved

 

Step 3: Create SQL.GZ file

  • Use the following command to create the SQL.GZ file in your directory
gzip /usr/local/avamar/var/mc/server_data/mcs_data_dump.sql -c > /tmp/mcs_$HOSTNAME.sql.gz  

 

Step 4: Verify the file was saved in your directory

  • From the directory where you saved the SQL.GZ file, type "ls -la" to verify the SQL.GZ file is listed

 

Step 5: Send files to Dell EMC sales team or Dell EMC partner for processing

  • The sales team that receives your file will generate a PPTX report for Avamar and send it back to you for review.
Was this article helpful?
0 out of 0 found this helpful
  • 0
    Avatar

    Lukas Volkening

    Hello,

    The comment mentioned has not the right syntax. The -c musst follow the filename. Otherwise gzip tries to zip -c which doesn't work, following it zips the original file and at the end creates an empty file with the given name.

    Here is the correct syntax:
    gzip /usr/local/avamar/var/mc/server_data/mcs_data_dump.sql -c > /tmp/mcs_$HOSTNAME.sql.gz

    Comment actions Permalink
  • 0
    Avatar

    Ryan McKee

    Thanks for the correct syntax.  Also we need to update this guide so it instructs the customer to use WinSCP (or something similar) to navigate to root /tmp and download the gzip from the appliance to local desktop to upload to the LO Collector.  

    Comment actions Permalink
  • 0
    Avatar

    Robert Gregory

    So Ryan, Why were these instructions not updated yet?

    Could save us lots of headaches.

    When do you think the instructions will be updated?

    Thanks,

    Comment actions Permalink
  • 0
    Avatar

    Mike Mahler

    Hi Lukas, Ryan and Robert,  I'm the DPS Product Manager for Live Optics, thanks for your interest and feedback!

    Lukas,

    RE: positional dependency of the -c arg: gnu/man page specifies -c can (but possibly not should) be located as first arg to gzip and it works fine (both ways as I show here):

    user@host~
    $ ls -l attrib.txt
    -rw-r--r-- 1 user Domain Users 235435989 Feb 6 08:41 attrib.txt

    user@hostname~
    $ gzip attrib.txt -c > attribout.gz

    user@hostname ~
    $ ls -l attribout.gz
    -rw-r--r-- 1 user Domain Users 22559348 Apr 6 18:55 attribout.gz

    user@hostname ~
    $ gzip -c attrib.txt > attribout.gz

    user@hostname ~
    $ ls -l attribout.gz
    -rw-r--r-- 1 user Domain Users 22559348 Apr 6 18:56 attribout.gz

    Of course you may have other experiences on other platforms or just be aware of missed opportunities with the current format, I'd be glad to discuss.  Feel free to reach out to me!

    Ryan, in the same spirit, I'm glad to discuss best practices of file transferring in this case!

    Robert, I'l update the instructions and docs with whatever we determine is needed, thanks!

    Thank you very much!

    Mike

     

    Comment actions Permalink
  • 0
    Avatar

    Mike Mahler

    While the canonical command reference guides say that -c is not positional dependent, it appears as some implementations expect it to be after the to-be-compressed file.  Please note we've updated the syntax of the gzip command in the instructions to provide more robust acceptance across *nix implementations. 

     

    Comment actions Permalink
Please sign in to leave a comment.