dbadmin - ladb Administration Utility

dbadmin idle DataArea

dbadmin idleALL

dbadmin get REUSE | DEBUG | DBAPIERRORS | IDLETIME | TIMESTATS | USERFILTER | PROGRAMFILTER | DATAAREAFILTER | TIMESTATSDIR

dbadmin set REUSE | DEBUG | DBAPIERRORS | IDLETIME | TIMESTATS | USERFILTER | PROGRAMFILTER | DATAAREAFILTER | TIMESTATSDIR [value]

Allows the administrator to change certain database configuration parameters without stopping the database service.

Parameter Description
idle [DataArea] Stop the idle database drivers within a data area.
idleALL Stop the idle database drivers for all data areas.
get Get the current value for the ladb.cfg configuration file variable specified by the flag following the -get parameter.
set Set the ladb.cfg configuration file variable to the specified value.
REUSE [value]

Enable or disable reuse of idle driver connections by ladb.

When setting REUSE, you can specify a value. Valid values are OFF or ON; FALSE or TRUE; 0 or 1.
DEBUG [value]

Enable or disable debug mode.

When setting DEBUG, you can specify a value. Valid values are OFF or ON; FALSE or TRUE; 0 or 1.
DBAPIERRORS [value]

Enable or disable logging of database API errors.

When setting DEBUG, you can specify a value. Valid values are OFF or ON; FALSE or TRUE; 0 or 1.
IDLETIME [value]

Specify how long a database driver can be idle before it is stopped.

When setting IDLETIME, you can specify a value in minutes.
TIMESTATS [value]

Enable or disable timed statistics collection.

When setting TIMESTATS, you can specify a value. Valid values are OFF or ON; FALSE or TRUE; 0 or 1.
USERFILTER [value]

Specify a name of a user to monitor. If a user name has no program listed next to it, all programs being run by that user are monitored.

Requires TIMESTATS set to TRUE.

Note: If you have modified the USER_FILTER parameter with a prefix to identify a user as an operating system user (USER_FILTER=OSID:username) or a web user (USER_FILTER=LOBS:username), you need to remove the prefix (OSID: or LOBS:) from this parameter.
DATAAREAFILTER [value]

Specify a data area to monitor when using timed statistics.

Requires TIMESTATS set to TRUE.
PROGRAMFILTER [value]

Specify a program to monitor when using timed statistics. If the program has no user entry preceding it, all instances of this program are monitored.

Requires TIMESTATS set to TRUE.
TIMESTATSDIR [value]

The directory for the output files from the timed statistics monitor. This must be an absolute path.

The default for Oracle or IBM DB2 on UNIX and Windows is tmp.

The default for MS SQL is whatever TMP is set to in Windows.