|
Problem IC64177
|
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 / 950 - 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 V95 FP6 *
****************************************************************
* 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 Fix *
**************************************************************** |
| Local-Fix: |
Not Applicable |
| verfügbare FixPacks: |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
First fixed in Db2 V95 FP6 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC65876 IC78158
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 27.10.2009
10.06.2010
10.06.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.5.FP6
|
| Problem behoben lt. FixList in der Version |
