DB2 - Problembeschreibung
Problem IC76254 | Status: Geschlossen |
A LOAD FROM "/DEV/NULL/" WITH A TRAILING "/", INCORRECT DEVICE NAME, CAUSES DB2 TO CRASH ON AIX SYSTEM. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
Load from "/dev/null/" crashes the instance. If the trailing "/" is removed then it works just fine. The trailing "/" is incorrect and should not be put in the first place. . simple repro on AIX: . db2sampl db2 "load from /dev/null/ of del insert into department" . SQL2535W Warning! End of media on device "/dev/null/" has been reached. Please mount the next source media. Do you want to continue(c), terminate this device only(d), abort the utility(t) ? (c/d/t) When you enter "d" to abort the utilility you get SQL1224N and instance crashes.. . you get the db2bm, the agent, and fm processes all crash with memory corruption, sig 11 with following stack: . -------Frame------ ------Function + Offset------ 0x090000001E7665C0 sqloCrashOnCriticalMemoryValidationFailure + 0x1C 0x090000001E768FD4 sqloCrashOnCriticalMemoryValidationFailure@glue1F0 + 0x1C 0x090000001F0C167C sqlofmblkEx + 0xA0 0x090000001EE10928 sqleAgentUCCleanup__FP15sql_static_data + 0x80 0x0900000020314B34 sqluTermLoadEDU__FPP20sqle_agent_privatecb + 0x1B4 0x090000002061802C @72@sqlulBMTerm__FPP14SQLU_BUFMAN_CBibP20sqle_agent_privatecb T2 + 0x3A4 | |
Problem-Zusammenfassung: | |
Load from "/dev/null/" crashes the instance. If the trailing "/" is removed then it works just fine. The trailing "/" is incorrect and should not be put in the first place. . simple repro on AIX: . db2sampl db2 "load from /dev/null/ of del insert into department" . SQL2535W Warning! End of media on device "/dev/null/" has been reached. Please mount the next source media. Do you want to continue(c), terminate this device only(d), abort the utility(t) ? (c/d/t) When you enter "d" to abort the utilility you get SQL1224N and instance crashes.. . you get the db2bm, the agent, and fm processes all crash with memory corruption, sig 11 with following stack: . -------Frame------ ------Function + Offset------ 0x090000001E7665C0 sqloCrashOnCriticalMemoryValidationFailure + 0x1C 0x090000001E768FD4 sqloCrashOnCriticalMemoryValidationFailure@glue1F0 + 0x1C 0x090000001F0C167C sqlofmblkEx + 0xA0 0x090000001EE10928 sqleAgentUCCleanup__FP15sql_static_data + 0x80 0x0900000020314B34 sqluTermLoadEDU__FPP20sqle_agent_privatecb + 0x1B4 0x090000002061802C @72@sqlulBMTerm__FPP14SQLU_BUFMAN_CBibP20sqle_agent_privatecb T2 + 0x3A4 | |
Local-Fix: | |
do not put the erroneaus trailing "/" for /dev/null device. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows | |
Lösung | |
apar ic76254 module engn_squ fixed >= v97 fpk6 | |
Workaround | |
do not put the erroneaus trailing "/" for /dev/null device. | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 09.05.2011 08.12.2011 25.01.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FPk6 | |
Problem behoben lt. FixList in der Version | |
9.7.0.5 |