Drop Lock

The MaxL drop lock statement helps you remove a lock acquired through a Smart View or other grid client operation against an Essbase block storage (BSO) database.

Note:

Data locks do not apply to aggregate storage (ASO) applications.

Syntax

Description of the illustration drplock.gif

Keywords

You can delete locks in the following ways using MaxL drop lock.

drop lock [on system] [all]

Drops all locks by all users, for all block storage databases on the Essbase Server.

Example:

drop lock;

drop lock all

Same as "drop lock on system all," removes all locks, by all users, for all block storage cubes on the Essbase Server.

Example:

drop lock all;

drop lock on system

Same as "drop lock on system all," deletes all locks for all block storage cubes on the Essbase Server.

Example:

drop lock on system;

drop lock on application APP-NAME

Drops all locks from block storage cubes on the specified application, for all users.

Example:

drop lock on application Sample;

drop lock on application APP-NAME held by USER-NAME

Drops any locks, on block storage cubes in the named application, which are held by a specific user.

Example:

drop lock on application Sample held by user adparvan;

drop lock on database DBS-NAME

Drops all locks on the specified block storage database, held by any and all users.

Example:

drop lock on database Sample.Basic all;

drop lock on database DBS-NAME held by USER-NAME

Drops locks on the specified block storage database that are held by a specific user.

Example:

drop lock on database Sample.Basic held by krsandrs;

drop lock held by USER-NAME

Drops all locks held by a specific user.

Example:

drop lock held by lydsimmons;