Specifying a default model queue

You can change the name of the default model queue that the Q Apply program uses to create spill queues for the loading process.

About this task

About this task

By default, the Q Apply program uses IBMQREP.SPILL.MODELQ as the name for the model queue.

Procedure

Procedure

  • When you create Q subscriptions with the ASNCLP command-line program or Replication Center, you can specify a different model queue name for individual Q subscriptions.
  • When you start the Q Apply program you can also override the default model queue name by using the dfltmodelq parameter.

    The following list summarizes the behavior of the dftmodelq parameter:

    If you specify dftmodelq when you start Q Apply
    For each Q subscription, Q Apply will check to see if you specified a model queue name for the Q subscription by looking at the value of the MODELQ column in the IBMQREP_TARGETS control table:
    • If the value is NULL or IBMQREP.SPILL.MODELQ, then Q Apply will use the value that you specify for the dftmodelq parameter.
    • If the column contains any other non-NULL value, then Q Apply will use the value in the MODELQ column and will ignore the value that you specify for the dftmodelq parameter.
    If you do not specify dftmodelq when you start Q Apply
    Q Apply will use the value of the MODELQ column in the IBMQREP_TARGETS table. If the value is NULL, Q Apply will default to IBMQREP.SPILL.MODELQ.