|
Problem IC76254
|
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 / 970 - 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.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
|
| Solution |
apar ic76254
module engn_squ
fixed >= v97 fpk6 |
| Workaround |
do not put the erroneaus trailing "/" for /dev/null device. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 09.05.2011
08.12.2011
25.01.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FPk6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
