Skip to Content
0

MAXSQLLOCKS in MaxDB 7.9.09.05

Dec 07, 2017 at 02:42 PM

30

avatar image
Former Member

Hi Team,

My database size is 2.6 TB. We are getting SQL error "-1000".Current value is 900000

I already gone through the SAP notes 1567117.

Can you please suggest me what should be the recommended value of MAXSQLLOCKS in mycase as my db size is huge?

Thanks in Advance

Sishir

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Michael Teubner Mar 01 at 02:34 PM
0

Hello,

in my opinion, the size of the database has nothing to do with the MAXSQLLOCKS parameter.

It depends rather on the amount of locks the SAP system is holding. For example every creation, change or update of an order in SAP needs locks on the db.
You can see the locks of your SAP system with transaction SM12.

Compare following SAP notes:

Note 337773
Note 441032

Regards,

Michael

Share
10 |10000 characters needed characters left characters exceeded