Utilities for Managing ladb

These utilities are useful when working with ladb:

The dbmode Utility

The Set or Display Database Mode utility (dbmode) enables administrators to switch Lawson into one of three modes: single-user, multi-user, and no-new-user. This ensures that users do not access the system during maintenance tasks, for example, when running Build Dictionary (blddbdict) and Reorganize Database (dbreorg). When anyone executes the dbmode utility, their user ID is reported in the ladb.log file. Only the user who puts ladb into single-user mode or no-new-user mode can set the mode back to multi-user mode.

The dbusers Utility

Use the dbusers utility to view database processes, see who is logged in, and verify that ladb is running. Use this utility prior to stopping a server program.

The dbadmin Utility

The Database Service Administration utility (dbadmin) performs administrative tasks for the Lawson Database Service (ladb) without shutting down the service to change the ladb.cfg file. Infor Lawson Database Server Configuration File (ladb.cfg)

Using the dbadmin utility, an administrator can perform the following tasks:

  • Shut down idle database drivers

    With driver REUSE enabled, the database driver process remains running and connected to associated RDBMS database. The administrator can shut down any idle database driver process not currently in use.

  • Enable or disable driver REUSE

    The ladb service can be configured to reuse database driver processes if the driver does not have any open database files. This option is enabled or disabled when you issue the startladb command and the REUSE parameter is in the ladb.cfg file. Using the dbadmin utility, the administrator can toggle the driver REUSE flag without stopping the ladb service.

  • Enable or disable timed statistics collection

    The timed statistics feature gives you information on the amount of processing time used for each function performed on a specific table for each user and program combination. This information is useful when you want to understand performance tuning issues.

    Select the timed statistics feature to monitor statistics for a specific user, program, or combination of user and program. You can also set this feature to monitor all users and programs, but if there are many users accessing the database, timed statistics might produce a large amount of output.

  • Get the current value or set ladb.cfg configuration file variables.