Start DPR Apply (STRDPRAPY)
The Start DPR Apply (STRDPRAPY) command starts an instance of
the DataPropagator for iSeries Apply process at the copy
server.
- Note: Do not precede an entry with an asterisk unless that
entry is shown on the display itself or in the help information
with an asterisk.
Error Messages for STRDPRAPY
*ESCAPE Messages
- ASN1502
- Unable to find the local relational database name.
- ASN1503
- Apply qualifier "" is a restricted value.
- ASN1504
- No subscriptions are defined for apply qualifier "" at control
server .
- ASN1505
- The subscription set table, ASN.IBMSNAP_SUBS_SET was not
found.
- ASN1506
- Can not create the apply job table, IBMSNAP_APPLY_JOB in
library ASN.
- ASN1507
- The apply job table, IBMSNAP_APPLY_JOB in library ASN, is not
available.
- ASN1513
- An Apply job record was not found in the Apply Job table.
- ASN1516
- Cannot verify that subscriptions exist for apply qualifier
"".
- ASN1517
- Connection to control server failed.
- ASN1518
- Cannot read or change the IBMSNAP_APPLY_JOB table.
- ASN1519
- STRDPRAPY command failed.
- ASN4524
- The apply job table was not found.
- ASN2060
- Library is not allowed in the system portion of the library
list.
| Keyword |
Description |
Choices |
Notes |
| USER |
User |
Name, *CURRENT, *JOBD |
Optional, Positional 1 |
| JOBD |
Job description |
Qualified object name |
Optional, Positional 2 |
| Qualifier 1: Job description |
Name, QZSNDPR |
| Qualifier 2: Library |
Name, *LIBL |
| APYQUAL |
Apply qualifier |
Character value, *USER |
Optional, Positional 3 |
| CTLSVR |
Control server |
Character value, *LOCAL |
Optional, Positional 4 |
| TRACE |
Trace |
*NONE, *ERROR, *ALL, *PRF,
*REWORK |
Optional, Positional 5 |
| FULLREFPGM |
Full refresh program |
Single values: *NONE
Other values: Qualified object name |
Optional, Positional 6 |
| Qualifier 1: Full refresh program |
Name |
| Qualifier 2: Library |
Name |
| SUBNFYPGM |
Subscription notify program |
Single values: *NONE
Other values: Qualified object name |
Optional, Positional 7 |
| Qualifier 1: Subscription notify program |
Name |
| Qualifier 2: Library |
Name |
| INACTMSG |
Inactive message |
*YES, *NO |
Optional, Positional 8 |
| ALWINACT |
Allow inactive state |
*YES, *NO |
Optional, Positional 9 |
| DELAY |
Delay |
0-6, 6 |
Optional, Positional 10 |
| RTYWAIT |
Retry wait time |
0-35000000, 300 |
Optional, Positional 11 |
| COPYONCE |
Copy Once |
*YES, *NO |
Optional, Positional 12 |
| TRLREUSE |
Trail Reuse |
*YES, *NO |
Optional, Positional 13 |
| OPTSNGSET |
Optimize single set |
*YES, *NO |
Optional, Positional 14 |
User (USER)
Specifies the name of the user for which the Apply process is to
be started. The user must have *USE rights for the specified user
profile.
This is the user profile under which the Apply process runs. The
subscription control tables (in ASN) are located on the relational
database (RDB) specified with the CTLSVR parameter. The same
subscription control tables are used regardless of the value used
on the USER parameter.
- *CURRENT
- The user associated with the current job is the user associated
with this instance of the Apply process.
- *JOBD
- The user specified in the job description is associated with
this instance of the Apply process. The job description cannot have
USER(*RQD) specified.
- user name
- The user specified is the user associated with this instance of
the Apply process. The following IBM-supplied objects are not valid
on this parameter:
- QDBSHR
- QDFTOWN
- QDOC
- QLPAUTO
- QLPINSTALL
- QRJE
- QSECOFR
- QSPL
- QSYS
- QTSTRQS
If any of the above listed users have added subscriptions, the
STRDPRAPY command must be run by the user signed on with that
user name.
Job description (JOBD)
Specify the name of the job description to use when submitting
the Apply process.
- *LIBL/QZSNDPR
- The default job description provided with the product.
- job-description-name
- The name (library-name/job-description-name) of the job
description used for the Apply process.
- *LIBL/job-description-name
- The name of the job description used for the Apply
process.
Apply qualifier (APYQUAL)
Specifies the apply qualifier used by Apply. All subscriptions
that are grouped together with this apply qualifier are being run
by this apply instance.
- *USER
- The user name specified on the USER parameter is the apply
qualifier.
- apply-qualifier
- Specifies the name which is used to group the subscriptions
that are to be run by this Apply instance. You can specify a
maximum of 18 characters for the apply qualifier name. This name
follows the same naming conventions as an RDB name. The
subscriptions to be run are identified by the records in the
IBMSNAP_SUBS_SET table with this value in the APPLY_QUAL
column.
Control server (CTLSVR)
The relational database name where the subscription control
tables are located. This is the relational database name for the
control server.
- *LOCAL
- The subscription control tables are located on the local
relational database.
- rdb-name
- A relational database name. You can press F4 (Prompt) on this
parameter to choose from the list of RDBs in the RDB directory. You
can also use the Work with RDB Directory Entries (WRKRDBDIRE)
command to find this name.
Trace (TRACE)
This parameter specifies whether Apply is to generate a trace.
If Apply generates a trace, the trace will be sent to a spool file
called QPZSNATRC.
- *NONE
- No trace will be done.
- *ERROR
- The trace will contain information for errors only.
- *ALL
- The trace will contain information for errors, execution flow,
and SQL statements issued by Apply.
- *PFR
- The trace will contain information which can be used to analyze
performance at different stages of Apply execution.
Full refresh program (FULLREFPGM)
Specifies whether Apply runs a user extension program to
full-refresh a target table. When Apply determines that a target
table needs to be fully refreshed, it will run the specified user
extension program rather than doing the full-refresh itself. When
Apply uses a full refresh user extension program, the ASNLOAD
column in the apply audit trail record will have a value of
'Y'.
- *NONE
- No user extension program will be run.
- program-name
- The qualfied name of a program that will be called when Apply
determines it is necessary to do a full-refresh of a target
table.
Subscription notify program (SUBNFYPGM)
Specifies whether Apply is to run a user extension program when
it has completed processing of a subscription set. You could use
the notify program to examine the "CAPCTLLIB".IBMSNAP_UOW table;
you could determine the transactions that have been rejected and
take further actions, such as issuing a message or generating an
event.
- *NONE
- No user extension program will be run.
- program-name
- The qualfied name of a program that will be called when Apply
completes processing a subscription set.
Inactive message (INACTMSG)
Specifies whether Apply is to generate a message whenever it has
completed its work and will become inactive for a period of
time.
- *NO
- No message is generated.
- *YES
- Apply will generate an ASN1044 message before beginning a
period of inactivity. The ASN1044 message will tell how long the
Apply process will be inactive.
Allow inactive state (ALWINACT)
Specifies whether or not the Apply process can run in an
inactive state (sleep).
- *YES
- The Apply process can sleep if there is nothing to
process.
- *NO
- The Apply process ends if there is nothing to process.
Delay (DELAY)
Specifies the delay time(in seconds) at the end of each Apply
program cycle when continuous replication is used.
- 6
- Specifies a delay time of six seconds.
- delay-time
- Specifies a delay time between 0 and 6 seconds inclusive.
Retry wait time (RTYWAIT)
Specifies in seconds how long the Apply program should wait
after it encounters an error before it retries the operation that
failed.
- 300
- Specifies a retry wait time of 300 seconds.
- retry-wait-time
- Specifies a retry wait time between 0 and 35000000 seconds
inclusive.
Copy Once (COPYONCE)
The Apply program executes one copy cycle for each subscription
set that is eligible at the time the Apply program is invoked, and
then the Apply program terminates. An eligible subscription set is
such that:
ACTIVE > 0
REFRESH_TIMING = R or B or REFRESH_TIMING = E and the specified
event has occurred.
MAX_SYNCH_MINUTES and END_OF_PERIOD are honored if
specified.
- *NO
- Specifies that COPYONCE is not used.
- *YES
- Specifies that COPYONCE will be in effect.
Trail Reuse (TRLREUSE)
The Apply program empties the Apply trail table when the Apply
program is started.
- *NO
- Specifies that TRLREUSE is not used.
- *YES
- Specifies that TRLREUSE will be in effect.
Optimize single set (OPTSNGSET)
Specifies to optimize Apply performance when there is only one
subscription set. If the parameter is specified and the set to be
processed is the same as the previous set, Apply will not fetch the
members and columns information from the control table again. This
option does not apply to REPLICA.
- *NO
- Specifies that OPTSNGSET is not used.
- *YES
- Specifies that OPTSNGSET will be in effect.
*ESCAPE Messages
- ASN1502
- Unable to find the local relational database name.
- ASN1503
- Apply qualifier "" is a restricted value.
- ASN1504
- No subscriptions are defined for apply qualifier "" at control
server .
- ASN1505
- The subscription set table, ASN.IBMSNAP_SUBS_SET was not
found.
- ASN1506
- Can not create the apply job table, IBMSNAP_APPLY_JOB in
library ASN.
- ASN1507
- The apply job table, IBMSNAP_APPLY_JOB in library ASN, is not
available.
- ASN1513
- An Apply job record was not found in the Apply Job table.
- ASN1516
- Cannot verify that subscriptions exist for apply qualifier
"".
- ASN1517
- Connection to control server failed.
- ASN1518
- Cannot read or change the IBMSNAP_APPLY_JOB table.
- ASN1519
- STRDPRAPY command failed.
- ASN4524
- The apply job table was not found.
- ASN2060
- Library is not allowed in the system portion of the library
list.