IBM Support

PH15038: PROVIDE "MEDIUM VARCHAR(32672) FOR BIT DATA" OPTION

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Customers need the option to have  "MEDIUM VARCHAR(32672) FOR
    BIT DATA" option in the DDL for DB2.
    

Local fix

  • CREATE TABLE <SchemaName>.sessions (
     ID VARCHAR(128) NOT NULL ,
     PROPID VARCHAR(128) NOT NULL ,
     APPNAME VARCHAR(128) NOT NULL,
     LISTENERCNT SMALLINT ,
     LASTACCESS BIGINT,
     CREATIONTIME BIGINT,
     MAXINACTIVETIME INTEGER ,
     USERNAME VARCHAR(256) ,
     SMALL VARCHAR(3122) FOR BIT DATA ,
     MEDIUM VARCHAR(32700) FOR BIT DATA ,
     LARGE BLOB(2M)
     )
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:  All users of IBM WebSphere Application      *
    *                  Server using DB2 for session database       *
    ****************************************************************
    * PROBLEM DESCRIPTION: DB2 LONG VARCHAR data types may have    *
    *                      been deprecated in some versions        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    When using DB2 for session database, create table may give
    an error SQL1666N Unsupported functionality: "LONG_VARCHAR"
    

Problem conclusion

  • The WebSphere Application Server session manager will add a
    new custom property, UseDB2VARCHAR (default=false). Set this
    property to true to enable the Session Manager creates the
    session database table using the VARCHAR data type instead of
    LONG_VARCHAR for the medium column.
    
    The fix for this APAR is currently targeted for inclusion in
    fix pack 9.0.5.2.  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

    PH15038

  • Reported component name

    WEBS APP SERV N

  • Reported component ID

    5724H8800

  • Reported release

    850

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-07-29

  • Closed date

    2019-09-09

  • Last modified date

    2019-09-09

  • 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

  • R900 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"850","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
17 October 2021