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>

Reminder

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

upgrade

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

Publication Date:  2012-07-25 Views:  7 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
2>go
 
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",
4>dsync=false
5>go
 
1>alter database PMSDB on PMSDBdata1=1000
2>go
 
This will cost some time, please  pay attention to wait.
 
After finish, please check it by:
1>sp_helpdb PMSDB
2>go



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


Suggestions
null


END