PH60301: QCapture error when using OVERRIDE_RESTARTQ=Y

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• OVERRIDE_RESTARTQ=Y may fail if ddl happened
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: 1- All user for Q capture with               *
  *                 OVERRIDE_RESTARTQ=Y                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1- OVERRIDE_RESTARTQ=Y may fail if ddl  *
  *                      happened                                *
  ****************************************************************
  1- Q capture reports errors or not working if
  OVERRIDE_RESTARTQ=Y and have ddl like drop column, create
  column, recreate source table/qsub, alter table set data type
  

Problem conclusion

• 1- Q capture should recapture logs with ddl changes when
  OVERRIDE_RESTARTQ=Y
  ASNCLP was not updated.
  Function Level: 1140.103
  

Temporary fix

Comments

APAR Information

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

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

  UI96312 UI96313 UI96314 UI96315

Modules/Macros

• ASN2BASE ASN2SQLZ ASNACMD  ASNADMSP ASNAPPLY ASNCAP   ASNCATM
  ASNCCMD  ASNCTLZD ASNMCMD  ASNMON   ASNQACMD ASNQAPP  ASNQCAP
  ASNQCCMD ASNQDEP  ASNQEXRP ASNQMFMT ASNQXFMT ASNRBASE ASNSQLCZ
  ASNTDIFF ASNTDSP  ASNTRC   ASNVSQL
  

Fix information

• Fixed component name

  WS REPLICATION

• Fixed component ID

  5655L8800

Applicable component levels

• RB33 PSY UI96312

     UP24/04/04 P F404

• RB34 PSY UI96313

     UP24/05/01 P F404

• RB35 PSY UI96314

     UP24/05/01 P F404

• RB36 PSY UI96315

     UP24/05/01 P F404

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.