DB Scanner tool

The DB Scanner tool is designed to uphold the integrity, security, and efficiency of Applications Manager's backend databases by identifying, assessing, and resolving potential corruptions. This tool plays a critical role in ensuring the reliability of backend database systems. This help page offers a detailed, step-by-step guide on how to utilize the standalone DB Scanner tool within Applications Manager.

Supported Backend: PostgreSQL

Steps to connect the DB Scanner Tool

The DB Scanner enables users to connect to both bundled and remote PostgreSQL (PGSQL) database types. Follow the steps outlined below for the respective PostgreSQL type to connect the DB Scanner Tool to your database and begin the scanning process:

Bundled PostgreSQL

  1. Navigate to <APM home>/bin and execute the following command:
    • For Windows

      DBConfiguration.bat -u dbuser

    • For Linux

      . ./DBConfiguration.sh -u dbuser

      Note: This step allows users to connect to the database without entering their user credentials.

  2. Next, go to the APM_HOME/working/Db_Scanner/bin directory and run the following script file:

    DBScanner.sh / DBScanner.bat

Remote PostgreSQL

Go to the APM_HOME/working/Db_Scanner/bin directory and run the following command:

Note: Kindly make note of the following:
  • <HOST> - Hostname or IP address of the Remote PostgreSQL server
  • <PORT> - Port number of the Remote PostgreSQL server
  • <USERNAME> - The username used to connect to your PostgreSQL database
  • <DATABASE NAME> - The name of the specific database that you wish to connect to and scan for potential issues
  • For Windows

    DBScanner.bat -h <HOST> -p <PORT> -U <USERNAME> -d <DATABASE NAME>

  • For Linux

    ./DBScanner.sh -h <HOST> -p <PORT> -U <USERNAME> -d <DATABASE NAME>

Example: ./DBScanner.sh -h pgsqlhost -p 5432 -U postgres -d amdb