Fixes are available
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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
01 November 2021