cancel
Showing results for 
Search instead for 
Did you mean: 

Zombie-Process in DBACOCKPIT

Private_Member_19084
Active Contributor
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

hemanth2
Product and Topic Expert
Product and Topic Expert
0 Kudos

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
_ _ _ _ _ _ _ _ _
 

Private_Member_19084
Active Contributor
0 Kudos

Hello Hermanth, again,

sorry I forgot.

No, I already "solved" it

We did restart the DB, and to go secure also the host.

I've googled and found a lot of ASE-ziombies, which have to be killed via DB-Restart.

Kind regards

hemanth2
Product and Topic Expert
Product and Topic Expert
0 Kudos

Great news Christian. A restart usually solves all such cases . I hope you did perform a checkpoint first.

Private_Member_19084
Active Contributor
0 Kudos

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`?

Private_Member_19084
Active Contributor
0 Kudos

...and it is a bit confusing.

In TechMon I get 20k seconds long transaction.

But in DBACOCKPIT it is displayed with 60k seconds.

So I am  not sure if it is really the same process, which is causing the problem.

Private_Member_19084
Active Contributor
0 Kudos

Found it now.
In dbacockpit->processes->"Transactions Open" I found it now.

But also this OS-process is not any longer existing.

hemanth2
Product and Topic Expert
Product and Topic Expert
0 Kudos

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

Private_Member_19084
Active Contributor
0 Kudos

Hello Hermanth

found it already. But also there the process is not displayed - I think as expected.

I think so, that we have to check this.

Kind regards

Answers (2)

Answers (2)

Private_Member_19084
Active Contributor
0 Kudos

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.

former_member187136
Contributor
0 Kudos

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

former_member187136
Contributor
0 Kudos

Christian,

Hemanth is pure BO guy 😛

I am a Sybase DBA 😉

I may share some really good sap note and best practice's for sap ASE administration which really help to pro actively monitor the dB from your side as well 🙂

Regards

Kiran K Adharapuram

Private_Member_19084
Active Contributor
0 Kudos

Hello Kiran,

sounds goods. But where can Is end you a kind of PN?

Kind regards

hemanth2
Product and Topic Expert
Product and Topic Expert
0 Kudos

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).

former_member187136
Contributor
0 Kudos

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

former_member187136
Contributor
0 Kudos

Christian,

But i sincerely suggest if you can able to tolerate the impact you shouldnt reboot the machine

So that we can dig into this issue as we DBA's are curious to analyse than to solve

Kindly refer the below SAP Doc for DPMON usage:

Regards

Kiran K Adharapuram