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 IC74719 Status: Geschlossen

ALTOBJ DOES NOT DELETE THE MESSAGE FILE AFTER IT RUNS SUCCESSFUL LY AND ONE
CANNOT PICK WHERE THE MESSAGES FILE SHOULD GO.

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
When ALTOBJ is called to alter columns for a give table, 
it calls db2load stored procedure under the cover to load 
the data into the table.  The message file by default goes 
under sqllib/tmp directory which is not visible to the 
user. 
. 
This apar is to do two things: 
. 
1)  Option under DB2_UTIL_MSGPATH registry to pick the location 
of the message file. 
. 
2)  Remove the message file after a successful completion 
of ALTOBJ. 
.
Problem-Zusammenfassung:
When ALTOBJ is called to alter columns for a give table, 
it calls db2load stored procedure under the cover to load 
the data into the table.  The message file by default goes 
under sqllib/tmp directory which is not visible to the 
user. 
. 
This apar is to do two things: 
. 
1)  Option under DB2_UTIL_MSGPATH registry to pick the location 
of the message file. 
. 
2)  Remove the message file after a successful completion 
of ALTOBJ.
Local-Fix:
create symbolic link from sqllib/tmp to somehwere where you 
want the messages file to go.
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
fixed >= v97 fpk4
Workaround
create symbolic link from sqllib/tmp to somehwere where you 
want the messages file to go.
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
25.02.2011
07.07.2011
07.07.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FPk4
Problem behoben lt. FixList in der Version
9.7.0.5 FixList