on 03-05-2015 8:57 AM
Hi experts,
yesterday we had a host problem had to restart a System.
Since this, we are facing an hanging DB-process in DBACOCKPIT.
In OS I can't find the process.
Also it is not a zombie on OS-Level.
However, this is now an open transaction and therefore Log-Backup is not running.
Can anybody please help me, how I can get out this process of dbacockpit?
In sm51 I can't see the process, as said also not on OS level.
Kind regards
Hi Christian,
Did you try DPMON? Is the process running there?The issue is not too clear, maybe a screenshot would help.
Sounds silly, but can't you just kill the process? I think the screenshot would help.
Hope this helps.
_ _ _ _ _ _ _ _ _
Kind Regards,
Hemanth
SAP AGS
_ _ _ _ _ _ _ _ _
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Great news Christian. A restart usually solves all such cases . I hope you did perform a checkpoint first.
Hello Hermanth,
maybe you can help me again.
Now I have a similar situation on another situation.
I had a V2-Upd Process hanging. In SM13 it was displayed as "INIT".
I've killed the proces via SM51.
However, I still get a very long running transaction in ASE and in DBACOCKPIT i can still see it.
So for me it seems, like the transaction is still active and this means that now log-truncate will be done -> log full!
The OS process which is displayed in DBACOCKPIT can also not be killed via OS (not any longer active).
Any suggestion?
What was it about DPMON? How can I use this`?
Hi Christian, DPMON is a kernel utility which can be used when the work processes are all used up, the engine is stuck and you cannot login to the R/3. You can then free up some workprocesses with this utility: Are you on the latest kernel level; I think this issue will need a complete server checkup :(. Maybe you can raise an incident in the SV-BO component. Regards, Hemanth
ehm....and now it seems to be gone 😮
I have no idea what was causing the hang....a lot of things to be learned by me regarding ASE
But so the things stay interesting
Guys, thx again very much for your help in each cases.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Christian,
If it related to ASE I am your correct point of contact.
Probably provide me your email and phone number probably I may give you call tomorrow and brief things which you need to check from database perspective which you can get familiarise yourself in sybase ASE database.
Regards
Kiran K Adharapuram
This is a great initiative Kiran. I think this is a prime example of Support Without Incidents (Christian, this something internal within SAP . Please also talk to your TQM or support advisor and maybe a Expertise on demand EOD session can be done so that we go through the whole engine in detail).
Correct Hemanth.I completely agree 🙂
Christian,
We are always here to help may be as process said by hemanth said we can help you with a good session to make you understand and very importantly pro actively monitoring things so that you will not end up with any problems in your application and database as well 🙂
Regards
Kiran K Adharapuram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.