In the Windows edition of Datareplicator or HiRDB version 08-02 or later, execute this command from the source HiRDB's command prompt.

Function

The hdeevent command sends a specified event code to a target system in order to control import processing. Before you can use the hdeevent command, you must create an event control table at the source HiRDB. For details about the event control table, see 4.6.7 Designing the event control table.

Format

hdeevent -n event-code
       [ -u user-ID/password ][ -s target-identifier ]

Options

-n event-code

Specify an event code. The specifiable event codes are as follows:

0

Stops the transmission process.

1-255

Sends the specified event code to the target Datareplicator.

-u user-ID/password

user-ID ~ <symbolic name of 1-8 characters>

password ~ <symbolic name of 1-28 characters>

Specify the user ID and password used to create the event control table. Both user ID and password are case-sensitive. Do not specify any spaces before or after the delimiter slash (/). For the user ID, specify a symbolic name of 1 to 8 characters; for the password, specify a symbolic name of 1 to 28 characters.

If you omit the -u option, Datareplicator assumes the value of the PDUSER environment variable for the source HiRDB. If this environment variable is not specified, the hdeevent command results in an error during connection establishment processing with the source HiRDB.

-s target-identifier

Specify the identifier of the target that is to be the destination of the event. Specifying ** as the target identifier will result in an invalid-argument error. If you omit the -s option, Datareplicator sends the event to all destinations.

Rules

• When the hdeevent command is executed, the source Datareplicator issues an SQL statement to the event control table that has been created at the source HiRDB. The update log for this SQL statement is stored in the system log file. The source Datareplicator extracts this update information from the system log and sends it as an event to the target system(s).
• Specify the event code and import processing to be executed in the target Datareplicator's import environment definition. If an event is issued and its event code is not defined in the import environment definition, there is no effect on the import processing. However, a message is output to the target system's syslog file.
• If the hdeevent command terminates normally, it returns 0. If it terminates abnormally, it returns 1.
• If the event code is outside the range of 1 to 255, the event will not be sent to the target Datareplicator.

Notes

• You can execute the hdeevent command only while the source HiRDB is active. An error results if you execute it while the source HiRDB is inactive.
• Execute the hdeevent command while no transactions are being processed at the source system. If it is executed during transaction processing, Datareplicator might not be able to identify the transaction to which the specified event applies. In such a case, conformity between the source and target databases might be lost.
• If the source HiRDB is a parallel server, execute the hdeevent command from the server machine containing the system manager. If the hdeevent command is executed from a server machine that does not contain the system manager and the -s option is specified, an error results and the KFRB04001-E message is output.
  Even if audit trail collection is suppressed, Datareplicator ignores the hirdb_audit_trail operand and performs audit trail collection.