|
Problem IC64177
|
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 / 950 - 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 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 |
| available fix packs: |
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
|
| Solution |
First fixed in Db2 V95 FP6 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC65876 IC78158
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.10.2009
10.06.2010
10.06.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
