PQ59125: DOC. SHOULD MAKE MENTION OF THE NEED TO CONSIDER DB2 ZPARM VALUEVALUES FOR LOBVALA & LOBVALS

APAR status
Closed as documentation error.

Error description
On a failed appl. deployment, this error is found in BBOSMSS:
-904, ERROR:  UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE
TYPE OF RESOURCE 00000907, AND RESOURCE NAME DSNT418I
SQLSTATE = 57011 SQLSTATE RETURN CODE DSNT415I .....
After research into DB2, this translates to your LOBVALA and/or
LOBVALS parameter values (used in DB2 ZPARM) need to be larger.
The LOBVALA zparm establishes an upper limit for the amount of
storage each user can have for storing LOB values. The LOBVALS
establishes an upper limit for the amount of storage per system
that can be used for storing LOB values. This information is
set on DB2 installation panel DSNTIP7, used by ZPARM, which is
usually DSNTIJUZ.
The publications "Installation and Customization" & "Assembling
J2EE Applications" should include information regarding the need
to review the need for additional resources to support DB2 LOBs
when WAS is installed.  This also should be considered when
preparing to deploy another application onto a WAS/390 system.
Local fix
Increase the values for LOBVALA & LOBVALS, rebind the ZPARM
program and recycle DB2 to pick up the larger LOB* values. Then
try your applicaiton deployment again.
Problem summary
****************************************************************
* USERS AFFECTED: All users of WebSphere Application Server    *
*                 V4.0.1 for z/OS and OS/390                   *
****************************************************************
* PROBLEM DESCRIPTION: Document the need to review additional  *
*                      resources to support DB2 large objects  *
*                      (LOBs) when you install WebSphere for   *
*                      z/OS and when you deploy an application *
*                      on WebSphere for z/OS.                  *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
Customers should review additional resources to support DB2
large objects (LOBs) when they install WebSphere for z/OS
and when they deploy an application on WebSphere for z/OS.

The following is an indication that customers
may not have sufficient storage for large objects:

   -904, ERROR:  UNSUCCESSFUL EXECUTION CAUSED
   BY AN UNAVAILABLE TYPE OF RESOURCE 00000907,
   AND RESOURCE NAME DSNT418I SQLSTATE = 57011
   SQLSTATE RETURN CODE DSNT415I ...

Guideline information must be added to WebSphere for z/OS
Installation and Customization and WebSphere for z/OS
Assembling Java(TM) Platform, Enterprise Edition (J2EE(TM))
Applications.
Problem conclusion
A change is required 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 online
documentation, go to the product library page at:

www.ibm.com/software/webservers/appserv/zos_os390/

Document Name: WebSphere Application Server V4.0.1 for
               z/OS and OS/390:
               Installation and Customization
Document Number: GA22-7834-04

On page 51, add the following DB2 guideline:

o   Review the need for additional resources to support
    DB2 large objects (LOBs) when you install WebSphere
    for z/OS and when you deploy an application on
    WebSphere for z/OS. The following is an indication
    that you may not have sufficient storage for large
    objects:

      -904, ERROR:  UNSUCCESSFUL EXECUTION CAUSED
      BY AN UNAVAILABLE TYPE OF RESOURCE 00000907,
      AND RESOURCE NAME DSNT418I SQLSTATE = 57011
      SQLSTATE RETURN CODE DSNT415I ...

    Adjust the amount of storage needed for large objects
    through the USER LOB VALUE STORAGE (LOBVALA) and
    SYSTEM LOB VALUE STORAGE (LOBVALS) fields on the
    DSNTIP7 DB2 installation panel. For more information,
    see DB2 Universal Database for OS/390 and z/OS
    Installation Guide, GC26-9936.

Document Name: WebSphere Application Server V4.0.1 for
               z/OS and OS/390:
               Assembling Java(TM) Platform,
               Enterprise Edition (J2EE(TM))
               Applications
Document Number: SA22-7836-03

On page 120, in the topic "Developing Enterprise beans,"
add the following to the guidelines:

Review the need for additional resources to support DB2
large objects (LOBs) when you deploy an application on
WebSphere for z/OS. The following is an indication that
you may not have sufficient storage for large objects:

  -904, ERROR:  UNSUCCESSFUL EXECUTION CAUSED
  BY AN UNAVAILABLE TYPE OF RESOURCE 00000907,
  AND RESOURCE NAME DSNT418I SQLSTATE = 57011
  SQLSTATE RETURN CODE DSNT415I ...

Adjust the amount of storage needed for large objects
through the USER LOB VALUE STORAGE (LOBVALA) and SYSTEM
LOB VALUE STORAGE (LOBVALS) fields on the DSNTIP7 DB2
installation panel. For more information, see DB2
Universal Database for OS/390 and z/OS Installation
Guide, GC26-9936.
Temporary fix Comments
APAR information
APAR number PQ59125
Reported component name WASKBASE
Reported component ID 5655A9801
Reported release 400
Status CLOSED DOC
PE NoPE
HIPER NoHIPER
Submitted date 2002-03-15
Closed date 2002-05-07
Last modified date 2002-05-15

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:

Modules/Macros

Fix information

Applicable component levels


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server for z/OS
Operating system(s):
Software version: 400
Software edition:
Reference #: PQ59125
IBM Group: Software Group
Modified date: May 15, 2002