Use the asnqapp command on Linux, UNIX, Windows, and UNIX System Services (USS) on z/OS® to start a Q Apply program. Run this command
at an operating system prompt or in a shell script. Any startup parameters
that you specify will apply to this session only.
After you start the Q Apply program, it runs continuously
until you stop it or it detects an unrecoverable error.
Syntax
>>-asnqapp--apply_server=db_name -+---------------------+------->
'-apply_schema=schema-'
>--+-----------------+--+--------------+------------------------>
'-apply_path=path-' '-applydelay=n-'
>--+-------------------------------------------------+---------->
| .-WAIT---. |
+-applyupto=-+-gmt_timestamp--,--+-NOWAIT-+-----+-+
| | .-WAIT---. | |
| '-CURRENT_TIMESTAMP--,--+-NOWAIT-+-' |
| .-y-. |
'-autostop=-+-n-+---------------------------------'
>--+----------------+--+-------------------------+-------------->
'-arm=identifier-' | .-n-. |
'-buffered_inserts=-+-y-+-'
>--+------------+--+------------------------+------------------->
| .-n-. | '-classic_load_file_sz=n-'
'-caf=-+-y-+-'
>--+----------------+--+--------------------+------------------->
'-commit_count=n-' '-deadlock_retries=n-'
>--+----------------------------------+------------------------->
'-dftmodelq=model_spill_queue_name-'
>--+------------------------------------------------+----------->
| .-n-------------------------------. |
'-event_gen=-+-y--| event-generation-options |-+-'
>--+-----------------------------------------+------------------>
'-gdps_total_num_cg_override=total_num_cg-'
>--+---------------------------------------------+-------------->
| .-n-. |
'-ignbaddatagdps_total_num_cg_override=-+-y-+-'
>--+------------------------------------------------------+----->
| .-y-. |
'-insert_bidi_signal=-+-n-+-+------------------------+-'
'-loadcopy_path=filepath-'
>--+---------------------+--+------------------------+---------->
'-load_data_buff_sz=n-' | .-gmt---. |
'-logmarkertz=-+-local-+-'
>--+-----------------+------------------------------------------>
| .-n-. |
'-logreuse=-+-y-+-'
>--+-------------------------------------------+---------------->
| .-n-. |
'-logstdout=-+-y-+-+----------------------+-'
'-max_parallel_loads=n-'
>--+--------------------+--+-----------------+------------------>
'-monitor_interval=n-' '-monitor_limit=n-'
>--+-------------------------+--+----------------------+-------->
| .-n-. | '-nickname_commit_ct=n-'
'-multi_row_insert=-+-y-+-'
>--+-------------------+--+-------------------+----------------->
| .-n-. | '-nmi_socket_name=n-'
'-nmi_enable=-+-y-+-'
>--+-------------------------+--+-------------------+----------->
| .-y-. | | .-n-. |
'-oracle_empty_str=-+-n-+-' '-p2p_2nodes=-+-y-+-'
>--+--------------------+--+------------------+----------------->
'-prune_batch_size=n-' '-prune_interval=n-'
>--+---------------------+--+-------------------------+--------->
| .-1-. | | .-asnpwd.aut-. |
'-prune_method=-+-2-+-' '-pwdfile=-+-filename---+-'
>--+-------------------------+--+------------+------------------>
| .-y-. | '-richklvl=n-'
'-report_exception=-+-n-+-'
>--+-------------+--+---------------------------------+--------->
| .-y-. | '-skiptrans=-| skiptrans-clause |-'
'-term=-+-n-+-'
>--+----------------------+--+------------------+--------------->
'-spill_commit_count=n-' '-startallq=-+-y-+-'
'-n-'
>--+------------------+--+---------------+---------------------><
| .-n-. | '-trace_limit=n-'
'-trace_ddl=-+-y-+-'
event-generation-options
|--+------------------+--+-------------+--+---------------+----->
'-event_interval=n-' '-eif_hbint=n-' '-event_limit=n-'
>--+-------------------------+--+-------------------------+-----|
'-eif_conn1=address(port)-' '-eif_conn2=address(port)-'
skiptrans-clause:
.-,-----------------------------------------------------------------.
V |
|----+---------------------------------------------------------------+-+--|
'-receive_queue--;--+-transaction_ID--------------------------+-'
'-begin_transaction_ID-end_transaction_ID-'
Q Replication and Event Publishing