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

DB2 IMPORT FAILS WHEN EXTRA LINE FEED CHARACTER EXISTS IN THE COMMAND

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
When using the db2 import command, it will fail if an extra 
line feed character (0x0A) is added in the command. 
 
The following for example will fail: 
 
db2 "IMPORT FROM /home/db2inst1/importdata/test_import.dat OF 
DEL 
>   MODIFIED BY COLDEL| 
> METHOD P ( 1 , 2) 
> INSERT INTO TEST_IMPORT 
> (COL1,COL2)" 
 
 
In this case, the problem is caused by the line feed character 
after TEST_IMPORT. 
 
 
The operation will fail with the following error: 
 
SQL2018N  The utility encountered an error "" while attempting 
to verify the user's authorization ID or database 
authorizations. 
 
 
This can also be reproduced using the SYSPROC.ADMIN_CMD() 
command.   If the 'import' command is placed inside that 
routine, it will fail as long as there is a line feed character 
in 
the command.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7, Fixpak 6                         * 
****************************************************************
Local-Fix:
Removing the line feed character, and placing the entire command 
in 
one line will workaround the problem.   The placement of the 
line feed character may allow the command to work without have 
to 
put the entire command in one line, but to avoid hitting this 
APAR it is recommended to avoid using a line feed.
verfügbare FixPacks:
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
First fixed in DB2 Version 9.7, Fixpak 6
Workaround
see Local Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
02.09.2011
15.06.2012
15.06.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.
Problem behoben lt. FixList in der Version
9.7.0.6 FixList