To clean up auxiliary database tables

Purpose

Perform this procedure to clean up auxiliary database tables related to NFM-P from Vertica in a standalone or geo-redundant auxiliary database.

Note: You require root user privileges on the auxiliary database host.

Note: release-ID in a file path has the following format:

R.r.p-rel.version

where

R.r.p is the NSP release, in the form MAJOR.minor.patch

version is a numeric value

Steps
 
1 

Log in to the auxiliary database station as the root user.

2 

Enter the following:

# su - samauxdb ↵

3 

Run vsql.

# ./vsql -U samauxdb  ↵

You are prompted for credentials.

4 

Enter the following:

  • password—database administrator password

5 

Enter the following:

DROP SCHEMA SAMDB CASCADE; ↵

6 

Exit vsql.

# \q  ↵

7 

Exit the shell.

8 

Enter the following as the root user:

#  /opt/nsp/nfmp/auxdb/install/bin/auxdbAdmin.sh reinstallUDxLibraries

9 

Log out of the auxiliary database station.

10 

Wait up to 5 minutes for the new SAMDB schema permissions to be granted.

11 

Verify the following in the active auxiliary database:

  • Tables under the SAMDB schema are removed but the schema still exists.

  • Tables and data in the collection schema are unaffected. 

  • All NSP reports have no aggregation table errors.

12 

In a geo-redundant auxiliary database, check the copy-cluster status.

The copy-cluster function is activated automatically. Wait for 20 to 30 minutes for next scheduled copy-cluster operation.

Check the copy-cluster status in the active auxiliary database:

Issue the following RESTCONF API call:

GET https://server/restconf/data/auxdb:auxdb-agent

server is the NSP advertised address

The call returns a status of SUCCESS, as shown below, for a successfully completed copy-cluster operation :

{

    "auxdb-agent": {

        "name": "nspos-auxdb-agent",

        "application-mode": "ACTIVE",

        "copy-cluster": {

            "source-cluster": "cluster_2",

            "target-cluster": "cluster_1",

            "time-started": "timestamp",

            "status": "SUCCESS"

        }, 

    }

}

End of steps