This document describes how to troubleshoot Cisco Customer Voice Portal (CVP) Reporting server's "DBSpace is full" or DBSpace rootdbs is full" issue.
Cisco recommends that you have basic knowledge of Cisco CVP server.
CVP server version 10.5 and 11.0
Problem: "DBSpace is full: 'rootdbs' -- WARNING: DBspace rootdbs is full"
Rootdbs chunk includes the system tables and other internal data structures managed by IDS. Full rootdbs can cause informix DB instability, critical server performance issues and new data will not be inserted into the tables. Full rootdbs condition can severely degrade CVP reporting servers performace. The diagnosis and solution sections presented in this document provides a valuable reference in order to quickly react and fix this condition.
Step 1. Log in to the CVP Reporting server with cvp_dbadmin user.
In Windows Event Viewer application log, you can see these errors:
cvp : SCHAPI: [post_alarm_message 19-34805] Error -131 ISAM error: no free disk space cvp : SCHAPI: [post_alarm_message 19-34805] Error -271 Could not insert new row into the table.
In CVP reporting logs (C:\Cisco\CVP\Logs\Reporting.txt), you can see this error:
%CVP_11_0_RPT-3-INFORMIX_ALARM: : DBSpace is full: 'rootdbs' -- WARNING: DBspace rootdbs is full [id:4016] %CVP_11_0_RPT-3-INFORMIX_ALARM: : DBSpace is full: 'rootdbs' -- WARNING: DBspace rootdbs is full [id:4016]
Step 2. Run this command from Windows Command Prompt (CMD):
oncheck -pe > c:\tmp\onchk.txt
This output shows the rootdbs path, used and free size for each chunk: