Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SQLCODE904 MSGDSNT501I DSNOTCSO RESOURCE UNAVAILABLE RC00C900D2
  issued when doing LOB data conversion for an INSERT stmt
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 9 for z/OS users of LOBs.            *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following two errors can occur when *
  *                      performing an INSERT into a LOB column  *
  *                      that involves a CCSID conversion.       *
  *                                                              *
  *                        1. An SQLCODE904 rc00C900D2 because   *
  *                           zparm LOBVALS was exceeded.        *
  *                                                              *
  *                        2. SQLCODE433 for a LOB Data          *
  *                           truncation error.                  *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DB2 can issue one of the following unexpected SQL errors when
  performing an INSERT into a LOB column which involves a CCSID
  conversion of the LOB.
  
    1. An SQLCODE904 with rc00C900D2 - zparm LOBVALS was exceeded.
    2. An SQLCODE433 - LOB Data truncation error.
  
  
  For the first error, it can occur when an arithmetic calculation
  overflows an internal variable for a large LOB, about 1G.  The
  size is mistakenly used as a large positive value for a storage
  request, and as a result, the storage request returns with an
  SQLCODE -904 indicating that the LOBVALS value was exceeded,
  when in fact, the request amount was invalid.
  
  For the second error, it can result when DB2 performs a CCSID
  conversion for a LOB (having a size in between 300K and 1M) and
  fails to consider the condition when the original data size was
  more than 300K but its estimated size for conversion is less
  than 1M.
  

Problem conclusion

• The code in DB2 is modified to correct the conditions leading to
  the two unexpected errors when performing an insert into a LOB
  column.
  
  Additional Keywords: SQLLOB SQLINSERT
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK51735

Modules/Macros

•    DSNOTCSO
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R910 PSY UK51735

     UP09/11/21 I 1000

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.

IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.

Product categories:

Software

Data Management

Data Servers (Database Management Systems)

DB2 for z/OS

Software version:

910

Reference #:

PK96655

IBM Group:

Software Group

Modified date:

2009-11-21