Operations Guide

10.5
- 10.5 HotFix 1
- 10.2 HotFix 1
- 10.2
- 10.1 HotFix 1
- 10.1
- 10.0 HotFix 1
- 10.0

Back Next

lockmgr Utility

This utility performs the following tasks:

Deletes a lock for the process identifier that you specify.

Lists all the application locks and the unique identifiers for a system.

Lists the current entries for the

IDS_LCK_TABLES

lock table.

Retrieves a specific record based on a unique identifier.

The lockmgr utility uses the following syntax:

%SSABIN%\lockmgr [list|getrec <unique identifier>|del <process identifier>] -rRbName -hRbHost [-vpsu] [-l]

where:

list

. Lists the application locks and their unique identifier values.

del <process identifier>

. Deletes a lock for the process identifier that you specify.

getrec <unique identifier>

. Retrieves a record from the lock table for the unique identifier that you specify.

-r

. Indicates the Rulebase name.

-h

. Indicates the Rulebase Server connection detail. You can use the

-g

option to specify the Rulebase Server Group name.

-l

. Lists the Rulebase Server connection details when used in conjunction with the

-g

option in the

host:port

format.

-g

. Prints the details of the active Rulebase Server when used in conjunction with the

-r

option.

You must specify either the

list

getrec uq

, or

del uq

option in the syntax.

List Locks Example

The following example lists all the application locks for a system:

%SSABIN%\lockmgr list -rodb:0:userid/password@dbserver -hlocalhost:1668

uq: idtsyncsystem:benchmark:r:ssaupd:1632979627:3173
idt-name: bench1
systen-name: benchmark
process-name: ssaupd:1632979627:3173
host-name: r100-lx6
process-ID: 17711
****************
uq: idtsync:benchmark:bench1
idt-name: bench1
systen-name: benchmark
process-name: ssaupd:1632979627:3173
host-name: r100-lx6
process-ID: 17711
****************

The following example prints the details of the active Rulebase Server:

$SSABIN/lockmgr list -r$SSA_RBNAME -gmygroup,$SSA_RBNAME -vpsu+

lockmgr> Rulebase-Server host     r100-lx6
lockmgr> Rulebase-Server port      							34263
****************
uq:           idtsyncsystem:benchmark:r:ssaupd:1644310408:2859
idt-name:     bench1
systen-name:  benchmark
process-name: ssaupd:1644310408:2859
host-name:    r100-lx6
process-ID:   16603
***************
uq:           idtsync:benchmark:bench1
idt-name:     bench1
systen-name:  benchmark[^StartRBSG.sh]
process-name: ssaupd:1644310408:2859
host-name:    r100-lx6
process-ID:   16603
***************

Retrieve Locks Example

The following example retrieves the lock records for a specific identifier:

%SSABIN%\lockmgr getrec idtsyncsystem:benchmark:r:ssaupd:1632979627:3173 -rodb:0:userid/password@dbserver -hlocalhost:1668

****************
idt-system-name: idtsyncsystem:benchmark:r:ssaupd:1632979627:3173
idt-name: bench1
system-name: benchmark
process-name: ssaupd:1632979627:3173
host-name: r100-lx6
process-ID: 17711
****************

Delete Locks Example

The following example deletes a lock based on the specified process identifier:

$SSABIN/lockmgr del 17711 -rodb:0:iir/iir@orcl -hlocalhost:1666

You must use the delete utility with caution. A running process, such as Update Synchronizer requires exclusive use of ceratin system resources. When you remove locks from a running process, it might generate an error or corrupt the data.

If a process detects a conflicting lock, it tries to find out the status of the job that created the lock. It deletes the locks and creates its own if the original process has crashed.

In some instances, the new process might not be able find out the status of the original process. For example, if the original process runs on a different computer or is unresponsive. The

lockmgr

utility is useful in such scenarios to remove the lock manually.

Batch Utilities

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal