IBM Support

PI50137: THE WEBSPHERE SESSION MANAGEMENT DATABASE USES THE LONG VARCHAR ATTRIBUTE WHICH IS NOT SUPPORTED IN DB2

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The WebSphere session management database uses the LONG VARCHAR
    attribute which is not supported in DB2
    
    
    The replacement for LONG VARCHAR in the MEDIUM column is
    CLOB(32700). This will work by default 8k, 16k and 32k page
    sizes. If a  4k page size is desired, the SMALL column will
    need to be reduced in  size from VARCHAR(3122) to
    VARCHAR(3025).
    

Local fix

  • NA
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:  IBM WebSphere Application Server 8.5.5, 8.0 *
    *                  and 7.0 customers using DB2 versions 9.7    *
    *                  and                                         *
    *                  above for Database Session persistence.     *
    ****************************************************************
    * PROBLEM DESCRIPTION: The datatype LONG VARCHAR has been      *
    *                      deprecated in DB2 and is not            *
    *                      supported in versions 9.7 and above.    *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    The LONG VARCHAR datatype, used for session database
    persistence in DB2, has been deprecated for future versions of
    DB2, starting with version 9.7, and will be removed in future
    versions.
    

Problem conclusion

  • The custom property "UseDB2MediumClob" has been added to change
    the LONG VARCHAR type to a CLOB type, supported in current and
    future versions of DB2.
    
    The fix for this APAR is currently targeted for inclusion in fix
    pack 8.5.5.10, 8.0.0.13 and 7.0.0.41.  Please refer to the
    Recommended Updates page for delivery information:
    http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI50137

  • Reported component name

    WEBS APP SERV N

  • Reported component ID

    5724H8800

  • Reported release

    700

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2015-10-07

  • Closed date

    2016-01-25

  • Last modified date

    2016-08-18

  • 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

    WEBS APP SERV N

  • Fixed component ID

    5724H8800

Applicable component levels

  • R700 PSY

       UP

  • R800 PSY

       UP

  • R850 PSY

       UP



Document information

More support for: WebSphere Application Server
General

Software version: 7.0

Reference #: PI50137

Modified date: 18 August 2016