PM66233: QUERYING A SAP UNICODE TABLE WITH DBCLOB DATA TYPE USING DB2 QMF V9.1 FOR TSO GETS SQLCODE189

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When QMF for TSO/CICS is installed in a DB2 for z/OS local
  requester that is defined with a SBCS CCSID and a query is
  run that contains a DBCLOB data type that was defined in a
  table in a UNICODE table space, the user will receive an
  SQL code -189.
  

Local fix

• If the DBCLOB data types are removed from the query, the query
  will run as expected.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS V10.1 and V9.1 users    *
  *                 accesssing DBCLOB and CLOB columns.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: Users running in DB2 for z/OS requester *
  *                      that is a SBCS non-mixed codepage who   *
  *                      access DBCLOB columns from tables in    *
  *                      unicode table spaces will receive SQL   *
  *                      code -189 (SQLCODE189) indicating       *
  *                      'CCSID 65534 IS INVALID'. This can      *
  *                      happen when running the RUN QUERY,      *
  *                      EXPORT TABLE, PRINT TABLE or            *
  *                      DISPLAY TABLE commands. Users can       *
  *                      also see garbage data or zeros          *
  *                      when displaying LOB columns when        *
  *                      when the column data is shorter         *
  *                      than the report column length.          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  QMF was not specifying a CCSID to use during conversion when
  casting DBCLOB to CLOB data types. This casting is done only if
  QMF detects it is running in a SBCS non-mixed DB2 for z/OS
  requester and it is accessing unicode encoded data.
  

Problem conclusion

• QMF code has been fixed to specify a CCSID for casting DBCLOB to
  CLOB data.  LOB data lengths have been properly set to avoid
  extraneous garbage data.
  

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:

  UK79827 UK79828

Modules/Macros

• DSQFDATA DSQFFSQX DSQFFSQ7 DSQFFSQ8 DSQFPSQX
  DSQFPSQ7 DSQFPSQ8 DSQFRDAT DSQGFSQM DSQGFSQS DSQGFSQX DSQGFSUM
  DSQGFSUS DSQGFSUX DSQGPSQM DSQGPSQS DSQGPSQX DSQIFSQM DSQIFSQS
  DSQIFSQX DSQIFSQ7 DSQIFSQ8 DSQIFSUM DSQIFSUS DSQIFSUX DSQIPSQM
  DSQIPSQS DSQIPSQX DSQIPSQ7 DSQIPSQ8
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• RA10 PSY UK79827

     UP12/06/28 P F206

• R910 PSY UK79828

     UP12/06/28 P F206

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.