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

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.
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

Loved by customers all over the world

"Standout Tool With Extensive Monitoring Capabilities"

★★★★★

It allows us to track crucial metrics such as response times, resource utilization, error rates, and transaction performance. The real-time monitoring alerts promptly notify us of any issues or anomalies, enabling us to take immediate action.

Reviewer Role: Research and Development

"I like Applications Manager because it helps us to detect issues present in our servers and SQL databases."

Carlos Rivero

Tech Support Manager, Lexmark