How to export iRep data from the Data Repository

Products

• Network Observability
• CA Performance Management

Issue/Introduction

The caVerticaUtility.sh script is used to export configuration data and other tables if needed for troubleshooting purposes by Broadcom Support and Enhineering

Environment

Performance Managment, all supported versions

Resolution

1. Locate Your Database Credentials

Find your Data Aggregator (DA) database username (dbUser) in the dbconnection.cfg file on the Data Aggregator server if you are unsure of the user. The location depends on your version:

For version 25.4.4 and later: 

/opt/IMDataAggregator/config/dbconnection.cfg

For version 25.4.3 and earlier: 

/opt/IMDataAggregator/apache-karaf/etc/dbconnection.cfg

You will also need this users database password.

2. Run the Export Utility

Log in to the Data Repository (DR). Use the node where the initial installation was performed if you are on a multi-node cluster.

First, navigate to the Vertica utility directory (replace # with your Vertica version number):

cd /opt/CA/IMDataRepository_vertica#

Next, run the export script, replacing the bracketed placeholders with your specific DA credentials and desired destination folder:

./caVerticaUtility.sh -u [dauser] -w [dapass] -s [dauser] -d [export_directory]  -e

NOTE: The export file can be very large. Ensure your chosen export directory (such as /tmp/iExport) has sufficient free disk space before running the command.

You may be asked to export additional tables, the -a flag is used for that:

./caVerticaUtility.sh -u [dauser] -w [dapass] -s [dauser] -d [export_directory]  -a table1[,table2,table3] -e

3. Upload the Export

Navigate to your chosen export directory. You will find a file named iRepExport.tar. This is the ONLY file you need to upload; you can safely ignore any other files generated in that folder.