DB2 FOR LUW / DB2FORLUW / 980 - DB2

Deferred ASLHEAPSZ value is used by processes spawned outside of 
the db2sysc process instead of using the current value that the 
db2sysc process contains.  This leads to threads within the 
db2sysc process using a different value than those outside, 
hence leading to possible errors in the communication streams. 
 
For example, giving the statement: 
 
 
CALL ADMIN_CMD( ( SELECT 'IMPORT FROM /dev/null of DEL REPLACE 
INTO "SERVTYPE"' FROM SYSIBM.SYSDUMMY1 ) ) 
 
 
Attempt to execute one gives the error code: 
 
SQL30020N Execution of the command or SQL statement failed 
because of a 
syntax error in the communication data stream that will affect 
the successful 
execution of subsequent commands and SQL statements: Reason Code 
"0x124C"("0103")"". 
 
There, the ASLHEAPSZ in effect, is not truly being deferred 
until after the instance is restarted, which leads to these 
undesired effects.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users running DB2 v9.8 are affected.                     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Deferred ASLHEAPSZ value is used by processes spawnedoutside * 
* ofthe db2sysc process instead of using the current value     * 
* thatthedb2sysc process contains.  This leads to threads      * 
* within thedb2sysc process using a different value than those * 
* outside,hence leading to possible errors in the              * 
* communicationstreams.For example, giving the statement:CALL  * 
* ADMIN_CMD( ( SELECT 'IMPORT FROM /dev/null of DELREPLACEINTO * 
* "SERVTYPE"' FROM SYSIBM.SYSDUMMY1 ) )Attempt to execute one  * 
* gives the error code:SQL30020N Execution of the command or   * 
* SQL statement failedbecause of asyntax error in the          * 
* communication data stream that willaffectthe                 * 
* successfulexecution of subsequent commands and SQL           * 
* statements: ReasonCode"0x124C"("0103")"".There, the          * 
* ASLHEAPSZ in effect, is not truly being deferreduntil after  * 
* the instance is restarted, which leads to theseundesired     * 
* effects.                                                     * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v9.8 FP4.                                     * 
****************************************************************

Restart the instance. If the ASLHEAPSZ needs to be modified, it 
is safest to stop the instance, update the configuration 
parameter, then start the instance again.

DB2 Version 9.8 Fix Pack 4 for AIX and Linux
 DB2 Version 9.8 Fix Pack 5 for AIX and Linux
 

The problem has been fixed in DB2 v9.8 FP4.

not known / see Local fix

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

15.07.2011
12.09.2011
12.09.2011

9.8.FP4