unlock

Releases access locks on scheduling objects defined in the database. By default, to unlock an object, the object must have been locked using the same user and session.

If the scheduling object is stored in a folder, the command is performed on the folder where the scheduling object definition is stored. If folder is omitted, the default folder ("/") is used.

Authorization

You must have the unlock access to unlock scheduling objects locked by other users.

To unlock security objects, you must have permission for the unlock action on the object type file with attribute name=security.

Syntax

{unlock | un}
{[calendars | calendar | cal=[folder/]calname] |
[eventrule | erule | er=[folder/]eventrulename] |
[folder | fol=foldername] |
[parms | parm | vb=[[folder/]tablename.]variablename] |
[vartable | vt=[folder/]tablename] |
[prompts | prom=[folder/]promptname] |
[resources | resource | res=[[folder/]workstationame#][folder/]resourcename] |
[runcyclegroup | rcg=[folder/]runcyclegroupname] |
[cpu={[folder/]workstationame | [folder/]workstationclassname | domainame}]
[workstation | ws=[folder/]workstationame] |
[workstationclass | wscl=[folder/]workstationclassname] |
[domain | dom=domainame] |
[jobs | jobdefinition | jd=[[folder/]workstationame#][folder/]jobname] |
[sched|jobstream|js= [[folder/]workstationame#][folder/]jstreamname
   [valid from date|valid to date |valid in date date]
] |
[users | user=[[folder/]workstationame#]username] |
[accesscontrollist | acl for securitydomainname] |
[securitydomain | sdom=securitydomainname] |
[securityrole | srol=securityrolename]
}
[;forced]

Arguments

calendars | calendar | cal
If no argument follows, unlocks all calendar definitions.

If argument [folder/]calname follows, unlocks the calname calendar. Wildcard characters are permitted.

eventrule | erule | er
If no argument follows, unlocks all event rule definitions.

If argument [folder/]eventrulename follows, unlocks the eventrulename event rule. Wildcard characters are permitted.

folder
If no argument follows, unlocks all folder definitions.

If argument foldername follows, unlocks the foldername folder. Wildcard characters are permitted.

parms|parm|vb
If no argument follows, unlocks the default variable table.
If argument [folder/]tablename.variablename follows, unlocks the entire table containing the variablename variable. If tablename is omitted, unlocks the default variable table. Wildcard characters can be used on both tablename and variablename. For example:
unlock parms=@.@
Unlocks all tables.
unlock parms=@
Unlocks the default table.
unlock parms=@.acct@
Unlocks all the tables containing the variables whose name starts with acct.
unlock parms=acct@
Unlocks the default table.
Remember: The action on a single variable unlocks the variable table that contains it.
vartable | vt
If no argument follows, unlocks all variable table definitions.

If argument [folder/]tablename variable table follows, unlocks the tablename variable table. Wildcard characters are permitted.

prompts | prom
If no argument follows, unlocks all prompt definitions.

If argument [folder/]promptname follows, unlocks the promptname prompt. Wildcard characters are permitted.

resources | resource | res
If no argument follows, unlocks all resource definitions.

If argument [folder/]workstationame#[folder/]resourcename follows, unlocks the resourcename resource of the workstationame workstation in the specified folder on which the resource is defined. If workstationame is omitted, the default is the workstation on which composer is running. Wildcard characters are permitted.

runcyclegroup | rcg
If no argument follows, unlocks all run cycle group definitions.

If argument [folder/]runcyclegroupname follows, unlocks the runcyclegroupname run cycle group. Wildcard characters are permitted.

cpu
Unlocks workstations, workstation classes, or domains.
[folder/]workstation
The name of the workstation. Wildcard characters are permitted.
[folder/]workstationclass
The name of the workstation class. Wildcard characters are permitted.
domain
The name of the domain. Wildcard characters are permitted.
workstation | ws
If no argument follows, unlocks all workstation definitions.

If argument [folder/]workstationname follows, unlocks the workstationname workstation. Wildcard characters are permitted.

domain | dom
If no argument follows, unlocks all domain definitions.

If argument domainname follows, unlocks the domainname domain. Wildcard characters are permitted.

workstationclass | wscl
If no argument follows, unlocks all workstation class definitions.

If argument [folder/]workstationclassname follows, unlocks the workstationclassname workstation class. Wildcard characters are permitted.

jobs | jobdefinition | jd
If no argument follows, unlocks all job definitions.

If argument [folder/]workstationame#[folder/]jobname follows, unlocks the jobname job of the workstationame workstation on which the job runs. If workstationame is omitted, the default is the workstation on which composer is running. Wildcard characters are permitted.

sched | jobstream | js
If no argument follows, unlocks all job stream definitions.
If argument [folder/]workstationame#[folder/]jstreamname follows, unlocks the jstreamname job stream of the workstationame workstation on which the job stream is defined. If workstationame is omitted, the default is the workstation on which composer is running. Wildcard characters are permitted.
valid from
date Restricts the selection to job streams that have a valid from date equal to the indicated value. The format is mm/dd/yyyy.
valid to
date Restricts the selection to job streams that have a valid to date equal to the indicated value. The format is mm/dd/yyyy.
valid in
date date The time frame during which the job stream can run. The format is mm/dd/yyyy - mm/dd/yyyy. One of the two dates can be represented by @.
users | user
If no argument follows, unlocks all user definitions.

If argument [folder/]workstationame#username follows, unlocks the username user of the workstationame workstation in the specified folder on which the user is defined. If workstationame is omitted, the default is the workstation on which composer is running. Wildcard characters are permitted.

accesscontrollist | acl
If no securitydomainname argument follows, unlocks the access control list definitions for all the security domains.

If argument securitydomainname follows, unlocks the access control list definitions for the securitydomainname security domain. Wildcard characters are permitted for securitydomainname .

securitydomain | sdom
If no securitydomainname argument follows, unlocks all the security domain definitions.

If argument securitydomainname follows, unlocks the definition of the securitydomainname security domain. Wildcard characters are permitted for securitydomainname .

securityrole | srol
If no securityrolename argument follows, unlocks all the security roles definitions.

If argument securityrolename follows, unlocks the definition of the securityrolename security role. Wildcard characters are permitted for securityrolename .

forced
If specified, allows the user who locked the object to unlock it regardless of the session.

If this option is used by the superuser, then the unlock command can operate regardless to the user and the session used to lock the object.

Comments

If a user, other than the superuser, tries to unlock an object that is locked by another user, an error message is returned.

Examples

To unlock job definition JOBDEF1, run the following command:
unlock jd=@#JOBDEF1
To unlock event rule definition ERJS21, run the following command:
unlock erule=ERJS21
To unlock workstation Austin, stored in folder Texas, run the command:
unlock Texas/Austin
To unlock a folder named Chicago, run the command:
unlock folder /CHICAGO

See also

From the Dynamic Workload Console you can perform the same tasks as described in:

the Dynamic Workload Console User's Guide.