IBM Support

IC85570: SELECT STATEMENT WITH TO_DATE MAY TRAP IN FEDERATED ENVIRONMENT.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • select statement with to_date may trap in federated environment.
    
    A column which is specified date or timestamp.
    
    For example)
    date case
    db2 "describe table ndate"
    
                                    Data type
    Column
    Column name                     schema    Data type name
    Length     Scale Nulls
    ------------------------------- --------- -------------------
    ---------- ----- ------
    D1                              SYSIBM    DATE
    4     0 Yes
    
    timestamp case
    => db2 "describe table nts"
                                    Data type
    Column
    Column name                     schema    Data type name
    Length     Scale Nulls
    ------------------------------- --------- -------------------
    ---------- ----- ------
    D2                              SYSIBM    TIMESTAMP
    10     6 Yes
    
    Both of the following SQL may trap.
    select * from ndate
      where to_date(d1,'yyyy-mm-dd') ='2011-11-11'
    select * from nts
      where to_date(d2,'yyyy-mm-dd') ='2011-11-11'
    
    Here is a snippet of stack trace.
    
    <sqlnq_qclqncparent::op>
    <sqlnt_translate::sqlnt_add_function>
    <sqlnt_translate::sqlnt_add_expression>
    <sqlnt_translate::sqlnt_add_function>
    <sqlnt_translate::sqlnt_add_expression>
    <sqlnt_translate::sqlnt_add_predicates>
    <sqlnt_translate::sqlnt_translate_scan>
    <sqlnt_translate::dispatch_pop>
    <sqlnt_translate::sqlnt_translate_sort>
    <sqlnt_translate::dispatch_pop>
    <sqlnt_translate::sqlnt_translate_scan>
    <sqlnt_translate::dispatch_pop>
    <sqlnt_translate::sqlnt_translate_mate>
    <sqlnt_translate::dispatch_pop>
    <sqlnt_translate::sqlnt_translate_pipe>
    <sqlnt_translate::dispatch_pop>
    <sqlnt_translate::sqlnt_translate_ship>
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade DB2 UDB version 9.7 fixpack 7.                       *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 UDB V9.7 Fix Pack 7.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC85570

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-07-27

  • Closed date

    2012-10-30

  • Last modified date

    2012-10-30

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

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

    IC88649

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC85570

Modified date: 30 October 2012