Managing the Runtime Status of the Lawson Database Service

Use this procedure to monitor or modify the runtime activity of the Lawson Database Service (lads). This includes checking the status of lads, checking the locks on resources, unlocking resources, clearing idle resources, and managing autosequencing.

Note: 

In all cases where you can filter which resources an action is applied against you can use regular expressions or provide specific names. For example, you could use the following: ladsadmin --unlock --pool .* --kind .*dataarea .*.

At a Landmark command prompt, type one of the following, depending on the task you want to perform:

ladsadmin -s | --status

ladsadmin --list [LIST-OPTIONS]

ladsadmin --unlock [UNLOCK-OPTIONS]

ladsadmin --clearidle [CLEARIDLE-OPTIONS]

ladsadmin --autosequence [AUTOSEQUENCE-OPTIONS]

where

Program option Description
-s or --status The output will tell you if lads is running by trying to connect directly to the port defined in the $LACFGDIR/lads.cfg file.
List options
-l or --list List the locks held on resources.
--list -p name or --list --pool=name Filter the list by pools matching the specified pool or pools.
--list -k kind or --list --kind=kind Filter the list by resource kinds matching the specified kind or kinds.
--list -r resource or --list resource=resource Filter the list by resources matching the specified resource or resources.
--list --csv Format the lock listing as comma-separated values.
--list --noheader Do not include the CSV headers in the output.
Unlock options
-u or --unlock Force the unlock of resources.
--unlock -p name or --unlock --pool=name Required parameter to force the unlock of the resources for the specified pool.
--unlock -k kind or --unlock --kind=kind Required parameter to force the unlock of the resources of the specified kind.
--unlock -r resource or --unlock --resource=resource Force the unlock of the specified resource.
Clear Idle options
-i or --clearidle Clear idle resources from a resource pool.
-p name or --pool=name The pool whose idle resources you want cleared.
--invokegc Invoke Java garbage collection via System.gc() in the LADS JVM after clearing the idle resources.
Autosequence options
-a or --autosequence Manage the autosequence manager.
--autosequence --enable | --disable

Enable or disable the autosequence manager.

The autosequence manager keeps track of the maximum value for autosequenced fields that were defined with the "minimize contention" property. For these fields, when it is necessary to obtain the next value, the system does not need to retrieve it from the database. This can improve performance.

By default, this functionality is enabled. If you set the Disable Autosequence Manager grid property for the Landmark grid application to true, the default behavior changes to disabled. If you use the --autosequence --enable command in that case, the autosequence manager is enabled only until the next stoplaw/startlaw.

Generally, you should not disable the autosequence manager unless instructed by technical support.

--autosequence --reset dataarea Reset the autosequence manager cache for the specified data area.
--autosequence --showstats dataarea Show the autosequence manager statistics for the specified data area.
--autosequence --clearstats dataarea Clear the autosequence manager statistics for the specified data area.