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 IBM DB2 on IBM i is tmp.