IBM Support

JR32201: ADD TERADATA V12 TOLERANCE SUPPORT IN TERADATA WRAPPER IN DB2 V9 5 FIXPACK4

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • You can not create a federated Server object using version
    number '12'  for remote V12 Teradata data source.
    
    The server creating statement will fail with information like
    following
    CREATE SERVER "TERASERV"  TYPE TERADATA VERSION 12 WRAPPER
    "TERADATA"  OPTIONS (NODE 'TeradataNode', PASSWORD 'Y')
    DB21034E  The command was processed as an SQL statement because
    it was not a
    valid Command Line Processor command.  During SQL processing it
    returned:
    SQL1816N  Wrapper "TERADATA" cannot be used to access the
    "VERSION" of data
    source ("TERADATA" "12") that you are trying to define to
    the federated
    database.  SQLSTATE=560AC
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * No specific.                                                 *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * In Federation Server earlier than V95fp4 do not support      *
    * TERADATA server version 12.                                  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 'Federation Server' V95fp4                        *
    ****************************************************************
    

Problem conclusion

  • Fixed in release V95fp4_090105.
    With this fix, customer can create teradata server with version
    number 12.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR32201

  • Reported component name

    TERADATA WRAPPE

  • Reported component ID

    5724N9709

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-02-27

  • Closed date

    2009-06-15

  • Last modified date

    2009-06-15

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

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

Fix information

  • Fixed component name

    TERADATA WRAPPE

  • Fixed component ID

    5724N9709

Applicable component levels

  • R950 PSN

       UP

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCAVPS","label":"Data Sources and Wrappers - Teradata"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.5","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
15 June 2009