home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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
DB2 Version 9.1 Fix Pack 12  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 FixList