IBM Support

PM41069: DATASOURCE CUSTOM PROPERTY FULLYMATERIALIZELOBDATA DESCRIPTION NEEDS ENHANCEMENT

Fixes are available

7.0.0.21: WebSphere Application Server V7.0 Fix Pack 21
8.0.0.2: WebSphere Application Server V8.0 Fix Pack 2
8.0.0.3: WebSphere Application Server V8.0 Fix Pack 3
7.0.0.23: WebSphere Application Server V7.0 Fix Pack 23
8.0.0.4: WebSphere Application Server V8.0 Fix Pack 4
7.0.0.25: WebSphere Application Server V7.0 Fix Pack 25
8.0.0.5: WebSphere Application Server V8.0 Fix Pack 5
7.0.0.27: WebSphere Application Server V7.0 Fix Pack 27
8.0.0.6: WebSphere Application Server V8.0 Fix Pack 6
7.0.0.29: WebSphere Application Server V7.0 Fix Pack 29
8.0.0.7: WebSphere Application Server V8.0 Fix Pack 7
8.0.0.8: WebSphere Application Server V8.0 Fix Pack 8
7.0.0.31: WebSphere Application Server V7.0 Fix Pack 31
7.0.0.27: Java SDK 1.6 SR13 FP2 Cumulative Fix for WebSphere Application Server
7.0.0.33: WebSphere Application Server V7.0 Fix Pack 33
8.0.0.9: WebSphere Application Server V8.0 Fix Pack 9
7.0.0.35: WebSphere Application Server V7.0 Fix Pack 35
8.0.0.10: WebSphere Application Server V8.0 Fix Pack 10
7.0.0.37: WebSphere Application Server V7.0 Fix Pack 37
8.0.0.11: WebSphere Application Server V8.0 Fix Pack 11
7.0.0.39: WebSphere Application Server V7.0 Fix Pack 39
8.0.0.12: WebSphere Application Server V8.0 Fix Pack 12
7.0.0.41: WebSphere Application Server V7.0 Fix Pack 41
8.0.0.13: WebSphere Application Server V8.0 Fix Pack 13
7.0.0.43: WebSphere Application Server V7.0 Fix Pack 43
8.0.0.14: WebSphere Application Server V8.0 Fix Pack 14
7.0.0.45: WebSphere Application Server V7.0 Fix Pack 45
8.0.0.15: WebSphere Application Server V8.0 Fix Pack 15
7.0.0.21: Java SDK 1.6 SR9 FP2 Cumulative Fix for WebSphere
7.0.0.23: Java SDK 1.6 SR10 FP1 Cumulative Fix for WebSphere
7.0.0.25: Java SDK 1.6 SR11 Cumulative Fix for WebSphere Application Server
7.0.0.27: Java SDK 1.6 SR12 Cumulative Fix for WebSphere Application Server
7.0.0.29: Java SDK 1.6 SR13 FP2 Cumulative Fix for WebSphere Application Server
7.0.0.45: Java SDK 1.6 SR16 FP60 Cumulative Fix for WebSphere Application Server
7.0.0.31: Java SDK 1.6 SR15 Cumulative Fix for WebSphere Application Server
7.0.0.35: Java SDK 1.6 SR16 FP1 Cumulative Fix for WebSphere Application Server
7.0.0.37: Java SDK 1.6 SR16 FP3 Cumulative Fix for WebSphere Application Server
7.0.0.39: Java SDK 1.6 SR16 FP7 Cumulative Fix for WebSphere Application Server
7.0.0.41: Java SDK 1.6 SR16 FP20 Cumulative Fix for WebSphere Application Server
7.0.0.43: Java SDK 1.6 SR16 FP41 Cumulative Fix for WebSphere Application Server
Obtain the fix for this APAR.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The Admin Console description for DB2 JDBC Custom Property:
    fullyMaterializeLobData is incorrect. Currently in Admin Console
    it says:
    ---
    Data sources > data_source_name > Custom properties >
    fullyMaterializeLobData
    
      "This setting controls whether or not LOB locators are used to
       fetch LOB data. If enabled, LOB data is not streamed, but is
       fully materialized with locators when the user requests a
       stream on the LOB column. The default value is true."
    ---
    
    The sentence "... materialized with locators when the user
    requests a stream on the LOB column" seems to be incorrect, as
    per the DB2 InfoCenter.
    
    The DB2 InfoCenter says:
    
     "If this setting is disabled [fullyMaterializeLobData], LOB
      data is retrieved 1 with locators when you request a stream on
      the LOB column. "
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:  All users of IBM WebSphere Application      *
    *                  Server V7.0 and V8.0.                       *
    ****************************************************************
    * PROBLEM DESCRIPTION: The description for datasource custom   *
    *                      property fullyMaterializeLobDate is     *
    *                      not clear.                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    The documentation for the DB2 datasource custom property
    fullyMaterializeLobData on the adminconsole was not clear
    and hence we are using this apar to update the
    descripton as below :
    "The fullyMaterializeLobData custom property determines
    whether LOB data is fully materialized in the JDBC driver
    when a row is fetched, or is retrieved in pieces as needed.
    The actual behavior depends on whether the database server
    supports progressive streaming. Refer to your DB2
    documentation for more information about this property. The
    default value is true."
    

Problem conclusion

  • The custom property template has been updated.
    
    APAR PM41069 requires changes to documentation.
    
    NOTE: Periodically, we refresh the documentation on our
    Web site, so the changes might have been made before you
    read this text. To access the latest on-line
    documentation, go to the product library page at:
    
    http://www.ibm.com/software/webservers/appserv/library
    
    The following changes to the WebSphere Application Server
    Version 7.0 Information Center will be made available in
    January, 2012.
    
    The topic "Messaging engine troubleshooting tips" includes
    a section titled "Messaging engine does not start up with
    a DB2 Universal JDBC type 2 driver". Step 2 of this section
    will be updated to include the following information:
    
    The fullyMaterializeLobData custom property determines
    whether LOB data is fully materialized in the JDBC driver
    when a row is fetched, or is retrieved in pieces as needed.
    The actual behavior depends on whether the database server
    supports progressive streaming. Refer to your DB2
    documentation for more information about this property. The
    default value is true.
    
    APAR PM41069 is currently targeted for inclusion in
    Service Level 7.0.0.21 and 8.0.0.2 of WebSphere
    Application Server.
    
    Please refer to URL:
    //www.ibm.com/support/docview.wss?rs=404&uid=swg27006970
    for Fix Pack availability.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM41069

  • Reported component name

    WEBSPHERE FOR Z

  • Reported component ID

    5655I3500

  • Reported release

    700

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-06-08

  • Closed date

    2011-10-18

  • Last modified date

    2012-02-03

  • 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

    WEBSPHERE FOR Z

  • Fixed component ID

    5655I3500

Applicable component levels

  • R700 PSY UK74996

       UP12/01/18 P 1201

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.



Document information

More support for: WebSphere Application Server for z/OS
General

Software version: 7.0

Reference #: PM41069

Modified date: 03 February 2012