ENDDPRCAP: Stopping Capture (System i)

Use the End DPR Capture (ENDDPRCAP) command to stop the Capture program.

Use this command to stop the Capture program before shutting down the system. You might also want to stop the program during periods of peak system use to increase the performance of other programs that run on the system.

After you type the command name on the command line, you can press the F4 key to display the command syntax.

To display a complete description of this command and all of its parameters, move the cursor to the command at the top of the screen and press the F1 key. To display a description of a specific parameter, place the cursor on that parameter and press the F1 key.

Syntax


>>-ENDDPRCAP--+-------------------------+----------------------->
              |          .-*CNTRLD-.    |   
              '-OPTION(--+-*IMMED--+--)-'   

>--+-----------------------------------+------------------------>
   |               .-ASN----------.    |   
   '-CAPCTLLIB--(--+-library-name-+--)-'   

>--+---------------------------+-------------------------------><
   |               .-*NO--.    |   
   '-RGZCTLTBL--(--+-*YES-+--)-'

Table 1 lists the invocation parameters.

Table 1. ENDDPRCAP command parameter definitions for System i
Parameter	Definition and prompts
OPTION	Specifies how to stop the Capture program. CNTRLD (default) The Capture program stops normally after completing all tasks. The ENDDPRCAP command might take longer when you specify the CNTRLD option because the Capture program completes all of its subordinate processes before stopping. IMMED The Capture program stops normally after completing all tasks with the ENDJOB OPTION(IMMED) command.
CAPCTLLIB	Specifies the Capture schema, which is the name of the library in which the Capture control tables are located. This library includes the IBMSNAP_REGISTER table, which stores the registration information of the source tables. ASN (default) The Capture control tables are in the ASN library. The ASN library is the default library. library-name The name of a library that contains the Capture control tables.
RGZCTLTBL	Specifies whether a Reorganize Physical File Member (RGZPFM) command is performed on the control tables (including the change-data (CD) and unit-of-work (UOW) tables) when the Capture program ends. The system does not recover disk space unless the RGZPFM command process is performed on the tables. The RGZPFM command will not be performed if the control tables are being accessed by an Apply program or by other application programs. NO (default) The RGZPFM command is not performed. YES The RGZPFM command is performed.

Usage notes

If you use the ENDJOB command, temporary objects might be left in the QDP4 library. These objects have the types *DTAQ and *USRSPC, and are named QDP4nnnnnn, where nnnnnn is the job number of the job that used them. You can delete these objects when the job that used them (identified by the job number in the object name) is not active.

If the job under the Capture control library will not end after issuing this command, use the ENDJOB command with *IMMED option to end this job and all the journal jobs running in the DB2® DataPropagator for System i® subsystem. Do not end Apply jobs running in the same subsystem if you want to end only the Capture program.

In rare cases when the Capture control job ends abnormally, the journal jobs created by Capture control job (which is named according to the CAPCTLLIB parameter) might still be left running. The only way to end these jobs is to use the ENDJOB command with either the *IMMED or *CNTRLD option.

Examples for ENDDPRCAP

The following examples illustrate how to use the ENDDPRCAP command.

Example 1:

To end the Capture program, which uses Capture control tables in the ASN library, after all processing tasks are completed:

ENDDPRCAP OPTION(*CNTRLD) CAPCTLLIB(ASN) RGZCTLTBL(*NO)

Example 2:

To end the Capture program immediately for the Capture schema BSN:

ENDDPRCAP OPTION(*IMMED) CAPCTLLIB(BSN) RGZCTLTBL(*NO)

Example 3:

To end the Capture program after all processing tasks are completed and to reorganize the Capture control tables:

ENDDPRCAP OPTION(*CNTRLD) CAPCTLLIB(ASN) RGZCTLTBL(*YES)