|
Problem IC65876
|
Status: Closed |
ADMIN_CMD COMMAND GENERATES FILES WITH NAMES PADDED WITH TRAILING BLANKS WHEN THE USER ID IS LESS THAN 8 CHARACTERS |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem 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. |
| Problem Summary: |
****************************************************************
* 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 |
| available fix packs: |
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
|
| Solution |
First fixed in DB2 V97 FP2 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.01.2010
25.05.2010
25.05.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP2
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
