|
Problem IC65876
|
Status: Geschlossen |
ADMIN_CMD COMMAND GENERATES FILES WITH NAMES PADDED WITH TRAILING BLANKS WHEN THE USER ID IS LESS THAN 8 CHARACTERS |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
db2 "call SYSPROC.ADMIN_CMD('import from staff.del of del
messages on server insert into staff')"
The above the servercommand generates message files on in
instance onwer's directory
/home/db2inst1/sqllib/tmp
Filename Example : IMPORT_62WD84_COGNOS
The above file format is made up of IMPORT (type of operation),
62WD84 (unique file identifier), and COGNOS (user name)
The issue here is, if the username is more than 8 characters, it
truncates it to 8 chars, but if it is less than 8 characters, it
pads trailing blanks to make it 8 characters which is a defect.
The ideal scenario should be if the username is a 3 character,
say for example: jay,
then ideally the file generated should look like
IMPORT_62WD84_JAY and not "IMPORT_62WD84_JAY " with 5
trailling blanks in the file name. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All users prior to DB2 V97 FP2 *
****************************************************************
* PROBLEM DESCRIPTION: *
* ERROR DESCRIPTION: *
* *
* db2 "call SYSPROC.ADMIN_CMD('import from staff.del of del *
* *
* messages on server insert into staff')" *
* *
* *
* *
* The above the servercommand generates message files on in *
* *
* instance onwer's directory *
* *
* /home/db2inst1/sqllib/tmp *
* *
* *
* *
* Filename Example : IMPORT_62WD84_COGNOS *
* *
* The above file format is made up of IMPORT (type of *
* operation), *
* 62WD84 (unique file identifier), and COGNOS (user name) *
* *
* *
* *
* The issue here is, if the username is more than 8 *
* characters, it *
* truncates it to 8 chars, but if it is less than 8 *
* characters, it *
* pads trailing blanks to make it 8 characters which is a *
* defect. *
* *
* *
* The ideal scenario should be if the username is a 3 *
* character, *
* say for example: jay, *
* *
* then ideally the file generated should look like *
* *
* IMPORT_62WD84_JAY and not "IMPORT_62WD84_JAY " with 5 *
* *
* trailling blanks in the file name. *
****************************************************************
* RECOMMENDATION: *
* No local workaround *
**************************************************************** |
| Local-Fix: |
Not Applicable |
| verfügbare FixPacks: |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
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 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
First fixed in DB2 V97 FP2 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 27.01.2010
25.05.2010
25.05.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP2
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.2
|
 |
