home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
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

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 FixList