RELEASE-USER-RESOURCES

This statement releases all a user's resources.

Scope of validity

DBH administration

Function

The RELEASE-USER-RESOURCES statement releases all a user's resources.

You can use this statement to intervene in the case of the undefined abortion of an application program, for example, by releasing the resources of the associated user and thereby disconnecting this user.

You can determine all of the users known to the DBH who have no open transactions and who have not issued any statements for a certain length of time, and then release all the resources of these users.

In a DBH session with transaction management, the DBH rolls back all a user's currently active transactions before releasing the user's resources. If the resources of a UTM user are to be released, the DBH backs up all the information on the rolling back of transactions that have started in order to ensure a synchronized UTM restart.

All users are rolled back that have a (partially qualified) user identifier. If a user is currently inside of a transaction, then this transaction is rolled back if it does not issue any commands within the time specified in INACTIVE-TIME.

If a utility is currently active for the user, then the call for this user is ignored.

The system administrator cannot release his or her own resources. If SESAM/SQL recognizes the user identification as being that of the system administrator, then the call for this user is ignored.

RELEASE-USER-RESOURCES

USER = *ALL (...) / <user-identification>
	*ALL (...)
		|	INACTIVE-TIME = <integer 1 .. 99>

Operands

USER =

Identifies the user or a group of users when partially qualified whose resources are to be released.

USER = *ALL (...)
If *ALL is specified, all the resources are released for all of the users known to the DBH who have no open transactions and who have not issued any statements since the time specified with INACTIVE-TIME.

INACTIVE-TIME = <integer 1 .. 99>
Time in minutes.

USER = <user-identification>
Identifies one or more users whose resources are to be released. One partial qualification is enough to cause the resources of all affected users to be released (see the section “Syntax for the identification of users”).

Administration command in ISP format and at the CALL DML interface

Here, two administration commands fulfill the function of the RELEASE-USER-RESOURCES administration statement, namely the administration commands FREE and FREE,USER,INACT.

FREE,user-identification

FREE,USER,INACT=n

A 2-digit number between 1 and 99 can be specified for n.

Users that have open transactions or active lock sequences are not affected by the FREE,USER,INACT call.

The call handles CALL DML users as well as SQL users.

user-identification can be specified as a partial qualification (see "Syntax for the identification of users").

If the call was recognized as having correct syntax, then it is acknowledged as having been accepted. This means that a negative acknowledge is not sent when no specific user was referred to or no user was eliminated by a call with the correct syntax.