Which Lock Objects Do Exist In Sap Maxdb?

1.	Which Lock Objects Do Exist In Sap Maxdb?
Answer» Three TYPES of locks EXIST in SAP MaxDB: Record locks (ROW): Individual lines of a table are locked. Table locks (TAB): The entire table is locked. Catalog locks (SYS): Database catalog entries are locked. Three types of locks exist in SAP MaxDB: Record locks (ROW): Individual lines of a table are locked. Table locks (TAB): The entire table is locked. Catalog locks (SYS): Database catalog entries are locked.

Answer»

Three TYPES of locks EXIST in SAP MaxDB:

Record locks (ROW):

Individual lines of a table are locked.

Table locks (TAB):

The entire table is locked.

Catalog locks (SYS):

Database catalog entries are locked.

Three types of locks exist in SAP MaxDB:

Record locks (ROW):

Individual lines of a table are locked.

Table locks (TAB):

The entire table is locked.

Catalog locks (SYS):

Database catalog entries are locked.

Discussion