Queue indexes needed for Q Apply on z/OS
How do I define a receive queue for Q Apply on zOS?
Data not replicating. Q Apply appears to be stuck processing a receive queue either on startup or after detecting a gap in the messages with ASN7551E, or transactions are not being applied even with a high value for QDEPTH.
If you encounter this situation, check the following items:
- Is INDXTYPE(MSGID) defined?
On zOS, define the receive queue as follows to include INDXTYPE(MSGID):
DEFINE REPLACE +
DESCR('LOCAL RECEIVE QUEUE - CAPA TO APPA') +
If you did not add an index based on the message ID when you defined the receive queue, you might experience the Q Apply browser thread for the receive queue hanging and there might not be any error messages in the Q Apply log.
- Is IBMQREP_DONEMSG in its own tablespace?
The IBMQREP_DONEMSG table should be in its own table space with row-level locking, and this table space should be reorganized regularly, for example once a week.
More support for:
InfoSphere Replication Server
Software version: 8.2, 9.1
Operating system(s): z/OS
Software edition: Edition Independent
Reference #: 1315366
Modified date: 30 April 2013