[sap-basis] SAPDBA defunct processes issue on HP-UX
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by VDMPCH (SA) on Feb 10 at 5:10 PM |
Hi,
We encountered a typical issue with SAPDBA tool in our Production environment. This tool is called in a script scheduled in cron and it executes twice daily to check the extents of tables/indexes which could result in tablespace overflow (options c -> d and extents checked for is 5).
The script was executing fine for the last 2 years but in the last two months the script created thousands of <defunct> processes as sidadm user(cron job is with this user) in HP-UX and this had filled up the process table. The script usually executes within a minute and sends an email to the production support team but on these both ocassions it was continuously running and we needed to the kill the process manually.
Below are the version details:
R/3 Release:3.0F
R/3 Kernel:3.1I_EXT
Database:Oracle 9.2.0.8
Operating System:HP-UX 11.23
SAPDBA version 6.20
We have similar setup in our DEV and QA environments but didn't get this issue anytime. One difference here is the SAP executables including SAPDBA are on a NFS mount point in Production while they are on local filesystem in DEV and QA. Not sure if this can cause a problem randomly.
Appreciate much if anyone can confirm what could be the problem and if similar issue was encountered in any environments.
Thanks & Regards,
VDM
__.____._ We encountered a typical issue with SAPDBA tool in our Production environment. This tool is called in a script scheduled in cron and it executes twice daily to check the extents of tables/indexes which could result in tablespace overflow (options c -> d and extents checked for is 5).
The script was executing fine for the last 2 years but in the last two months the script created thousands of <defunct> processes as sidadm user(cron job is with this user) in HP-UX and this had filled up the process table. The script usually executes within a minute and sends an email to the production support team but on these both ocassions it was continuously running and we needed to the kill the process manually.
Below are the version details:
R/3 Release:3.0F
R/3 Kernel:3.1I_EXT
Database:Oracle 9.2.0.8
Operating System:HP-UX 11.23
SAPDBA version 6.20
We have similar setup in our DEV and QA environments but didn't get this issue anytime. One difference here is the SAP executables including SAPDBA are on a NFS mount point in Production while they are on local filesystem in DEV and QA. Not sure if this can cause a problem randomly.
Appreciate much if anyone can confirm what could be the problem and if similar issue was encountered in any environments.
Thanks & Regards,
VDM
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
In the Spotlight
Earn Recognition for Your Contributions at Toolbox for IT. Gain Points for Community Achievements
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
_.____.__ 
