DB2 - Problem description
Problem IC76252 | Status: Closed |
A LOAD FROM "/DEV/NULL/" WITH A TRAILING "/", INCORRECT DEVICE NAME, CAUSES DB2 TO CRASH ON AIX SYSTEM. | |
product: | |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 | |
Problem description: | |
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 Summary: | |
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. | |
available fix packs: | |
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows | |
Solution | |
apar ic76252 module engn_squ fixed >= v91 fpk10 | |
Workaround | |
do not put the erroneaus trailing "/" for /dev/null device. | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC76253 IC76254 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 09.05.2011 08.12.2011 08.12.2011 |
Problem solved at the following versions (IBM BugInfos) | |
9.1.FPk10 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.1.0.11 |