Skip to Content
avatar image
Former Member

MAXSQLLOCKS in MaxDB 7.9.09.05

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 01 at 02:34 PM

    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

    Add comment
    10|10000 characters needed characters exceeded