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 is sysrouted FROM one or more of the following: APAR is sysrouted TO one or more of the following: Modules/Macros
|
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
(C) Copyright IBM Corporation 2000, 2006. All Rights Reserved.