state

Use

You show the status of all event dispatchers belonging to a database instance.

Prerequisites

DBM operators with the following properties can use the state command:

?     server authorization EvtDispAdmin. These DBM operators receive a list of all event dispatchers for the database instance.

?     server authorization EvtDispUse. These DBM operators receive a list of event dispatchers started under their user name.

Procedure

dbmevtdisp state <database_authentication>

<database_authentication> :: = -d <database_name> <user_authentication> [-n <database_computer> [-e SSL]]

<user_authentication> :: = -u <user_data> |-U <user_key>

<user_data> :: = <dbm_operator>,<dbm_operator_password>

Option

Description

<database_name>

Name of the database instance monitored

<database_computer>

Name of the database computer

SSL

Encryption method

See Database Manager CLI, -e: Activate Encryption

<user_key>

XUSER key

See Utilities, XUSER

<dbm_operator>,<dbm_operator_password>

DBM user data that is used by the event dispatcher to log on to the database instance to be monitored

See Database Manager CLI, user_logon

Result

OK
Instance ID <instance_ID_1>
   user: <dbm_user_name_1>
   host: <database_computer_1>
   configuration file: <configuration_file_1>
   log file: <log_file_1>
.
.
.
Instance ID <instance_ID_n>
   user: <dbm_user_name_n>
   host: <database_computer_n>
   configuration file: <configuration_file_n>
   log file: <log_file_n>

Field

Description

<instance_ID_n>

ID of event dispatcher n

<dbm_user_name_n>

DBM operator that started event dispatcher n

<database_computer_name_n>

Database computer on which event dispatcher n is running

<configuration_file_n>

Configuration file used by event dispatcher n

<log_file_n>

Log file used by event dispatcher n

Example

The DBM operator OLEG with the password MONDAY display the event dispatcher for database instance DEMODB on the local computer.

>dbmevtdisp state -d DEMODB -u OLEG,MONDAY

OK
Instance ID 1
        user: OLEG
        host: PARMA
        configuration file: testconfig.cfg
        log file: mylog.log
Instance ID 0
        user: DBADMIN
        host: GENUA
        configuration file: ed.cfg
        log file: ed.log

The following event dispatchers are currently running for database instance DEMODB.

?     Event dispatcher with ID 1

0     Started by DBM user OLEG on computer PARMA

0     Configuration file testconfig.cfg

0     Log file mylog.log

?     Event dispatcher with ID 0

0     Started by DBM user OLEG on computer GENUA

0     Configuration file ed.cfg

0     Log file ed.log

See also:

Overview of Event Dispatcher Commands