Shared File Lock

This lock is displayed as FS in the LIST.READU output. The shared file lock affects other users as follows:

Table 1. Shared file lock
Lets other users acquire:	Prevents other users from acquiring:	Is ignored if you already own:
Shared record lock	Update record lock	Shared file lock
Shared file lock	Intent file lock Exclusive file lock	Intent file lock Exclusive file lock

Note: A shared file lock you own is incompatible with an update record lock you own. Be sure to use a LOCKED clause to avoid deadlocks.

The shared file lock can be promoted as follows:

Promoted to...: If...
Intent file lock: No shared file locks are owned by another user
Exclusive file lock: No shared file or record locks are owned by another user

In InfoSphere® DataStage® BASIC a shared file lock can be acquired or promoted with a FILELOCK statement and released with a CLOSE, FILEUNLOCK, RELEASE, or STOP statement.