ARSMAINT increase ARSSOCKD process count

[rajesh]

Hi All,

As we are working on Purging the years of old data for which based on IBM Support team suggestion we are running the arsmaint command for each and every application group individually 5 hours a day.

which now had created a problem daily the count of arssockd services is getting increased. initially the arssockd was having the deamons of 12 count now it came to 70 which is very critical. Not sure how to decrease the count without stopping the arssockd services.

Running arsmaint when the transaction is down. Before starting arsmaint stopping arsload process.

Command : ./arsmaint -cdeimrvs -g <applicationgroup> -I ARCHIVE -t 18991 -n 0 -x 0 -v

OS: RHEL
CMOD: 8.5.0.6
DB: Oracle 11g

Quick response much appreciated.

Thanks in advance.
RaJ

[Justin Derrick]

It shouldn't be a problem to leave arsmaint running 24x7.  When you specify a single Application Group, and only run one instance at a time, it shouldn't require a lot of CPU or memory.  I'd be more worried about killing arsmaint repeatedly, honestly.

Also, you're using the -t option, which can be quite dangerous.  The data 18991 is in late 2021 / early 2022.  Please review the documentation to ensure you're using this properly, and that it's precisely what you want.

-JD.

[rajesh]

Thank you JD.

As per IBM confirmation we are executing the command. Can you please let me know how to manually kill the arsmaint process please.

[Jaydeep Mehta]

Hi .

Just  grep process PID from the Shell process  and Kill.

ps -ef |grep arsmaint

kill -9 PID

it will stop the arsmaint process.

Regards
JD

[Alessandro Perucchi]

Hi .

Just  grep process PID from the Shell process  and Kill.

ps -ef |grep arsmaint

kill -9 PID

it will stop the arsmaint process.

NOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO

If you kill a process PLEASE do you use the following command:

kill PID

AND ONLY if that command does not work, then use the kill -9 PID.

The -9 is really the option to use when everything was done to stop a process and it didn't work.
When doing a -9 you are facing a possible corruption of data, because the process was murdered without leaving him the time to close cleanly the transaction it was doing.
So if you want to face possible data corruption then use the option -9 without even thinking.
If you want to reduce / remove possible corruption of data, NEVER use -9, EXCEPT if there are no other options.