Skip to content
Try for FREE
Blog

How to create a support package in Standby v9

To provide faster and better support, the Support Package feature was introduced in Standby version 8 back in 2016. This simplified the collection of relevant information when troubleshooting an issue, in one go.

davide-cantelli-TczSLeQmn9M-unsplash-1
How to guides
Create support package in Dbvisit Standby v9
By Product Specialist
|
July 3, 2020
|
Link Clicked!


Prior to having the support package feature it took Dbvisit Support considerable time to find the relevant and correct tracefiles and logfiles to do troubleshooting. It became frustrating having to ask customers to run various commands and queries to get an overall view of their environment.

To provide faster and better support, the Support Package feature was introduced in Dbvisit Standby version 8 back in 2016. This simplified the collection of relevant information when troubleshooting an issue, in one go. The idea behind this, is to collect all relevant configuration, trace and log files for the  particular failing process, presented in a zip file.

There are various ways to create a support package:

For Failing Process Where the PID is Known

When any process or task is run in Dbvisit, the process id or pid gets displayed in the header, both in the GUI and CLI

  1. In the GUI

Just click on CREATE SUPPORT PACKAGE

dbvisit-blog-dbvisit-standby-v9-support-package-1

Then click on DOWNLOAD

dbvisit-blog-dbvisit-standby-v9-support-package-2

Now you will find the file in your Downloads folder.

  1. In CLI

You will have to run the following command on the Primary host.           

            ./dbvctl -d DEV -f support_package -a pid=7068

The zipped file then gets created in the …/support directory – see the example below:

dbvisit-standby-v9-support-directory

During Failure When the PID is not Known

If there was a failure and the pid is not known then one can create what we refer to as a generic support package which contains database and Dbvisit Standby configuration details.

In the GUI:

dbvisit-standby-database-actions

In CLI:

./dbvctl -d DEV -f support_package

In the following video I’ll demonstrate how this can be done in one of my test environments, mainly using the GUI.

Watch the video below:

Now you can actually go and unzip the support package to see what type of information it contains.

There will be folders for the Source and Destination, and within each you’ll find .txt, .conf, .log, .trc , and .hist etc. files.

dbvisit-standby-v9-source-destination

The .hist file is one of my personal favourites especially when I don’t have the PID of the failing process. It displays the timestamp when the issue occurred as well as the PID it was using during the operation.

Another very important file, is the DDC file, ending with .env. This is the Dbvisit Standby configuration file which contains all the configuration settings for your Standby database.

I can go on about the information within the Support Package but the goal of this blog was to explain why it exists and how to create it, to assist us in resolving issues quicker. To find out more about the Contents of the Support Package please have a look at this blog by my colleague, Director of Customer Services, Vijayganesh Sivaprakasam.

Make it a habit of Creating a Support Package when an issue occurs, and snoop around the files and its contents, you might just be able to resolve the issue. Hope this was insightful. Please download a 10-day free software trial of Dbvisit Standby and see for yourself.

Product Specialist


Subscribe to our monthly blog updates

By subscribing, you are agreeing to have your personal information managed in accordance with the terms of DBVisit's Privacy Policy


Try StandbyMP for free

See for yourself how our continuous database protection can help keep your world in motion.

Find a local partner

We work with partners around the world to give you the best advice and world-class local support.

Mask Group 59
Mask Group 184-1
Group 781
Group 528

Let’s talk

Find out about our continuous database protection for yourself and see how you can keep your world in motion.