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

A fix is available

Subscribe

You can track all active APARs for this component.

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 number

    PM66233

  • Reported component name

    QMF-QUERY MGMT

  • Reported component ID

    566872101

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-06-05

  • Closed date

    2012-06-26

  • Last modified date

    2012-07-02

  • 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.



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 Query Management Facility
QMF for TSO/CICS

Software version:

9.1

Reference #:

PM66233

Modified date:

2012-07-02

Translate my page

Machine Translation

Content navigation