IBM Support

PM51060: SQLCODE199 -199 ERROR ILLEGAL USE OF KEYWORD AS TOKEN INCLUDE PARTITIONED PARTITION CLUSTER

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The SQL error with code=-199 is being caused by trying to create
    a DB2 index with multiple key targets, one of which contains XML
    pattern (the DERIVED_FROM column is not empty). This error may
    occur starting with DB2 Version 9 new-function mode, because XML
    columns are not supported prior to DB2 Version 9.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 Cloning Tool.                   *
    ****************************************************************
    * PROBLEM DESCRIPTION: The SQL error with code=-199 is being   *
    *                      caused by trying to create a DB2 index  *
    *                      with multiple key targets, one of which *
    *                      contains XML pattern (the DERIVED_FROM  *
    *                      column is not empty). This error may    *
    *                      occur starting with DB2 Version 9       *
    *                      new-function mode, because XML columns  *
    *                      are not supported prior to DB2          *
    *                      Version 9.                              *
    ****************************************************************
    * RECOMMENDATION: APPLY the PTF.                               *
    ****************************************************************
    Code has been changed to correct this condition.
    

Problem conclusion

  • APPLY the PTF.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM51060

  • Reported component name

    DB2 CLONING TOO

  • Reported component ID

    5655N1000

  • Reported release

    310

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2011-10-27

  • Closed date

    2011-12-28

  • Last modified date

    2016-09-16

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

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

Modules/Macros

  •    CKZ00500
    

Fix information

  • Fixed component name

    DB2 CLONING TOO

  • Fixed component ID

    5655N1000

Applicable component levels

  • R310 PSY UK75127

       UP12/01/04 P F201

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.



Document information

More support for: DB2 Tools for z/OS
DB2 Cloning Tool

Software version: 3.1.0

Reference #: PM51060

Modified date: 16 September 2016