Start DPR Apply (STRDPRAPY)
| Where allowed to run: All
environments (*ALL) Threadsafe: No |
Parameters Examples Error messages |
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.
| Top |
Parameters
| 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 |
| Top |
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.
| Top |
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.
| Top |
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.
| Top |
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.
| Top |
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.
| Top |
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.
| Top |
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.
| Top |
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.
| Top |
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.
| Top |
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.
| Top |
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.
| Top |
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.
| Top |
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.
| Top |
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.
| Top |
Examples
None| Top |
Error messages
*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.
| Top |