DB2 Replication Guide and Reference

Operating DataPropagator for Microsoft Jet

You can use the commands in this section to operate DataPropagator for Microsoft Jet.

This section explains how to perform the following tasks:

• Starting Capture at the source server
• Starting DataPropagator for Microsoft Jet at the client
• Stopping DataPropagator for Microsoft Jet at the client
• Troubleshooting DataPropagator for Microsoft Jet at the client

Starting Capture at the Source Server

Before you start DataPropagator for Microsoft Jet, you must start the Capture program on each DB2 source server, if applicable.

Starting DataPropagator for Microsoft Jet

Before you start DataPropagator for Microsoft Jet, you must establish any required line or LAN connection. DataPropagator for Microsoft Jet does not directly manage telephone connections, so you need to dial up the server manually or use any software that provides auto-dialing to establish a connection before you call DataPropagator for Microsoft Jet to perform database synchronization.

To start DataPropagator for Microsoft Jet, use the ASNJET command. Enter the ASNJET command from a command prompt.

>>-ASNJET--apply_qual--ctrl_srvr----+----------+---+---------+-->
                                    +-INAMSG---+   +-NOTRC---+
                                    '-NOINAMSG-'   +-TRCERR--+
                                                   '-TRCFLOW-'
 
>-----+----------+---+----------+------------------------------><
      +-NOTIFY---+   +-MOBILE---+
      '-NONOTIFY-'   '-NOMOBILE-'
 

Table 20 defines the parameters.

Table 20. ASNJET Command Parameter Definitions for DataPropagator for Microsoft Jet

Parameter Definition
apply_qual Specifies the Apply qualifier that uniquely identifies this client.
ctrl_srvr Specifies the control server alias.
INAMSG Specifies that DataPropagator for Microsoft Jet issue an inactivity message to the log whenever DataPropagator for Microsoft Jet is going to sleep until the next copy cycle. This option is ignored if you specify the MOBILE option. NOINAMSG  (default)  Specifies that no inactivity message is issued.
NOTRC  (default)  Specifies that no trace file is created. TRCERR Specifies that a trace file of minimal information is created. TRCFLOW Specifies that a trace file of extensive information is created.
NOTIFY Specifies that DataPropagator for Microsoft Jet call the ASNJDONE exit at the completion of each set subscription, regardless of success or failure. NONOTIFY  (default)  Specifies that DataPropagator for Microsoft Jet does not call the ASNJDONE exit.
MOBILE Specifies that DataPropagator for Microsoft Jet run in mobile mode (copy all active subscriptions only once, and then terminate). NOMOBILE  (default)  Specifies that DataPropagator for Microsoft Jet run continuously until it is stopped with the ASNJSTOP command.

Example 1: If you enter the following command from a command prompt:

ASNJET MYQUAL CNTLSRVR MOBILE

DataPropagator for Microsoft Jet is invoked with the Apply qualifier MYQUAL, the control server is CNTLSRVR, no inactivity message is generated, no trace is produced, the ASNJDONE user exit is not called, and the active subscriptions are copied only once and then the program exits.

Example 2: If you enter the following command from a command prompt:

ASNJET AQ2 CNTLSRV TRCFLOW NOMOBILE

DataPropagator for Microsoft Jet is invoked with the Apply qualifier AQ2, the control server is CNTLSRV, an extensive trace is produced, and the program runs continuously until you stop it with the ASNJSTOP command.

Stopping DataPropagator for Microsoft Jet

When you start DataPropagator for Microsoft Jet using the MOBILE option, it runs until all active subscriptions are processed, and then terminates by itself. If you want to stop DataPropagator for Microsoft Jet, you can use the ASNJSTOP command to stop the program in an orderly way as soon as the current subscription set is copied and commit the log records processed up to that point.

Use the following command to stop DataPropagator for Microsoft Jet. Enter the ASNJSTOP command from a command prompt.

>>-ASNJSTOP--apply_qual----------------------------------------><
 

Where apply_qual is the Apply qualifier that you used when you started DataPropagator for Microsoft Jet with the ASNJET command.

Example: If you enter the following command from a command prompt:

ASNJSTOP MYQUAL

DataPropagator for Microsoft Jet stops processing the Apply qualifier MQUAL as soon as the current subscription set is processed.

You can also use one of the following key combinations from the window where the program is running to stop DataPropagator for Microsoft Jet:

• Ctrl+C
• Ctrl+Break

Troubleshooting DataPropagator for Microsoft Jet

If you encounter errors when you run ASNJET, ensure that:

• All replication sources and subscriptions are defined.

• The Capture program is started on the source server, if applicable.

• The control server and source server are registered as ODBC data sources.

• You supplied a password file in the ASNJETPATH directory.

• If you opened and updated a row-replica target table through Microsoft Access, you closed the table.

For error message information, see Chapter 21. IBM Replication Messages. For more information about troubleshooting, see Troubleshooting.

[ DB2 List of Books | Search the DB2 Books ]