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

FAQ-How to Hang Up and Delete Automatic Task for Performance Statistics

Publication Date:  2012-07-24 Views:  43 Downloads:  0
Issue Description
Q:
How to hang up and delete automatic task for performance statistics?
Alarm Information
Null
Handling Process
A:
Detailed procedures are as follows:
1. Log in to the database:
Isql-S is the database name, �U is the user name, and �P is the password:
2. Run the following scripts:
1>use IPMS
2>go
3>update ipms_CollectTaskInfoTab set  taskStatus=1 where specialType=4096
4>go
3. After restarting the IPMS process, all automatic tasks are hung up. Then these automatic performance statistics tasks can be deleted.
Root Cause
When the performance statistics process IPMS is started, some performance statistics tasks run automatically. These tasks start with AUTO_TASK and cannot be hung up and deleted. When automatic performance statistics tasks are a lot and the running frequency is high, IPMS database is full after running for a long time. Other performance statistics tasks cannot be established.
Suggestions
Null

END