IY41844: HIGH2KEY/LOW2KEY documentation clarification

 

APAR status

  • Closed as program error.

Error description

  • HIGH2KEY/LOW2KEY (in SYSSTAT.COLUMNS) each represent an ASCII
    versions of a column's second highest and second lowest values.
    For example an ASCII representation of an integer value may be
    anywhere from 1 to 11 characters, including a sign. The
    HIGH2KEY/LOW2KEY values are stored in such a way that they can
    be used on the SET clause of an UPDATE statement, and without
    manipulation on cost calculations. For character strings, this
    means single quotes are added to the beginning and end of
    the string and an extra quote is added for every quote already
    in the string. Only the first 33 characters of the column's
    value will be considered.

    If you are do manually populate HIGH2KEY/LOW2KEY (in
    SYSSTAT.COLUMNS) be certain to follow the behavior of the
    generated values:

    o The value of all HIGH2KEY, LOW2KEY must be valid value's
    for the datatype of the corresponding user column.

    o The length of HIGH2KEY, LOW2KEY value must be
    the smaller of the target column's datatype's maximum length or
    33, not including additional quotes which can bring the strings
    length up to 68.

    o HIGH2KEY must be > LOW2KEY whenever there are
    3 or more distinct values in the corresponding column. In the

Local fix

  • case of le s than 3 distinct values in the column, HIGH2KEY can
    be equal to LOW2KEY.

    Examples:

    Type User data Same data as it shows in catalogs
    ---- --------- ---------------------------------
    INTEGER -12 -12
    CHAR abc 'abc'
    CHAR ab'c 'ab''c'
    LOCAL FIX:
    N/A

Problem summary

  • HIGH2KEY/LOW2KEY documentation clarification

Problem conclusion

  • HIGH2KEY/LOW2KEY (in SYSSTAT.COLUMNS) each represent an ASCII
    versions of a column's second highest and second lowest values.
    For example an ASCII representation of an integer value may be
    anywhere from 1 to 11 characters, including a sign. The
    HIGH2KEY/LOW2KEY values are stored in such a way that they can
    be used on the SET clause of an UPDATE statement, and without
    manipulation on cost calculations. For character strings, this
    means single quotes are added to the beginning and end of
    the string and an extra quote is added for every quote already
    in the string. Only the first 33 characters of the column's
    value will be considered.

    If you are do manually populate HIGH2KEY/LOW2KEY (in
    SYSSTAT.COLUMNS) be certain to follow the behavior of the
    generated values:

    o The value of all HIGH2KEY, LOW2KEY must be valid value's
    for the datatype of the corresponding user column.

    o The length of HIGH2KEY, LOW2KEY value must be
    the smaller of the target column's datatype's maximum length or
    33, not including additional quotes which can bring the strings
    length up to 68.

    o HIGH2KEY must be > LOW2KEY whenever there are
    3 or more distinct values in the corresponding column. In the

    case of less than 3 distinct values in the column, HIGH2KEY can
    be equal to LOW2KEY.

    Examples:

    Type User data Same data as it shows in catalogs
    ---- --------- ---------------------------------
    INTEGER -12 -12
    CHAR abc 'abc'
    CHAR ab'c 'ab''c'

Temporary fix

Comments

APAR Information

  • APAR number

    IY41844

  • Reported component name

    DB2 UDB ESE AIX

  • Reported component ID

    5765F4100

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2003-03-12

  • Closed date

    2009-09-11

  • Last modified date

    2009-09-11

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

    IY41842

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

Fix information

  • Fixed component name

    DB2 UDB ESE AIX

  • Fixed component ID

    5765F4100

Applicable component levels

  • R820 PSY

       UP

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

810

Reference #:

IY41844

Modified date:

2009-09-11

Translate my page

Machine Translation

Content navigation