PH47267: Q Apply ADD COL ddl syntax should use CCSID clause mutually exclusive with FOR BIT/SBCS/MIXED DATA clause

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Q Apply ALTER TABLE ADD COLUMN replication for character column
  with CCSID may use both the CCSID clause and FOR MIXED DATA
  clause resulting in SQLCODE -199 failure.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: 1- All users if they are using latest Db2    *
  *                 z/os V12 or V13 and want to create new       *
  *                 control tables when setting up new           *
  *                 replication environment.                     *
  *                 2- Q Apply                                   *
  *                 3- All users if they want to use jdbc type4  *
  *                 connection for Q Apply server on Db2 z/os    *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1- Originally asnclp create control     *
  *                      tables in one tablespace on Db2 z/os,   *
  *                      this behavior is not allowed in latest  *
  *                      Db2 z/os V12 or V13 anymore, so the     *
  *                      error would be exposed.                 *
  *                      2- Q Apply ALTER TABLE ADD COLUMN       *
  *                      replication for character column with   *
  *                      CCSID may use both the CCSID clause     *
  *                      and FOR MIXED DATA clause resulting in  *
  *                      SQLCODE -199 failure.                   *
  *                      3- Originally asnclp couldn't connect   *
  *                      to  Q Apply server if using jdbc type4  *
  *                      connection for Db2 z/os                 *
  ****************************************************************
  1- asnclp should create control tables in their own tablespace
  in latest Db2 z/os V12 or V13.
  2- Q Apply ALTER TABLE ADD COLUMN ddl syntax should use CCSID
  clause mutually exclusive from the FOR BIT/SBCS/MIXED DATA
  clause to avoid SQCODE -199 failure.
  3- asnclp should connect to Q Apply server successfully using
  jdbc type4 connection for Db2 z/os
  

Problem conclusion

• 1- With the fix, asnclp can create control tables successfully
  2- Q Apply is fixed to use correct ALTER TABLE ADD COLUMN ddl
  for column with CCSID.
  3- With the fix, asnclp can connect to Q Apply server
  successfully using jdbc type4 connection for Db2 z/os
  Note: ASNCLP has been updated from v1157 s2207111521.
  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:

  UI81489 UI81491 UI81492 UI81493

Modules/Macros

• ASN2BASE ASN2DB2C ASN2DB2Q ASN2DBCN ASN2SQLZ ASN2ZOSC ASNAAPP
  ASNACMD  ASNACMP  ASNADMSP ASNAFET  ASNAISO  ASNAMAN  ASNAPP
  ASNAPPLY ASNAPRS  ASNAWPN  ASNBNDDR ASNBNDSR ASNBPXB  ASNCAP
  ASNCATM  ASNCCDA  ASNCCDD  ASNCCMD  ASNCCPWK ASNCDA   ASNCDD
  ASNCDINS ASNCLP   ASNCLPAP ASNCLPB  ASNCLPCL ASNCLPCM ASNCLPCO
  ASNCLPCT ASNCLPEV ASNCLPMS ASNCLPQA ASNCLPRM ASNCMPLD ASNCSCZ
  ASNCTLZD ASNDADK  ASNDB2CN ASNDB2SQ ASNDBCON ASNDEDE  ASNDONE
  ASNENUP  ASNENUS  ASNESES  ASNFIFI  ASNFRFR  ASNITIT  ASNJAJP
  ASNKOKR  ASNLOAD  ASNMCMD  ASNMDATA ASNMON   ASNMONIT ASNMPROC
  ASNMUPDT ASNNONO  ASNPLPL  ASNPRUNE ASNPTBR  ASNQ1021 ASNQ1140
  ASNQACMD ASNQAHKT ASNQAPAG ASNQAPP  ASNQAROW ASNQASUB ASNQBNDE
  ASNQBNDL ASNQBNDR ASNQBNDT ASNQBRWZ ASNQCAP  ASNQCCDA ASNQCCDD
  ASNQCCMD ASNQCTLZ ASNQDEFQ ASNQDEP  ASNQEXRP ASNQFALL ASNQJ001
  ASNQJ002 ASNQLODZ ASNQMFMT ASNQMSTP ASNQNMIH ASNQP2PA ASNQP2PI
  ASNQPROF ASNQSPC  ASNQSPIL ASNQSPS  ASNQSQLZ ASNQXFMT ASNRBASE
  ASNRURU  ASNS1021 ASNSFALL ASNSQLCZ ASNSVSE  ASNTDIFF ASNTDSP
  ASNTDSQL ASNTRC   ASNUOW   ASNV1021 ASNV1140 ASNVCD   ASNVMON
  ASNVREOR ASNVSQL  ASNZHCN  ASNZHTW  ASNZOSCN
  

Fix information

• Fixed component name

  WS REPLICATION

• Fixed component ID

  5655L8800

Applicable component levels

• RB33 PSY UI81489

     UP22/07/16 P F207

• RB34 PSY UI81491

     UP22/07/19 P F207

• RB35 PSY UI81492

     UP22/07/19 P F207

• RB36 PSY UI81493

     UP22/07/19 P F207

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.