DB2 FOR LUW / DB2FORLUW / 970 - DB2

PL/SQL procedure gets SQL0171N error when attempts to trim a 
large object by TRIM_CLOB or TRIM_BLOB to 0 length. 
 
Sample procedure 
 
CREATE OR REPLACE PROCEDURE TEST AS 
DECLARE 
    req CLOB := EMPTY_CLOB' ; 
    str VARCHAR (300); 
BEGIN 
    DBMS_LOB.open_clob (req, 1); 
    str := 'aaa,'; 
    DBMS_LOB.writeappend_clob (req, LENGTH(str), str); 
 
    DBMS_LOB.trim_clob (req, 1); 
    DBMS_OUTPUT.put_line ('req: ' || VARCHAR(req)); 
 
    DBMS_LOB.trim_clob (req, 0); 
    DBMS_OUTPUT.put_line ('req: ' || VARCHAR(req)); 
 
    DBMS_LOB.close_clob (req); 
END; 
 
The second trim results in SQL0171N.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* PL/SQL procedure gets SQL0171N error when attempts to trim a * 
* large object to 0 length by TRIM_CLOB or TRIM_BLOB routine.  * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to version 9.7 FixPack4                              * 
****************************************************************

DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

This was first fixed by V97 FP4

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC72905 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

23.11.2010
09.05.2011
09.05.2011

9.7.,
9.7.FP4