[Troubleshooting] The PMSDB Database Usage Is 100% After U2000 Is Migrated to NCE

Hello everyone!

Today, I'd like to share a case with you.

Problem Description

After U2000 Is Migrated to NCE in the Single Management Domain, an Alarm Is Reported on the NCE Management Plane, and the PMSDB Database Usage Reaches 100%

Problem Analysis

The U2000 PMSDB database has been expanded, but the NCE database is configured with the standard configuration. Therefore, the actual size of NCE PMSDB after the migration exceeds the total configuration.

Root Cause

The U2000 PMSDB database has been expanded, but the NCE database is configured with the standard configuration. Therefore, the actual size of NCE PMSDB after the migration exceeds the total configuration.

Solution Description

Step 1 Log in to the NCE management plane (IP address: 31945) and check the current PMSDB deployment size.

  1. On the home page of the management plane, click NCE-NMS.

  2. Click Relational Databases.

Step 2 Log in to the NCE OMP node as the ossadm user.

cd /opt/oss/manager/apps/DBAgent/bin

(./dbsvc_adm -cmd modify-database -instid <DBInstanceId> -dbname <db name> -appname <app name> -datasize <datasize>)

1. Obtain the value of DBInstanceId.

2. Run the following command to set the total size of the PMSDB to 2500 MB:

cd /opt/oss/manager/apps/DBAgent/bin

./dbsvc_adm -cmd modify-database -instid nmsdbsvr-0-1046 -dbname PMSDB -appname PMSService -datasize 2500

  3. Repeat step 1 to check the total size of the PMSDB.

Welcome to leave a message below.

We'll study together.

Thank you!