Queue indexes needed for Q Apply on z/OS

Technote (FAQ)


Question

How do I define a receive queue for Q Apply on zOS?

Cause

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.

Answer

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 +
QLOCAL(CAPA.TO.APPA.RECVQ) +
DESCR('LOCAL RECEIVE QUEUE - CAPA TO APPA') +
PUT(ENABLED) +
GET(ENABLED) +
SHARE +
DEFSOPT(SHARED) +
DEFPSIST(YES) +
INDXTYPE(MSGID)

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.

Rate this page:

(0 users)Average rating

Document information


More support for:

InfoSphere Replication Server
Q Apply

Software version:

8.2, 9.1

Operating system(s):

z/OS

Software edition:

Edition Independent

Reference #:

1315366

Modified date:

2013-04-30

Translate my page

Machine Translation

Content navigation