MODIFY `irlmproc`,PURGE command (z/OS IRLM)

The MODIFY irlmproc,PURGE command releases IRLM locks retained due to a Db2, IRLM, or system failure.

The command causes all retained locks for the specified Db2 to be deleted from the system, thereby making them available for update. Because retained locks protect updated resources, it should be used only after understanding what the resources are and the consequence to data integrity if they are deleted.

Abbreviation: F

Environment

This command can be issued only from a z/OS® console.

Data sharing scope: Member

Authorization

The command requires an appropriate level of operating system authority.

Syntax

Option descriptions

Use commas with no spaces to separate parameters.

irlmproc: Specifies the active IRLM that is to process the command.
db2name: Specifies the inactive Db2 name, as displayed by the STATUS command.

Usage notes

Db2 subsystem inactive: The Db2 subsystem that owns the retained locks must be inactive or else this command fails.

The irlmproc must be the procedure name of an active IRLM that is connected to the same sysplex group as the failed member. Issuing a purge request using an inactive IRLM returns error IEE341I.

Example

Example: For an active Db2 subsystem named db2b with irlmproc name db2birlm, issue the following command to display all active and inactive subsystems in a data sharing sysplex:

F db2birlm,STATUS,ALLD

If the subsystem db2a is inactive, enter the following command:

F db2birlm,PURGE,db2a

Response on the MVS™ system console for completed purge request:

DXR109I IR2B002 PURGE COMMAND COMPLETED FOR DB2A

Explanation: In a sysplex environment, if the Db2 database is inactive and the database IRLM has stopped or is disconnected, the operator of the z/OS system uses one of the other active IRLM members to query retained locks and issue the PURGE request.