DB2 - Problembeschreibung
Problem IC68985 | Status: Geschlossen |
Deferred ASLHEAPSZ value is used by processes spawned outside of the db2sysc process. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
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. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All users running DB2 v9.5 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.5 FP7. * **************************************************************** | |
Local-Fix: | |
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. | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows | |
Lösung | |
The problem has been fixed in DB2 v9.5 FP7. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC69265 IC77555 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 03.06.2010 12.10.2010 12.10.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP7 | |
Problem behoben lt. FixList in der Version | |
9.1.0.7 | |
9.5.0.7 |