PM77453: CKP214I IN DURING TEST AND COMPARE, WHEN STATEMENTS FLAGGED AS EXPLAINABLE

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • CKP214I issued during TEST and COMPARE results from
    inappropriate parameter substitution in SQL statement
    preparation for SQL explain.
    
    Parameters substituted into statement are inappropriate when SQL
    host variables are the target of some scalar SQL functions, such
    as SUBSTRING, or when the host variable does not reside within
    the where clause.
    
    CKP214I CKP214 MSGCKP214I MSGCKP214
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 Path Checker.                   *
    ****************************************************************
    * PROBLEM DESCRIPTION: CKP214I issued during TEST and COMPARE  *
    *                      results from inappropriate parameter    *
    *                      substitution in SQL statement           *
    *                      preparation for SQL explain.            *
    *                      Parameters substituted into statement   *
    *                      are inappropriate when SQL host         *
    *                      variables are the target of some        *
    *                      scalar SQL functions, such as           *
    *                      SUBSTRING, or when the host variable    *
    *                      does not reside within the where        *
    *                      clause.                                 *
    *                      CKP214I CKP214 MSGCKP214I MSGCKP214     *
    ****************************************************************
    * RECOMMENDATION: APPLY the PTF.                               *
    ****************************************************************
    Code has been changed to correct this condition.
    

Problem conclusion

  • APPLY the PTF.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM77453

  • Reported component name

    DB2 PATH CHECKE

  • Reported component ID

    5655E3901

  • Reported release

    410

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-11-20

  • Closed date

    2013-03-18

  • Last modified date

    2013-04-02

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

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

    UK92621

Modules/Macros

  •    CKPPTHCK
    

Fix information

  • Fixed component name

    DB2 PATH CHECKE

  • Fixed component ID

    5655E3901

Applicable component levels

  • R410 PSY UK92621

       UP13/03/21 P F303

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 Tools for z/OS
DB2 Path Checker

Software version:

4.1.0

Reference #:

PM77453

Modified date:

2013-04-02

Translate my page

Machine Translation

Content navigation