No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>Search


To have a better experience, please upgrade your IE browser.


Performance process PMSDB is abnormal because of small disk space of opt

Publication Date:  2012-07-25 Views:  160 Downloads:  0

Issue Description

Performance process : PMSDB is abnormal.

Alarm Information

please check the image

Handling Process

For PMSDB we need dump the history data first.

if dump history data can't solved the problem, then you can extend it

we can expand the PMSDB as follow:
For example, we plan to add 1G space to the PMSDB:
#isql -SDBSVR -Usa -Pxxxxxx     (replace the xxxxxx by the password)
1>sp_helpdb PMSDB
check the device name of the PMSDB, For example, it is PMSDBdata, then we will add a new device PMSDBdata1(If this device name is exist, pls create it with other name, for example PMSDBdata2)
1>disk init name = "PMSDBdata1"
2>physname = "/opt/sybase/data/PMSDBdata1.dat",
3> size="1000M",
1>alter database PMSDB on PMSDBdata1=1000
This will cost some time, please  pay attention to wait.
After finish, please check it by:
1>sp_helpdb PMSDB

Root Cause

the disk space of /opt, must be larger than 2G.