space
Previous Page | Next Page

Information for the Database Administrator

Controlling Data Locks with ADABAS

SAS software supports several levels of data locking, which is a means of holding information constant so that it doesn't change unexpectedly. The control level is the degree to which a SAS procedure can restrict access to data. SAS procedures can request locks on individual records, on library members, and so on. Locking is also controlled by the SAS software CNTLLEV data set option, which can request record-level locking and member-level locking. Some SAS procedures set CNTLLEV equal to MEM internally for their own processing reasons. Many statistical procedures must make multiple passes of the data. For example, finding the median requires more than one pass.

The ADABAS interface view engine honors all locking requests in a multi-user environment. (Locks are not required in a single-user environment.) The following conditions apply:

For more information about how the interface view engine handles locking, see Competitive Updating and Logical Transaction Recovery.

space
Previous Page | Next Page | Top of Page