PI85567: Q CAPTURE DISPLAYS ASN0530E AND STOPS IF THE DB2 SUBSYSTEM NAME IS LESS THAN 4 CHARACTERS

Obtain the fix for this APAR.

APAR status

• Closed as unreproducible in next release.

Error description

• Q Capture displays 'ASN0530E The program could not connect to
  database "DBB" with USERID "N/A" SQLCODE is "c f30006".' and
  stops if the DB2 subsystem name is less than 4 characters.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: 1- Q Capture                                 *
  *                 2- All Q Capture customers.                  *
  *                 3- Q Capture                                 *
  *                 4- All Q Capture customers.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1- QCAP in proxy reports it has no      *
  *                      primary key or unique index with        *
  *                      ASN7023W.                               *
  *                      2- Q Capture initialization detects     *
  *                      that a subscribed source column does    *
  *                      not exist in a source table and stops.  *
  *                       A user updates the subscription        *
  *                      IBMQREP_SUBS row to set the             *
  *                      subscription STATE = 'I' and warm       *
  *                      starts Q Capture.  Q Capture displays   *
  *                      'ASN0060E' and abends with S0C4.        *
  *                      3- When obid is changed and psid is     *
  *                      null, updating psid returns SQLSTATE    *
  *                      02000 and QCapture stops.               *
  *                      4- Q Capture displays 'ASN0530E The     *
  *                      program could not connect to database   *
  *                      "DBB" with USERID "N/A" SQLCODE is "c   *
  *                      f30006".' and stops if the DB2          *
  *                      subsystem name is less than 4           *
  *                      characters.                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  1- If primary key is not defined and only unique index is
  created, ASN7023W is issued. If table also has LOB column,
  subscription will be deactivated.
  2- Q Capture initialization builds an ordered list of
  subscription state transition information in memory.  Q Capture
  saves the address of the first entry in the list. Q Capture
  processes the list after it loads subscriptions.  Q Capture
  removes the first entry from the list but does not update the
  first entry saved address.  Q Capture termination deletes
  entries starting with the first entry in the list and abends
  with S0C4 because the it has already deleted the first entry.
  3- When psid is null, QCapture will fetch it from db2 catalog
  and update it in IBMQREP_TABVERSION. Because subscribed table's
  obid is changed, it causes no record can be found in version
  table.
  4- Capture initialization fails because the Q Capture log
  reader subtask does not pad the DB2 subsystem name with
  terminating blanks before it attaches to the DB2 subsystem.
  

Problem conclusion

Temporary fix

Comments

• 1- Add three part name for proxy mode in fetching unique index
  sql clause.
  2- Q Capture has been changed to correctly maintain its list of
  subscription state transition information.
  3- Remove additional redundant obid and dbid in sql clause.
  4- The Q Capture log reader subtask has been changed to pad the
  DB2 subsystem name with terminating blanks if the DB2 subsystem
  name is less than four characters.
  Note: ASNCLP has been updated from db2_v105fp9 s170908.
  

APAR Information

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

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

  UI50437 UI50438 UI50439 UI50440

Modules/Macros

•    ASNACMD  ASNADMSP ASNAPPLY ASNCAP   ASNCCMD
  ASNCLPAP ASNCLPCL ASNCLPCM ASNCLPCO ASNCLPMS ASNCLPQA ASNMCMD
  ASNMON   ASNQACMD ASNQAPP  ASNQCAP  ASNQCCMD ASNQDEP  ASNQEXRP
  ASNQMFMT ASNQXFMT ASNQ1140 ASNRBASE ASNTDIFF ASNTDSP  ASNTRC
  ASN2BASE
  

Fix information

• Fixed component name

  WS REPLICATION

• Fixed component ID

  5655L8800

Applicable component levels

• RB33 PSY UI50437

     UP17/09/28 P F709

• RB34 PSY UI50438

     UP17/09/29 P F709

• RB35 PSY UI50439

     UP17/09/28 P F709

• RB36 PSY UI50440

     UP17/09/28 P F709

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.