PI76457: INSERTS INTO NON-CONDENSED CCD MAY FAIL WHEN MRI IS ENABLED

Obtain the fix for this APAR.

APAR status

• Closed as unreproducible in next release.

Error description

• Q Apply may show SQLCODE -180, and a message that it is falling
  back to single row inserts for that Q Subscription
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: 1- Japan Broadcasting Corporation            *
  *                 2- All Q Capture customers.                  *
  *                 3- All Q Capture customers.                  *
  *                 4- All Capture customers.                    *
  *                 5- Q Capture                                 *
  *                 6- Users of non-condensed CCDs               *
  *                 7- Users of non-condensed CCD target tables  *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1- Customer did accidentally two        *
  *                      capstarts, which caused unexpected      *
  *                      conflicts.                              *
  *                      2- Q Capture restarts a subscription    *
  *                      if it detects that the subscription     *
  *                      source table was loaded and the         *
  *                      CAPTURE_LOAD option is set to R.  Q     *
  *                      Capture waits for inflight              *
  *                      transactions to commit before it        *
  *                      restarts the subscription.  Q Capture   *
  *                      adds the subscription to a list of      *
  *                      subscriptions that are waiting for      *
  *                      inflight transactions to commit.  Q     *
  *                      Capture may abend with S0C4 in          *
  *                      subMgr::checkForQSubsWaitingForInflight *
  *                      s if a subscription list next address   *
  *                      is not initialized.                     *
  *                      3- Q Capture reinitializes after an     *
  *                      MQPUT operation to a send queue fails   *
  *                      and the send queue IBMQREP_SENDQUEUES   *
  *                      ERROR_ACTION is 'Q'.  Q Capture reinit  *
  *                      activates all send queues if the        *
  *                      IBMQREP_CAPPARMS STARTALLQ specifies    *
  *                      'Y'.                                    *
  *                      4- Capture stops after it makes an      *
  *                      IFCID 306 READS request and DB2         *
  *                      returns resource unavailable            *
  *                      (00E60863).                             *
  *                      5- When control tables at ARCH_LEVEL    *
  *                      1021 are migrated to 1140, Q Capture    *
  *                      at 10.2.1 will stop with -305           *
  *                      6- Q Apply may show SQLCODE -180, and   *
  *                      a message that it is falling back to    *
  *                      single row inserts for that Q           *
  *                      Subscription                            *
  *                      7- The automatically selected           *
  *                      replication key can cause               *
  *                      over-serialization of workload reply    *
  *                      when cardinality of that column is      *
  *                      low.                                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  1- When apply receives two capstart schema msg, it is possible
  that apply does initial load to the same sub twice and sends
  two loaddone signal to capture. Capture will report an error
  when it receives the second loaddone signal and find the sub is
  in 'A' state.
  2- Q Capture should initialize the subscription list next
  address when it adds a subscription to its waiting for inflight
  transactions to commit list.
  3- Q Capture reinit should should not activate a send queue
  after an MQPUT operation to the send queue fails.
  4- Capture should retry an IFCID 306 READS 'F' request after
  DB2 returns resource unavailable (00E60863).
  5- Q Capture is incorrectly constructing the query against the
  IBMQREP_CAPPARMS table
  6- The binding of data for columns containing before values is
  incorrect
  7- An option CHKDEP_NONCONDCCD can be added to the startup
  parms of Q Apply. When set to N, it will disable dependency
  checking for non condensed CCD targets.
  

Problem conclusion

Temporary fix

Comments

• 1- With this fix, capture rejects the second CAPSTART signal
  when sub state is in 'L'.
  2- Q Capture will initialize the subscription list next address
  when it adds a subscription to its waiting for inflight
  transactions to commit list.
  3- Q Capture reinit will not activate a send queue after an
  MQPUT operation to the send queue fails.
  4- Capture will retry an IFCID 306 READS 'F' request after DB2
  returns resource unavailable (00E60863).
  5- The problem is resolved, and Q Capture will start
  successfully when running against ARCH_LEVEL 1140 control
  tables
  6- The problem is resolved
  7- All serialization is removed for non condensed CCD targets.
  Please note that this can result in the inserts being applied
  in a different order than if serialization was taking place.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI45367 UI45368 UI45369 UI45370

Modules/Macros

•    ASNAAPP  ASNACMD  ASNACMP  ASNADMSP ASNAFET
  ASNAISO  ASNAMAN  ASNAPPLY ASNAPRS  ASNAWPN  ASNCAP   ASNCCMD
  ASNCTLZD ASNMCMD  ASNMON   ASNQACMD ASNQAPP  ASNQAROW ASNQBNDL
  ASNQCAP  ASNQCCMD ASNQDEP  ASNQEXRP ASNQLODZ ASNQMFMT ASNQXFMT
  ASNRBASE ASNTDIFF ASNTDSP  ASNTRC   ASN2BASE
  

Fix information

• Fixed component name

  WS REPLICATION

• Fixed component ID

  5655L8800

Applicable component levels

• RA21 PSY UI45367

     UP17/03/16 P F703

• RA24 PSY UI45368

     UP17/03/16 P F703

• RA25 PSY UI45369

     UP17/03/16 P F703

• RA26 PSY UI45370

     UP17/03/16 P F703

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.