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 the Capture program 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 the Capture program 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 32 defines the parameters.

Table 32. 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)
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 routine at the completion of each subscription set, regardless of success or failure.
NONOTIFY  (default)	Specifies that DataPropagator for Microsoft Jet does not call the ASNJDONE exit routine.
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, 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 exit routine is not called, and the active subscriptions are copied only once and then the program exits.

ASNJET MYQUAL CNTLSRVR MOBILE

Example 2: If you enter the following command from a command prompt, 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.

ASNJET AQ2 CNTLSRV TRCFLOW NOMOBILE

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, DataPropagator for Microsoft Jet stops processing the Apply qualifier MQUAL as soon as the current subscription set is processed.

ASNJSTOP MYQUAL

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 defined 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 Capture and Apply messages. For more information about troubleshooting, see Troubleshooting.

[ DB2 List of Books | Search the DB2 Books ]