SAP Mix

RE: Database locks

Posted By:
Date:

We have also 2000000 locks on a database of 1,1TB.
If it is not enough, I say always to look to the ABAP-programm,
or the variant.

Sometimes programms have build in a commit, if a job fails or make to many
locks the commit interval has to be reduced in the ABAP-programm (or
sometimes variant).

We have already 2000000 locks for many years, and it works fine.

With onstat -u, you can see which proces has many locks.
We also are called by phone automatically if more then 1000000 locks are in
use
(for 24 hours a day.)

Then we look with:
onstat -u to the locks and the SID,
then we look to onstat -g ses|grep <SID> and get the PID
You can see the PID back in SM66/SM50.
We tell it to the user (at office hours) and kill the SID with onmode -z or
use SM66/SM50.
If with onstat -u the third caracter is a R the transaction is rolling back
and will not take any locks any more, After the rollback (sometimes hours)
the problem is solved.

If you wait to long to kill the SAP-proces al other programms will be
failing with,
"no more locks available" and that's a pitty, so be on time, that's nicer.

> Marco Krijt
> Medewerker Operationeel Beheer SAP
> Vendex KBB IT Services b.v.
> Frankemaheerd 6
> 1102 AN Amsterdam Z.O.
> Postbus 12644
> 1100 AP Amsterdam Z.O.
> Tel: +31 (0)20-3129254
> E-mail: marco.krijt@vendexkbb-its.nl
>


-----Oorspronkelijk bericht-----
Van: Chang, Nicole [mailto:changn@tycoelectronics.com]
Verzonden: woensdag 26 februari 2003 20:29
Aan: sapmix@iiug.org
Onderwerp: Database locks [45]


Hello,

I was just wondering how many database locks you have available for a
Production instance. We have a 344 gig database, with 2 million locks
available, and an average of 500 users that are logged on.

I ask only because OSS is urging us to increase to 4 million locks, which is
double the locks I have.

Thank you in advance.

Nicole Chang
Database Analyst
M/A-COM, A Tyco International Company
978-442-4389

Messages In This Thread

• RE: Database locks
  -- Thursday, 27 February 2003, at 8:33 p.m.

SAP Mix is maintained by Administrator with WebBBS 5.12.